Commands and Syntax › SET

SET

SET permits the user to set system management parameters in a signon profile or during a session. While some parameters are initially defined at system generation, others are assigned values during the signon process.

Note: For more information about system generation, see the CA IDMS System Generation Guide and System Generation Options of this manual.

Syntax:

►►─── SET ─┬─ ACCess ─┬─────┬┬─ OLQ ◄ ──┬──────────────────────────────┬──────►─
           │          └─ = ─┘└─ IDMs ───┘                              │
           ├─ default SCHema ─┬─────┬─ schema-name ────────────────────┤
           │                  └─ = ─┘                                  │
           ├─ NULl ─┬─────────────┬─┬─────┬── null-character ──────────┤
           │        └─ character ─┘ └─ = ─┘                            │
           ├─ INTerrupt count ─┬─────┬─ interrupt-count ───────────────┤
           │                   └─ = ─┘                                 │
           ├─ CONtinuation character ─┬─────┬─ continuation-character ─┤
           │                          └─ = ─┘                          │
           ├─ SEParator character ─┬─────┬─ separator-character ───────┤
           │                       └─ = ─┘                             │
           ├─ COMment character ─┬─────┬─ comment-character ───────────┤
           │                     └─ = ─┘                               │
           ├─ default DBName ─┬─────┬─ database-name ──────────────────┤
           │                  └─ = ─┘                                  │
           ├─ default DBNOde ─┬─────┬─ database-node ──────────────────┤
           │                  └─ = ─┘                                  │
           ├─ default ─┬─ DICtname ─┬─┬─────┬─ dictionary-name ────────┤
           │           └─ CATalog ──┘ └─ = ─┘                          │
           │                                                           │
           └─ default DICTNOde ─┬─────┬─ dictionary-node ──────────────┘
                                └─ = ─┘
─►─────────┬───────────────────────────────────────────────────────────┬──────►◄
           ├─┬─ PRInt ──────┬─ SIZe ─┬─────┬─ print-line-size ─────────┤
           │ ├─ LINe ───────┤        └─ = ─┘                           │
           │ └─ PRInt LINe ─┘                                          │
           ├─┬─ PRInt ──────┬─ COUnt ─┬─────┬─ print-line-count ───────┤
           │ ├─ LINe ───────┤         └─ = ─┘                          │
           │ └─ PRInt LINe ─┘                                          │
           ├─ FUNction control-key-value ─┬─────┬─ command-line ───────┤
           │                              └─ = ─┘                      │
           ├─ MAXimum SORt SIZe ─┬─────┬─ sort-size ───────────────────┤
           │                     └─ = ─┘                               │
           ├─ REPort DICTname ─┬─────┬─ dictionary-name ───────────────┤
           │                   └─ = ─┘                                 │
           ├─ user-specification ──────────────────────────────────────┤
           ├─ DATe ─┬─────┬─ literal ──────────────────────────────────┤
           │        └─ = ─┘                                            │
           └─ CODetable ─┬─────┬─ code-table-name ─────────────────────┘
                         └─ = ─┘

Expansion of user-specification

►►─── USEr ─┬─────┬─ user-name ───────────────────────────────────────────────►
            └─ = ─┘

 ►─── PASsword ─┬─────┬─ user-password ───────────────────────────────────────►
                └─ = ─┘

 ►─┬──────────────────────────────────────────────────────────┬───────────────►
   └─ INTernal storage page size ─┬─────┬─ storage-page-size ─┘
                                  └─ = ─┘

 ►─┬─────────────────────────────────────────────────────────┬────────────────►
   └─ REPort file page size ─┬─────┬─ report-file-page-size ─┘
                             └─ = ─┘

 ►─┬─────────────────────────────────────────────┬────────────────────────────►◄
   └─ REPort DICtname ─┬─────┬─ dictionary-name ─┘
                       └─ = ─┘

Parameters:

ACCESS=

Specifies the type of table CA OLQ will access.

• OLQ— Allows you access to ASF tables.

The OLQ setting also allows you to use the SELECT statement with the following entities:

• ASF tables
• Logical records
• Database records
• Sequential files (batch only)

This is the default.

• IDMS— Allows you access to SQL tables when using the SELECT statement:

Access mode: Some CA OLQ commands are invalid when the access switch is set to IDMS.

Note: For more information about what commands become invalid, see the particular CA OLQ command in this chapter.

DEFAULT SCHEMA=

Sets a default schema so that any reference to table-name becomes schema.table-name.

Access mode: This parameter has no meaning when the access switch is set to OLQ.

Specifies the name of the schema. Schema-name be a name 1-18 characters long that follows the conventions for SQL identifiers.

Note: For more information about schemas, see the CA IDMS SQL Reference Guide.

NULL=

Specifies a display character used to portray data columns containing nulls. The default is the period (.).

Note: For more information about null processing, refer to the CA IDMS SQL Reference Guide.

INTERRUPT COUNT=

Specifies the number of records read before a retrieval is interrupted.

Note: See System Generation Options for details on setting the valid values during system generation.

CONTINUATION CHARACTER=

Specifies the character used to denote the continuation of a command. The continuation character is used in qfiles or batch input when the length of a CA OLQ command is greater than one line. The continuation character is a one-character alphanumeric value or special character. The system generation default is the hyphen (-).

SEPARATOR CHARACTER=

Specifies the character used to denote the separation of commands. The separator character is used to concatenate CA OLQ commands, permitting the entry of multiple commands on a single input line. The separator character is a one-character alphanumeric value or special character. The system generation default is the exclamation point (!).

Use with SELECT (IDMS mode)

Anytime you use separators with SELECT (IDMS mode) they must precede the SELECT statement.

For instance, the following is valid syntax:

delete table employee.job!select all from emp_id

However, CA IDMS/DB does not accept the syntax below because the separator (!) comes after the SELECT statement:

select all from emp_id!delete table employee.job

COMMENT CHARACTER=

Specifies the character used to denote the beginning of comments. The comment character signifies a remark; all text following the comment character is ignored during execution. The comment character is a one-character alphanumeric value or special character. The system generation default is the semicolon (;). All text following the comment character is ignored during execution.

Access mode: You cannot use comment characters with SELECT (IDMS mode) statements.

DEFAULT DBNAME=

Specifies the default database name.

DEFAULT DBNODE=

Specifies the default database node.

DEFAULT DICTNAME/CATALOG=

Specifies the default dictionary name.

DEFAULT DICTNODE=

Specifies the default dictionary node.

PRINT LINE SIZE=

Specifies the print line size.

PRINT LINE COUNT=

Specifies the print line count.

FUNCTION=

SET FUNCTION specifies a value for a control key.

• control-key-value— The control key that is being assigned a value. Valid control keys values are [PA1], [PA2], and 1 through 99 (corresponding to PF keys 1 through 99).
• command-line— The CA OLQ command that is assigned to the specified control key. If the command contains any special characters or embedded blanks, enclose command-line in quotation marks.

MAXIMUM SORT SIZE=

Specifies the amount of storage allocated for sorts.

• sort-size— The maximum size, in kilobytes, of main memory available for sorts. Sort-size is an integer in the range 1 to 32767. After this space is used, CA OLQ uses the scratch area for sorts.

REPORT DICTNAME=

Specifies the dictionary used for saving report information. Job control language for batch jobs is also stored here.

This command is valid only in CV batch mode.

• dictionary-name— The dictionary where the catalog containing saved report information resides. Dictionary-name is a 1 to 8-character alphabetic name.

  Note: If you don't set the dictionary name, the report is saved in the primary dictionary. You must set the dictionary name to match the one defined during system generation for storing reports. This keeps the online and batch reports stored in the same place. If you do not match the dictionary names, you can't use online CA OLQ to access the reports saved through batch.

user-specification

• USER=—Identifies auser to CA OLQ in online and batch environments. CA OLQ uses the ID and password you assign with the SET USER statement in place of the DC/UCF signon user ID and password.

  You can issue this command either in an online command mode CA OLQ session or in your batch job stream.

• user-id—The 1 to 32-byte alphanumeric user's identifier.
• PASSWORD=user-password—Assigns a password to the user. User-password is a 1 to 8-character alphanumeric literal.
• INTERNAL STORAGE PAGE SIZE=storage-page-size—For use in the CA OLQ batch environment only. Specifies the internal storage page size in bytes. Storage-page-size is an integer value in the range 1 to 32,767 and should be equivalent to the page size of the CA IDMS/DC region.

  Note: For more information about how to specify page sizes for the CA IDMS/DC region, see the CA IDMS System Generation Guide.

• REPORT FILE PAGE SIZE=report-file-page-size—For use in the CA OLQ batch environment only. Specifies the report file page size in bytes. Report-page-size is an integer value in the range 256 to 32,767 and should be equivalent to the page size of the CA IDMS/DC region.
• REPORT DICTNAME=dictionary-name—For use in the CA OLQ batch environment only. Specifies the name of the dictionary where the catalog containing saved report information resides. Dictionary-name is a 1 to 8-byte alphabetic name.

  Note: The SET USER command should always be the first CA OLQ batch command.

DATE=

Specifies the date format in CA OLQ. You can use this date option to change the format of the current date by including $DATE in a PAGE HEADER/FOOTER command.

• literal-string—A literal string that can consist of any combination of the following:
  • MONTH—The word MONTH specifies the name of the month in capital letters.
  • MON—The word MON specifies just the first three letters of the month name, in capital letters.
  • Mon—The word Mon specifies just the first three letters of the month name, with the initial letter capitalized.
  • Month—The word Month specifies the name of the month spelled out with the initial letter capitalized.
  • month—The word month specifies the name of the month spelled out in lowercase letters.
  • mon—The word mon specifies the first three letters of the month name in lowercase letters.
  • MM/ZM—The letters MM or ZM represent the month:

    MM specifies the month be displayed with leading zeros; for example, February would appear as 02.

    ZM specifies the month be displayed without leading zeros; for example, February would appear as 2.

  • DD/ZD—The letters DD or ZD:

    DD specifies the day be displayed with zeros; for example, Feb 9 would appear as Feb 09.

    ZD specifies the day be displayed without zeros; for example, Feb 09 would appear as Feb 9.

  • CC/YY/YYYY—The letters CC, YY, or YYYY to represent the year:

    CC specifies the year be displayed as the century number. For example, 20 would appear for any date between 1900 and 1999.

    YY specifies the year be displayed as the last two digits of the year. For example, the year 1996 would appear as 96.

    YYYY specifies the year be displayed as the entire four digit year. For example, the year 1996 would appear as 1996.

  You can specify these parameters in any order. Note that you can substitute the values themselves in place of the variables. For instance, instead of specifying DATE=Month DD, YYY, you can specify DATE = January 27, 1996.

CODETABLE=

Specifies the code table to translate menu mode syntax and month literals used in the $DATE function.

Examples:

INTERRUPT COUNT

In the following example, a SELECT statement retrieves all data occurrences for the EMPLOYEE record:

select * from employee

OLQ 098006 00  57 whole lines and 0 partial line in report.
OLQ 098007 00  57 records read.   57 records selected.

The following SET INTERRUPT COUNT command reduces the number of records read before a retrieval interruption occurs:

set interrupt count = 25

When another SELECT statement is issued for the EMPLOYEE record, CA OLQ retrieves only 25 record occurrences:

select * from employee

SET INTERRUPT COUNT 25
OLQ 092010 00  The interrupt count has been modified.
SELECT * FROM EMPLOYEE
OLQ 098006 00 25 whole lines and 0 partial lines in report.
OLQ 098007 00 25 records read.   25 records selected.
OLQ 098008 00 38 of 98 primary record pages read.
OLQ 098009 00 Continue (yes/no)?

SEPARATOR CHARACTER

In the following example, the SET SEPARATOR CHARACTER command identifies the percent sign (%) as the separator character:

set separator character = '%'

OLQ 092014 00  The SEPARATOR CHARACTER has been modified.

After the SET SEPARATOR CHARACTER command has been issued, the designated separator character is used to concatenate two CA OLQ commands:

select office-code-0450,office-street-0450 from office %display

                 OFFICE REPORT
                   mm/dd/yy

OFFICE-CODE-0450          OFFICE-STREET-0450

002                      567 BOYLSTON ST
001                      20 W BLOOMFIELD ST
008                      910 E NORTHSOUTH AVE
005                      7690 NEAR SIGHT AVE
012                      734 MASS AVE
END OF REPORT

COMMENT CHARACTER :p In the following example, the SET COMMENT CHARACTER command identifies the pound sign (#) as the comment character:

set comment character = '#'

OLQ 092015 00  The COMMENT/TERMINATOR CHARACTER has been modified.

The established comment character is used to enter remark text after a SELECT statement is issued:

select * from employee
 where emp-last-name like '%ing'#retrieves employees whose last names
 end in 'ing'

OLQ 104009 04  DISPLAY RIGHT to see more report columns
                              EMPLOYEE REPORT
                                 09/25/99

EMP-ID-0415  EMP-FIRST-NAME-0415  EMP-LAST-NAME-0415    EMP-STREET-0415

        106  DORIS                KING                716 MORRIS ST
  END OF REPORT

DEFAULT DICTNAME

In the following example, the SET DEFAULT DICTNAME command identifies DOCANWK as the default dictionary name:

set default dictname = docanwk

OLQ 092018 00  THE DEFAULT DICTNAME VALUE HAS BEEN
                MODIFIED.

When the following HELP command is issued, CA OLQ lists all subschemas that exist within the designated default dictionary:

help subschemas

    AVAILABLE SUBSCHEMAS     PAGE 1.1
                             LINE 1
    (SCHEMA)     (SUBSCHEMA)

 DICTIONARY NAME  DOCANWK
 DICTIONARY NODE  *DEFAULT*

 EMPSCHM(2)       EMPSS01
 EMPSCHM(100)     EMPSS01
                  EMPSS09
 TEST(100)        SUBTEST

SET FUNCTION

In the following example, a SHOW statement has been assigned to PF8:

set function 8 'show report'

When [PF8] is pressed in command mode, CA OLQ displays the description of the current report.