Previous | Contents | Index |
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.
sort field_name -
[,ASCENDING (D) or DESCENDING] -
[,BY_YEAR, BY_MONTH or BY_DAY] -
[,special_word]
#1 |
---|
sort division |
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
The following environment variables are frequently changed by a user to
work with the SCHEDULE system.
The main files are located by a default file specification or by explicitly defining one of the following environment variables.
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.
B.1 Dates and times
There are three basic ways of entering dates and times, they are:
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 |
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. |
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. |
Several different wildcards are recognized. They can be used in file names, job names, calendar names, and user name specifications. The various wildcards are:
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:"" |
Previous | Next | Contents | Index |