Define sort orders.

The 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 -

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

Examples

 
 
 
 
 
 
sort division 
 
 
 
 
      

Qualifiers

ascending

The ASCENDING option will cause this field to be sorted in an increasing fashion.

by_day

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

by_month

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

by_year

The BY_YEAR option will round off the field value to the nearest year. This is useful if the data is to be grouped by year. This can only be used with fields of type QD.

descending

The DESCENDING option will cause the field to be sorted in a decreasing fashion.

field_name

The field name must be the first word in the command. The field names are different for each database used in generating a report. Please refer 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 databases. Please refer to the description of the particular database.

A.1 Commonly used environment variables

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

The main files are located by a default file specification or by explicitly defining one of the following environment variables.

• SCHEDULE_LIBRARY - This defines the directory in which all SCHEDULE system files are placed.
• SCHEDULEMSG - This defines the location of the SCHEDULE message file. This message file contains all the definitions of all messages used by the SCHEDULE system. The default value is SCHEDULE_LIBRARY:SCHEDULEMSG.EXE.
• SCH0_QUEUE - This defines the location of the queue control file for the SCHEDULE system. The default value is SCHEDULE_LIBRARY:SCH0_QUEUE.DAT. The fourth letter of the name (i.e. the "0") is the SCHEDULE_GROUP_NUMBER.
• SCH0_CONTROL - This defines the location of the master control file for the SCHEDULE system. This file contains all the control data that defines each job, directory and calendar. The default value is SCHEDULE_LIBRARY:SCH0_CONTROL.DAT. The fourth letter of the name (i.e. the "0") is the SCHEDULE_GROUP_NUMBER.
• SCH0_HISTORY - This defines the location of the history data file for the SCHEDULE system. This file contains all the historical data that is recorded by the system. The default value is SCHEDULE_LIBRARY:SCH0_HISTORY.DAT. The fourth letter of the name (i.e. the "0") is the SCHEDULE_GROUP_NUMBER.

The graphic editor and monitor use certain environment variables to control the various colors and fonts that are used by the system. The following environment variables are used to hold these parameter values.

• SCX_FONT_BIG - This defines the font used for titles.
• SCX_FONT_MENU - This defines the font used for the menu bar.
• SCX_FONT_FIX - This defines fixed pitch font to use.
• SCX_FONT_BUTTON - This defines the font to use for the job boxes (or push buttons).
• SCX_COLOR_IDLE - This defines the color to use for IDLE jobs.
• SCX_COLOR_TIME_WAIT - This defines the color to use for jobs in the TIME WAIT scheduling queue.
• SCX_COLOR_LOCAL_PRE_WAIT - This defines the color to use for jobs in the LOCAL PREREQUISITE WAIT scheduling queue.
• SCX_COLOR_REMOTE_PRE_WAIT - This defines the color to use for jobs in the REMOTE PREREQUISITE WAIT scheduling queue.
• SCX_COLOR_FILE_WAIT - This defines the color to use for jobs in the FILE WAIT scheduling queue.
• SCX_COLOR_DISK_WAIT - This defines the color to use for jobs in the DISK SPACE WAIT scheduling queue.
• SCX_COLOR_READY - This defines the color to use for jobs in the READY TO SUBMIT scheduling queue.
• SCX_COLOR_QUEUE - This defines the color to use for jobs in the SUBMITTED scheduling queue.
• SCX_COLOR_EXECUTE - This defines the color to use for jobs EXECUTION STARTED scheduling queue.
• SCX_COLOR_COMPLETE - This defines the color to use for jobs that have completed.
• SCX_COLOR_EDIT - This defines the color to use for jobs that are being edited.
• SCX_COLOR_FAIL - This defines the color to use for jobs that have failed

B.1 Dates and times

• Absolute time
• Delta time
• Combination time

Anywhere a time can be specified as input, any of the above formats can be used.

B.1.1 Absolute time

An absolute time is a specific date and/or time of day. The format for an absolute time is:

[dd-mmm-yyyy[:]][hh:mm:ss.cc]

The variable fields are listed in the following table.

Field	Meaning
dd	Day of the month; an integer in the range of 1 - 31
mmm	Month; specified as JAN, FEB, MAR, APR, MAY, JUN, JUL, & AUG, SEP, OCT, NOV, or DEC
yyyy	Year; an integer
hh	Hour of the day; an integer in the range or 0 - 23
mm	Minute of the hour; an integer in the range 0 - 59
ss	Second of the minute; an integer in the range 0 - 59
cc	Hundredth of the second; an integer in the range 00 - 99

You can specify an absolute time value using either the date or the time or both.

If you specify the date (dd-mmm-yyyy) and the time (hh:mm:ss.cc), you must type the colon between the date and the time. You can also truncate either the date or the time on the right; however, the date, if specified, must always contain at least one hyphen.

You can omit any of the fields with the date or time as long as you type the punctuation marks; the system supplies default values. If you omit a field from the date, the system supplies the corresponding field for the current date. If you omit a field from the time, the system supplies a default value of zero.

Several keywords can be used for the absolute time. The various keywords and their meanings are listed below.

Keyword	Meaning
NOW	The current date and time
TODAY	The current day, month, and year at 00:00:00.00 o'clock
TOMORROW	24 hours after 00:00:00.00 o'clock today
YESTERDAY	24 hours before 00:00:00.00 o'clock today
NONE	No value, clear the date field

Some examples are listed below.

Specification	Meaning
15-APR-1985:12	12:00 noon on April 15, 1985
15-APR	Midnight (00:00 o'clock) at the beginning of the 15th of April this year.
15	3:00 PM today
15-	The 15th of the current month, day and year at midnight
18:30	6:30 PM today
15--::30	00:30 o'clock, on the 15th day of the current month and year.

B.1.2 Delta time

A delta time is an offset from the current time. The format for a delta time is:

[+/-][dddd-][hh:mm:ss.cc]

The various fields are defined below.

Field	Meaning
ddd	Number of days; an integer in the range 0 - 9999
hh	Number of hours; an integer in the range 0 - 23
ss	Number of seconds; an integer in the range 0 - 59
cc	Number of hundredths; and integer in the range 00 - 99

You can truncate a delta time on the right. You can also omit any of the fields as long as you supply the punctuation marks. Truncated or omitted fields default to zero. You can begin a delta time with either the day or the time field. If you begin with a day, you must include the dash.

Several examples are listed below.

Specification	Meaning
3-	3 days from now
3	3 hours from now
:30	30 minutes from now
15:30	15 hours and 30 minutes from now
-1	1 hour before the current time
-1-00:00	1 day before the current time

Do not use the delta time format in places where the command interpreter also accepts absolute or combination time formats. In these places, you must use the combination time format to specify and offset from the current time.

B.1.3 Combination time

Combination time consists of an absolute time value plus or minus a delta time value. The delta time portion of the combination time must always be preceded by a plus or minus sign.

[absolute time] +/- [delta time]

When you specify a combination time, you can omit the absolute time. If you omit the absolute time, the delta time is an offset from the current date and time. If you specify any part of the absolute time, the defaults are those specified in the description of absolute times. However, it is recommended that you specify the date-time information as completely as possible.

The variable fields and default fields for absolute and delta times are the same as those described in the preceding sections. Several samples of combination time formats are listed below.

Specification	Meaning
+5	Current time plus 5 hours. The absolute time portion is omitted so it defaults to the current date and time.
+:5	Current time plus 5 minutes. The absolute time is omitted so it defaults to the current date and time.
15-APR:+:5	12:05 AM on April 15 of the current year. The absolute time specification (before the colon) defaults to midnight on April 15 of the current year. The plus sign indicates a positive offset.
TOMORROW+1-00:00	Tomorrow plus 1 day.
-:5	Current time minus 5 minutes. The absolute time specification is omitted so it defaults to the current date and time.
-1	Current time minus 1 hour. The minus sign indicates a negative offset. The one indicates hours since it is not followed by a dash.
-1-00	Current time minus 1 day. The minus sign indicates a negative offset. The dash between the 1 and 00 indicates that this is a number of days.
15-APR:-00:10	11:50 PM on April 14 of the current year.

B.2 Wildcards

Several different wildcards are recognized. They can be used in file names, job names, calendar names, and user name specifications. The various wildcards are:

• ASTERISK (_*): An asterisk will compare any number of characters. For example; A_* will compare successfully with ABC, AAAA, and A.
• PERCENT (_%): A percent sign will compare with any one character. For example; A% will compare successfully with AB, AX or AA, but not with A or ABC.
• ELLIPSIS (...): Ellipsis can only be used in a file directory specification. It indicates that all sublevel file directories are to be examined.

The above wildcards can be combined into a very complex search string.

In particular, the job specification "[*]*,[*.*]*" will traverse the complete directory tree to access all of the jobs in the SCHEDULE database. Correspondingly, The directory specification "[*],[*.*]" will traverse the complete directory tree to access all of the directories in the SCHEDULE database.

B.3 Text strings

Many fields allow text strings to be supplied. Text strings with no embedded blanks do not need to be enclosed with quotes. All others do. For example:

chjob /demo/d/a1 -general=comment:"first job" chjob /demo/d/a1 -general=comment:first_job

To reset a field to a null value, enter the null string.

chjob /demo/d/a1 -general=comment:""