cDSCHEDULE Automated Job Submission System Guide and Reference �ManualD

SCHEDULE
Automated Job Submission System
Guide and Reference Manual

o T Y

SORT

Define sort orders.
HThe SORT command will sort a specified column without printing it. This ;is an alternate to the SORT qualifier in the PRINT command.

General format

SORT field_name -
B
[,ASCENDING (D) or DESCENDING] -
[,BY_YEAR, BY_MONTH or BY_DAY] -
[,special_word]

Examples

#1
SORT DIVISION

Qualifiers

ASCENDING
>The ASCENDING option will cause this field to be sorted in an increasing fashion.
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 used with fields of type QD.
DESCENDING
HThe DESCENDING option will cause the field to be sorted in a decreasing fashion.
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.
SPECIAL_WORD
@Special options are available when extracting data from certain Fdatabases. Please refer to the description of the particular database.

Part 5
APPENDICES

HThis part of the manual contains all the appendices including a command 5summary with brief descriptions of all line commands.

Appendix A
Logical names

DA variety of logical names are used throughout the SCHEDULE and MCL systemsBThey are used to contain both file names and parameter values. In Hgeneral if not explicitly DEFINED then built-in default values are used.

[

A.1 Commonly used logicals

EThe following logicals are frequently changed by a user to work with the SCHEDULE system.

SCHEDULE_DEFAULT_DIRECTORY - This defines the default directory in I the SCHEDULE system that will be used by all commands. This isBthe same has having explicitly include the directory name in each Ccommand. If not defined then the default directory is the person's username.E
SCHEDULE_DATABASE_NODE - This defines the target node for all commands issued. ByCdefault the current node is the target. This is the same as adding /NODE=node to every DCL command.B
SCHEDULE_GROUP_NUMBER - This defines which server group to E communicate with. Several scheduling groups can be run on the same systemEat the same time. Each group is completely independent of the other. EThere is no way for one group to communicate with another group. The default group number is "0".

o V T Y

Contents

Index

SCHEDULE Automated Job Submission System Guide and Reference Manual

SORT

General format

SORT field_name -

Examples

Qualifiers

ASCENDING

BY_DAY

BY_MONTH

BY_YEAR

DESCENDING

FIELD_NAME

SPECIAL_WORD

Part 5APPENDICES

Appendix ALogical names

A.1 Commonly used logicals

SCHEDULE
Automated Job Submission System
Guide and Reference Manual

Part 5
APPENDICES

Appendix A
Logical names