Operand Definitions

CA Ideal Commands › SET DBSQL Command (CA Datacom SQL Access) › Operand Definitions

Operand Definitions

Operand	Description
AUTH	Establishes the authorization ID for the access plan. Specify: auth‑id A one‑ to eight‑character value. Note: You can enter this command as AUTHID auth‑id, ATZ auth‑id, or as AUTH auth‑id. The AUTHID abbreviation is valid only for this command and is not a generally accepted abbreviation. Also, the first character of the auth‑id must be a special character (@, #, $, and so on). It cannot be a numeric digit. CA Datacom enforces this rule.
CBSIO	Determines the I/O limit interrupt value for SQL statements that creates a set. Specify: nnnnnn A value from 0‑524287.
DATE	Displays the format for SQL date type items. Specify: DB CA Datacom installed default. ISO International Standards Organization: yyyy‑mm‑dd USA U.S. standard: mm/dd/yyyy EUR European standard: dd.mm.yyyy JIS Japanese Industrial Standard: yyyy‑mm‑dd
DECPOINT	Specifies the character used as the decimal point when data displays. This has no effect on how the data is stored. Specify: P Period (.) is used as the decimal point and comma is used as the digit separator. This is the default. C Comma (,) is used as the decimal point and period (.) is used as the digit separator.
ISOLATION‑LEVEL	Establishes the degree to which a unit of recovery is isolated from the updating operations of other units of recovery. Specify: CS Cursor stability. (CS) is required if you are doing updates, deletes, or inserts. You can abbreviate the keyword ISOLATION‑LEVEL to ISO. R Repeatable read. U No locks are acquired
MODE	Establishes the mode in which CA Datacom processes the program. Specify: ANSI or ANSI86 (they are the same) Datacom FIPS
OPTMODE	Establishes the mode in which CA Datacom optimizes the plan by ordering joins. Specify one of the following orders: PREP Order joins during bind processing. MAN Order joins as specified in FROM clauses. EXEC Order joins at execution time.
OPTMSGS	Specifies the type of optimization messages CA Datacom produces during bind processing (PREP) or during execution (EXEC). Specify: NON None (default) DET Detail SUM Summary
PRIORITY	Specifies the priority of the SQL requests. Specify: nn A value from 1 through 15, where the lowest priority is 1 and the highest priority is 15.
STRDELIM	Specifies the character that delimits string values in all SQL statements. Specify: A Apostrophes (') delimit string values. This is the default. Q Quotation marks (“) delimit string values.
TIME	Displays the format for SQL time type items. Specify: DB CA Datacom/DB installed default ISO International Standards Organization: hh.mm.ss USA U.S. standard: hh:mm AM or PM EUR European standard: hh.mm.ss JIS Japanese Industrial Standard: hh:mm:ss
WAIT	Determines the exclusive control wait limit. Specify: nnn The number of minutes or seconds from 1 to 120. Then specify: SEC for seconds or MIN for minutes. For example, for a ten‑second wait: WAIT 10 SEC.

SET EDIT Command

This command establishes the default values used while editing.

This command has the following format:

                 {  { BOUNDS  }  { num‑1 [ MAX   ] }}
                 {  { COLUMNS }  {       [ num‑2 ] }}
                 {                                  }
                 {  CASE { UPPER }                  }
                 {       { MIXED }                  }
                 {                                  }
                 {  CONTEXT n                       }
                 {                                  }
                 {  HIGHLIGHT { OFF    }            }
                 {            { ERRORS }            }
                 {                                  }
SET (SITE) EDIT  {  MARGIN { RIGHT }                }
                 {         {LEFT   }                }
                 {                                  }
                 {  MULTIPLIER { RIGHT }            }
                 {             { LEFT  }            }
                 {                                  }
                 {  TRUNCATION { Y/ON  }            }
                 {             { N/OFF }            }