cDSCHEDULE Automated Job Submission System Guide and Reference �ManualD

SCHEDULE
Automated Job Submission System
Guide and Reference Manual


 o T Y  
PreviousContentsIndex


>

SELECT



Select records.

EThe SELECT command determines what records are processed and printed.




General format



SELECT field_name -

8
SELECT field _name -
[,INCLUDE = selection or :(selection,selection...)] -
[,EXCLUDE = selection or F(selection,selection...)] -
[,FROM = date] -
[,TO = date] - E
[,MINIMUM = number] -
[,MAXIMUM = number] -
[,IFSET = Bflag or (flag,flag...)] -
[,IFCLEAR = flag or (flag,flag...)]



Examples

 6    
#1

 
    *SELECT DATE,FROM=1-JAN-1986,TO=1-APR-1996      


EEach selected record MUST MEET ALL SELECT conditions present. If you Hhave two SELECT statements, one that selects account A and another that *selects account B no data will be printed.


Qualifiers

9

EXCLUDE = selection or (selection,selection...)

EThe EXCLUDE option will exclude certain records if the value matches Eany one of the supplied selection strings. Each SELECT statement can Fhave a maximum of 20 exclude selection strings. This can only be used Bwith fields of type T. This exclude selection can be prompted for.

FIELD_NAME

FThe field name must be the first word in the command. The field names Dare different for each database used in generating a report. Please Grefer to the Field Table for the particular database. This name can be prompted for.7

FROM = date (Default = start of current month)

BThe FROM option specifies the start of a date range that is to be Fselected. The date can be any valid VMS combination time format. This Hcan only used with fields of type QD. The from date can be prompted for.)

IFCLEAR = flag or (flag,flag...)

CThe IFCLEAR option selects records if the specified field does NOT Gcontains the specified flag. This can only be used with fields of type 5QM, LM, WM or BM. The flag names can be prompted for.'

IFSET = flag or (flag,flag...)

EThe IFSET option selects records if the specified field contains the Hspecified flag. This can only be used with fields of type QM, LM, WM or +BM. The set flag names can be prompted for.8

INCLUDE = selection or (selection,selection...)

HThe INCLUDE option selects records if the field contains any one of the >specified selection strings. The supplied strings can contain Bwildcards. Each select statement can have a maximum of 20 include Aselection strings. This can only used with fields of type T. The 'include selections can be prompted for.

MAXIMUM = number

FThe MAXIMUM options selects records that are less than this quantity. HThis can only be used with fields of type Q, L, W, B, QU, LU, WU or BU. 'The maximum number can be prompted for.

MINIMUM = number

HThe MINIMUM option selects only records where the field is greater than Fthis value. This can only be used with fields of type Q, L, W, B, QU, 4LU, WU or BU. The minimum value can be prompted for.

SPECIAL_WORD

@Special options are available when extracting data from certain Fdatabases. Please refer to the description of the particular database."

TO = date (Default = NOW)

GThe TO option specifies the end of a date range. Any valid combination Htime format can be specified. This can be used only with fields of type $QD. The to date can be prompted for.




 o V T Y  
PreviousNextContentsIndex