cDSCHEDULE Automated Job Submission System Guide and Reference �ManualD

SCHEDULE
Automated Job Submission System
Guide and Reference Manual


 o T Y  
PreviousContentsIndex


<

PRINT



Define a print column.

EThe PRINT command determines what data is printed, using what format and in what order.




General format



PRINT field_name -

H
[,BY_YEAR, BY_MONTH or BY_DAY] -
[,NEW_PAGE_ON_CHANGE] -
F[,EDIT_STRING = "edit_string"] -
[,IF field_name = value] -
<[,NODETAIL] -
[,SORT = ASCENDING or DESCENDING] -
G[,special_word] -
[,TITLE = "string/string/..."] -
[,TOTAL = (break_field,break_field,...)] -



Examples

 6    
#1

 
   )PRINT SIZE,NODETAIL,SORT,TOTAL=DIRECTORY     





Qualifiers



BY_DAY

EThe BY_DAY option will round off the field value to the nearest day. EThis is useful if the data is to be grouped by day. This can only be used with fields of type QD.

BY_MONTH

BThe BY_MONTH option will round off the field value to the nearest Fmonth. This is useful if the data is to be grouped by month. This can $only be used with fields of type QD.

BY_YEAR

GThe BY_YEAR option will round off the field value to the nearest year. FThis is useful if the data is to be grouped by year. This can only be Fused with fields of type QD. Edit_string supplies the format to print Cthe field value in. Please refer to the section describing all the #various elements of an edit string.

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.$

IF field_name = field_value

DThe IF option allows a value in one field only to be printed in the Hspecified column if the value in another field has a certain value. The Evalue specification can contain wildcards. Only type T fields can be referenced in this option.

NEW_PAGE_ON_CHANGE

EThis option will force a new page to be started whenever the data in this field changes.

NODETAIL

ENodetail suppresses all detail lines for that group. This is used in Econjunction with IF and TOTAL to cause only group totals to printed, +with no detail information from each entry.

SPECIAL_WORD

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

SORT [= ASCENDING (D) or DESCENDING]

=The sort option will cause the specified column to be sorted.$

TITLE = "string/string/..."

HTitle establishes the column heading for this print column. The default Fheading is just the field name. Several lines can be defined for each Hheading. Each line is separated by a "/" slash. The title string can be prompted for..

TOTAL = (break_field,break_field,...)

HTotal sets up group totals. Only break fields that have been sorted can Fbe totalled. The break fields mentioned in this option can only be of Etype T or QD. This option is only meaningful for totalling numerical fields.




 o V T Y  
PreviousNextContentsIndex