Following are descriptions of the DQOPTLST parameters, their valid entries, and their default values. They are listed in alphabetical order.
Specifies whether associate users can modify their own user profile and print options.
NO or YES
NO
Specifies whether the Audit Facility is to be active.
OFF or ON
OFF
Specifies the name of the module if the exit is to be linked as a separate module,. The module is used in the Batch Line Printer Exit.
1- to 8-character module name
(No default)
Specifies the amount of space to be reserved in task-related storage for a special work area used as an input row buffer.
Code BUFSIZE as the length of the largest user CA Datacom/DB row to be accessed by CA Dataquery. The value should not be larger than what is coded in DATALN in the CA Datacom/DB Master List. Also, the value should not be smaller than what is coded for DQESIZE=.
4600 or greater
4600
Specifies the format used to display columns which are defined as date fields with the SEMANTIC-TYPE attribute. For more information about the updateable attributes of FIELD entity-occurrences, see the CA Datacom Datadictionary Online Reference Guide.
1- to 30-character format name
A
Specifies that database IDs greater than 999 are to be used by the DBID exit. For more information about the DBID exit see the descriptions of CDBXITB= and CDBXITO= and the information about the DBID exit in DBID Exit.
NO or YES
NO
Specifies the name of batch DBID exit. Must not be the same as any CA Dataquery module name.
1- to 8-character module name
(No default)
Specifies the name of the online DBID exit. Must be in PPT and must not be the same as any CA Dataquery module name.
1- to 8-character module name
(No default)
Specifies one or two characters to indicate the beginning of a comment within the text of a query. The value must be unique among CMTEND=, DIAFILL=, DIASYMB=, HDGSEP=, HDGSUB=, and LITMASK=.
One or two characters
Do not use:
You must not code a single arithmetic operator (= - + / *). You may use - and + and / and * together for two character values. However, in a z/VSE environment, changing the COMMENT BEGIN character to /* causes problems when using the CA Dataquery online SUBMIT function.
*/
Specifies one or two characters to indicate the end of a comment within a query. The value must be unique among CMTBEG=, DIAFILL=, DIASYMB=, HDGSEP=, HDGSUB=, and LITMASK=.
One or two characters
Do not use:
You must not code a single arithmetic operator (= - + / *). You may use - and + and / and * together for two character values.
/*
Specifies the level of access provided when the external security resource cxxname.DQACCESS.CONVUSR is specified with "ALL" access. See the CA Datacom Security Reference Guide for more details about CA Dataquery and external security.
ASSOCIATE
CONVENTIONAL
Specifies the name of the user exit to examine the data rows retrieved by a DQL Mode query. The name must be in the PPT and not the same as any CA Dataquery module.
1- to 8-character module name
(No default)
Specifies the format to use to print columns in DQL Mode and SQL Mode which are defined as SQL date types.
EUR (dd.mm.yyyy)
ISO (yyyy-mm-dd)
JIS (yyyy-mm-dd)
USA (mm/dd/yyyy)
USA
Specifies the CA Datacom/DB database ID for the CA Datacom Datadictionary ordinarily accessed by CA Dataquery. Normally you would identify the locaCA Datacom Datadictionary database. This is the CA Datacom Datadictionary in which all CA Dataquery DQL Mode security information is stored regardless of the DDDBID specified in the user's profile.
A valid database ID
00002
Specifies the method CA Dataquery is to use to build the PRINT or DISPLAY column headings if the query does not specify a heading. (If the query provides the heading, CA Dataquery uses it no matter how this parameter is coded.) The value consists of two subparameters separated by a comma and enclosed within parentheses.
Note: YES is honored only if the appropriate values have been coded for the column heading attributes HEADING-1 and HEADING-2 in CA Datacom Datadictionary. If none have been coded, CA Dataquery takes the NO option.
(YES,1) -- CA Dataquery obtains the heading from the CA Datacom Datadictionary column heading attribute HEADING-1.
(YES,2) -- CA Dataquery uses the headings from the CA Datacom Datadictionary HEADING-1 and HEADING-2 column heading attributes.
(NO,1) or (NO,2) -- CA Dataquery uses either an alternate name specified within the query or the occurrence name of the column or key, in that order.
(YES, 2)
Specifies the edit pattern CA Dataquery is to use for numeric columns if no edit pattern is specified in the query. (If an edit pattern is specified in the query with the PICTURE clause, CA Dataquery uses it no matter how this parameter is coded.)
If you code YES, CA Dataquery uses the edit pattern coded in CA Datacom Datadictionary. If the column has an invalid edit pattern in CA Datacom Datadictionary (one that does not fit the data), CA Dataquery issues an error message and does not process the query.
If you code YES but no edit pattern is provided in CA Datacom Datadictionary, CA Dataquery builds its own edit pattern as described in the NO option.
If you code NO, CA Dataquery checks with CA Datacom Datadictionary to get the defined precision and builds a PICTURE that displays all digit positions and inserts a decimal point and sign if needed.
NO or YES
YES
(Code only if using a language other than English.) Specifies the character to use to indicate the decimal point when printing numeric values. DECPT= is used only in conjunction with the Language Maintenance Facility.
The words PERIOD or COMMA
PERIOD
Specifies a dialog fill character, used in the dialog text as a space saver for variables so that values longer than their default are allowed. Use this parameter to set the dialog fill character for your site. (See the CA Dataquery User Guide or CA Dataquery Reference Guide for information about dialogs.) The value must be unique among LITMASK= and DIASYMB=, and it must not be the same as any part of the values assigned to CMTBEG= and CMTEND=.
Single character
Do not use:
An underscore character ( _ )
Specifies a dialog symbol, used in the dialog text to mark a word or value as a variable. Use this parameter to set the dialog symbol for your site. The specified value must be unique among LITMASK= and DIAFILL= and must not be the same as any part of the values assigned to CMTBEG= and CMTEND=.
Single character
? (A question mark character)
Specifies the CA Datacom/DB database ID for the CA Dataquery database.
A valid database ID
00003
Specifies the record size of the DQE table (block size minus 14). At installation, the block size is set to 4096. A record size 4082 means the largest total column length for data is 4030 (record size minus 52). If this is not sufficient for SQL retrieval of one row, redefine the DQE table through CA Datacom Datadictionary, reallocate and reinitiate the DQE table, and change this parameter to reflect the new size.
(Block size of DQE) minus 14
4082
Specifies the transaction ID to use in place of the DQIN transaction on this CA Dataquery system.
Any 1- to 4-character TRANSID
DQIN
Specifies the transaction ID to use in place of the DQPR transaction on this CA Dataquery system.
Any 1- to 4-character TRANSID
DQPR
Specifies the transaction ID to use in place of the DQRY transaction on this CA Dataquery system.
Any 1- to 4-character TRANSID
DQRY
Specifies the name of the Data Stream Input Exit, if any. Must be in CICS PPT and not the same as any CA Dataquery module.
1- to 8-character module name
(No default)
Specifies the name of the Data Stream Output Exit, if any. Must be in CICS PPT and must not be the same name as any CA Dataquery module.
1- to 8-character module name
(No default)
This parameter is no longer used but is kept for compatibility.
Specifies the number of minutes that may elapse between entries to the terminal. If the specified time is reached, CA Dataquery signs off the user the next time an entry is made at the terminal. Thus CA Dataquery prevents an unauthorized user from accessing data if the user who signed on leaves the terminal unattended for the specified length of time.
1—1440
1440
Specifies the name of the character to use as a delimiter in the batch export file. It is used as a delimiter between variables when the export function is used in batch CA Dataquery. It is also used in all records: header, data, and trailer.
Any character except commas
, (comma)
(z/VSE only) Specifies the device type used by batch CA Dataquery for export data sets. You can change it on the Batch Execute panel if your JCL supports the selected device type. The device type specified in this parameter is used for all deferred batch jobs.
DISK or TAPE
TAPE
(Online only.) Specifies the total number of logical blocks on the DQF (Found Table) one user can allocate during processing of the FIND statement of a query. This limit ensures adequate space for all the users. When the limit is exceeded, CA Dataquery ends the search with one of two messages, either:
DQ472I - LIMIT EXCEEDED - FOUND NNNNNN, or DQ478I - LIMIT EXCEEDED - NO ROWS FOUND.
These messages are also generated whenever the limits set in the MFTIME= or SRCHLIM= parameter are exceeded. To find out if the message you receive has been generated by a FNDBLKS=, MFTIME=, or SRCHLIM= limit, either use a PF key from the Print Output panel, or view the Find Statistics panel by issuing the STATS command and check the FIND TERMINATED BECAUSE column for one of the following:
FNDBLKS: MAX WORK TABLE BLOCKS EXCEEDED MFTIME: MAX ELAPSED TIME EXCEEDED SRCHLIM: SITE I/O LIMIT (DQOPTLST.SRCHLIM) EXCEEDED
To estimate the total number of logical rows that can be stored per logical block, use the following formula:
ROWS = 760 / [ 6 + (n x 18) ]
where x is the number of tables named in the query.
For example, if the user names one table in a query (no RELATED, SET, or SORT statements), then:
ROWS = 760 / [ 6 + (1 x 18) ] = 33
Thus, if the default value for FNDBLKS is used (10 logical blocks), up to 330 logical rows could be stored by a user with one execution of a FIND that names only one row type.
This parameter sets the system default. You can override this value for specified users individually. See Authorizing Users. If you override, consider the extra blocks when you allocate space.
1—9999999
10
Specifies a separator character to be used to separate line one and line two of a two-line column heading for a column or key when it is specified in the text of a query. If a single character is used for CMTBEG= and/or CMTEND=, the same character should not be used for HDGSEP=.
See the CA Dataquery User Guide or CA Dataquery Reference Guide for more information about specifying column headings.
Single character
Do not use:
/ (a slash)
Specifies two characters that indicate to CA Dataquery that it should substitute the value of the control break column of a DO statement for the two characters. If two characters are used for CMTBEG= or CMTEND=, the same two characters should not be used for HDGSUB=. If a single character is used for CMTBEG= or CMTEND=, that character should not be used in HDGSUB=.
See the CA Dataquery User Guide or CA Dataquery Reference Guide for more information about the DO statement.
Two characters
Do not use:
&& (two ampersands)
Specifies the hex value of the code which causes the terminal to shift into double byte character mode.
0F
(No default)
Note: These values are supplied by the CA Datacom/DB MUF, overlaying what is specified here.
Specifies the hex value of the code which causes the terminal to shift out of double byte character mode.
0E
(No default)
Note: These values are supplied by the CA Datacom/DB MUF, overlaying what is specified here.
Specifies the length of each line for the printing of a batch query. This parameter is equivalent to NETPRTC= for a network printer.
80—150
133
Specifies the number of lines per page for the printing of a batch query. This parameter is equivalent to NETPRTP= for a network printer.
24 or greater
66
Specifies a literal masking character to be used in literals in the WITH clause of a FIND statement to indicate positions for which any value is acceptable. The value must not be the same as any part of the values assigned to CMTBEG= and CMTEND= and must be unique among DIAFILL=, DIASYMB=, HDGSEP=, and HDGSUB=.
See the CA Dataquery User Guide or CA Dataquery Reference Guide for more information about using masking characters in the WITH clause.
Single character
Do not use:
# (pound sign)
Specifies a maximum limit for I/O for DQL queries. If CA Dataquery estimates that a DQL query will exceed this I/O limit, it issues a warning message and allows the user to choose to continue with the query or to cancel it.
0—9999999
9999999
(Online only.) Specifies the maximum number of seconds allowed to elapse during the execution of a FIND statement. If the specified time is exceeded, CA Dataquery ends the search with one of two messages, either:
DQ472I - LIMIT EXCEEDED - FOUND NNNNNN, or DQ478I - LIMIT EXCEEDED - NO ROWS FOUND.
These messages are also generated whenever the limits set in the FNDBLKS= or SRCHLIM= parameter are exceeded. To find out if the message you receive has been generated by a FNDBLKS=, MFTIME=, or SRCHLIM= limit, either use a PF key from the Print Output panel, or view the Find Statistics panel by issuing the STATS command and check the FIND TERMINATED BECAUSE column for one of the following:
FNDBLKS: MAX WORK TABLE BLOCKS EXCEEDED MFTIME: MAX ELAPSED TIME EXCEEDED SRCHLIM: SITE I/O LIMIT (DQOPTLST.SRCHLIM) EXCEEDED
Specifying a zero means that you want no limit placed on how long a FIND can take.
0—999999999
0
(Online only.) Specifies the number of CA Datacom/DB I/O events CA Dataquery is to allow during a query execution before it relinquishes control of the resources in use and reschedules the remainder of the task. CA Dataquery then issues a message "Still in progress." This feature keeps one query from monopolizing the CICS system.
MXREQ works with the MXTLR parameter to set the length of time CA Dataquery is to process before pausing to allow the user to end the query.
This parameter sets the system default. You can override this value for specified users. See Authorizing Users.
1—9999
100
Specifies the total number of KEEP or EXTRACT row collections a user can save in the DQF (Found Table) at any given time. MXSETS, FNDBLKS and XTRBLKS control the space requirements for the DQF.
1—999
5
(Online only.) Specifies the number of times CA Dataquery is to relinquish control to other tasks during a query execution before pausing to allow the user to end processing. When the value is reached CA Dataquery displays the message "Do you want to continue?" See the discussion of MXREQ for details.
This parameter sets the system default. You can override this value for specified users. See Authorizing Users.
1—9999
10
Specifies the default network printer ID used as the destination of a query output. It can be overridden on a per user basis using the PROFILE command in online CA Dataquery or through the Online Execution panel.
4-character CICS terminal ID of a printer
(No default)
Specifies the number of columns per line for print routed to an online network printer. To override the value for a specific user, use the PROFILE command in online CA Dataquery and change the specification for PRINT NUMBER OF COLUMNS.
80—255
80
Specifies the lines per page of the network printers. To override the value for a specific user, use the PROFILE command in online CA Dataquery and change the specification for PRINT NUMBER OF ROWS.
12—255
66
Specifies that users are allowed to change passwords on the Signon panel. If NO is specified, only an Administrator with User Maintenance authorization can change user passwords.
NO or YES
YES
Specifies whether to open dynamically-built User Requirements Tables for update (U) or read-only (R) or not at all (N).
N, R, or U
U
Specifies the operating system.
OS
DOS
Specifies the name of the Online Output exit to be called as output rows are read.
1- to 8-character module name
(No default)
Specifies the name of the Batch Output exit to be called as output rows are read.
1- to 8-character module name
(No default)
Specifies the name of an existing database area to use for personal tables. The value may be overridden for each user. This area is used when using DATACOM extensions to SQL.
Name of an existing area
CA Datacom/DB default area if no area named
Specifies the precision to use on a SET statement in DQL Mode when precision is not specified.
(I,D) Where I is the number of integer digits left of the decimal point and D is the number of decimal digits right of the decimal point and I + D is less than or equal to 18.
(10,5)
Specifies the maximum number of pages of report output a user can send to a 3284 or 3286 printer for any given query.
1—999
10
Specifies the maximum number of 24-line query pages that a query can occupy. Each page beyond 1 requires approximately 5K additional bytes of task related storage while the transaction is active, and 5K more of auxiliary temporary storage per session if the pages are actually used. If you are using the Guided Query Creation Facility, specify a minimum of 2.
1—4
1
Specifies whether you can partition the public query library at the group level. Code YES to use group level access authorization partitioning of the query library.
NO or YES
NO
Specifies number of times DQBATCH should retry getting a DQW partition when all are marked in use before going to end of job when none are available. DQBATCH waits 30 seconds between retries.
1—9999
5
Specifies a character string, enclosed within apostrophes, that CA Dataquery is to use as the first heading line of all query reports printed on a 328x hardcopy printer or line printer. This heading is printed as the primary heading on every report produced. Use the TITLE1 clause of the PRINT statement to produce a second line, and the TITLE2 clause to produce a third line.
1—30 characters, enclosed within apostrophes
(No default)
Specifies the number of seconds SQL Mode batch CA Dataquery is to wait before reusing a found set in the Work Table (DQE) which is marked as being "in use." Sets may be left marked "in use" after a system failure or batch CA Dataquery abend.
60—32000
14400
Specifies the number of seconds batch CA Dataquery is to wait before reusing a partition of the Work Table (DQW) which is marked as being "in use." Partitions may be left marked "in use" after a system failure or batch CA Dataquery abend. When CA Dataquery is unable to allocate a partition, the message "CA Dataquery WAITING FOR RESOURCES" appears.
60—32000
7200
(CICS only.) Specifies the name of a user program that is to receive control through CICS XCTL when CA Dataquery is signed off. The specified name must be in the CICS PPT and must not be the same as any CA Dataquery module name. The value specified in this parameter overrides the RTRTRAN specification and the session level transaction ID.
Note: If you specify either RTRNMOD or RTRTRAN, CA Dataquery ignores any value you specify for the USRCMD parameter.
Any valid 1- to 8-character module name as described above
(No default)
(CICS only.) Specifies the CICS transaction ID to be initiated through CICS interval control initiate when CA Dataquery is signed off. The value specified in this parameter can be overridden by using RTRNMOD or the session level return transaction ID. RTRTRAN use is preferred over RTRNMOD use.
Note: If you specify either RTRNMOD or RTRTRAN, CA Dataquery ignores any value you specify for the USRCMD parameter.
Any 4-character transaction ID
(No default)
Specifies if CA Dataquery should use the External Security Interface to get user IDs from CA ACF2, CA Top Secret, or IBM's RACF. If SECINF=YES when executing in CA Dataquery batch SIGN/ON mode, you can eliminate the signon card from batch executions. You must also specify the necessary external iecurity resources and privileges. For more information about implementing external security, see the CA Datacom Security Reference Guide.
NO or YES
NO
Specifies the number of batch sequential data buffers that can be used to speed the processing of some queries in batch by allowing the use of the CA Datacom/DB GETIT and GSETL commands. CA Dataquery decides to use GETIT and GSETL based on input from the Compound Boolean Selection Facility.
2—32
2
Specifies the online Signon/off Exit module name. The specified name must be in the CICS PPT and must not be the same as any CA Dataquery module name. See Sign-on/off Exit for information.
1- to 8-character module name
(No default)
Specifies, in 4096-byte increments, the maximum contiguous storage area for in-memory sorting which CA Dataquery will request of CICS at one time. If this amount is not available when needed, CA Dataquery tries to allocate a number of smaller areas for the sort.
This parameter sets the system default. You can override the value for specific users. See Authorizing Users.
1—16
16
Specifies, in 4096-byte increments, the maximum amount of storage CA Dataquery will allocate to process a single sort request. If a request is too large to be sorted in this amount, or if the storage is unavailable in the monitor, then the CA Datacom/DB Index sort is used.
This parameter sets the system default. You can override this value for specific users. See Authorizing Users.
1—1024
64
Specifies, in 4096-byte increments, the maximum amount of storage CA Dataquery allocates to process all concurrent sorts combined system wide.
1—2048
64
(z/VSE only) Specifies the number of disk sort work files to be used for batch system sort. Batch JCL should reflect the value specified.
0—8
3
Specifies the priority for SQL requests processed by MUF. One is the lowest priority and 15 is the highest.
1—15
7
Specifies the maximum number of CA Datacom/DB physical I/O events CA Dataquery is to issue to perform the FIND statement of any one query. The value should be small enough to prohibit full table searches and expensive queries. Code it large enough to allow users to issue queries of reasonable size. The limit is specified in terms of I/O events, not CA Datacom/DB requests. This parameter is ignored by batch CA Dataquery.
If the limit you specify is exceeded, CA Dataquery ends the search with one of two messages, either:
DQ472I - LIMIT EXCEEDED - FOUND NNNNNN, or DQ478I - LIMIT EXCEEDED - NO ROWS FOUND.
These messages are also generated whenever the limits set in the FNDBLKS= or MFTIME= parameters are exceeded. To find out if the message you receive has been generated by a FNDBLKS=, MFTIME=, or SRCHLIM= limit, either use a PF key from the Print Output panel, or view the Find Statistics panel by issuing the STATS command and check the FIND TERMINATED BECAUSE field for one of the following:
FNDBLKS: MAX WORK TABLE BLOCKS EXCEEDED MFTIME: MAX ELAPSED TIME EXCEEDED SRCHLIM: SITE I/O LIMIT (DQOPTLST.SRCHLIM) EXCEEDED
Specifying a zero means that you want no limit placed on the number of I/O events.
0—99999999
9999999
(Online only.) Specifies the name of the batch submit JCL exit module. The module name must be in the CICS PPT and must not be the same as any CA Dataquery module name.
1- to 8-character module name
(No default)
Specifies the name of a batch Signon/off Exit module. The module name must not be the same as any CA Dataquery module name.
1- to 8-character module name
(No default)
(Valid only for sites that use the Language Maintenance Facility.) Specifies the 2-character language code for the language you have chosen as the PRIMARY language (that is, the language translation that is searched first).
This parameter sets the system default. You can override the value for specific users. See Authorizing Users.
2-character language code previously defined in the Language Maintenance Facility
(No default. Note: Some panels show AE.)
(Valid only for sites that use the Language Maintenance Facility.) Specifies the 2-character language code for the language you have chosen as the SECONDARY language (that is, the language translation that is searched second).
This parameter sets the system default. You can override the value for specific users. See Authorizing Users.
2-character language code previously defined in the Language Maintenance Facility
(No default.
Note: Some panels show AE.)
Specifies the format to use to print columns in DQL Mode and SQL Mode which are defined as SQL time types.
USA - hh:mm am (or pm)
ISO - hh.mm.ss
EUR - hh.mm.ss
JIS - hh:mm:ss
USA
Specifies whether CA Dataquery can be initiated from a terminal. If YES is specified, CA Dataquery can be initiated by entering DQRY at a terminal. If NO is specified, CA Dataquery can only be initiated from a program. For information about initiating CA Dataquery from a program, see Initiating and Terminating CA Dataquery.
NO or YES
YES
Specifies how you want report titles centered. If YES is specified, report titles are centered over the width of the presented data. If NO is specified, report titles are centered over the width of the device.
NO or YES
NO
Specifies whether a User-Defined Functions exit is to be used. If you specify a name, ensure that a user-written exit is provided. The specified name must be in the CICS PPT and must not be the same as any CA Dataquery module name. For more information, see User-Defined Functions Exit.
1- to 8-character module name
(No default)
Specifies the priority for requests processed by the batch program after the User Requirements Table is opened. 1 is the lowest priority; 15 is the highest. CA Dataquery dynamically builds batch User Requirements Tables. For more information, see Defining the CA Dataquery User Requirements Tables.
1—15
7
Specifies the names of up to ten transactions which CA Dataquery recognizes as valid CA Dataquery commands. When one of these is entered as a CA Dataquery command, CA Dataquery initiates the transaction.
Note: If you specify either RTRNMOD or RTRTRAN, CA Dataquery ignores any value you specify for the USRCMD parameter.
(xxxx,xxxx,...) where xxxx is a 1- to 4-character transaction ID. Can be repeated up to ten times.
(No default)
Specifies whether a Query Validation exit is to be used. If you code a name, ensure that a user-written exit is provided. The specified name must be in the CICS PPT and must not be the ame as any CA Dataquery module name. For information about writing a Query Validation exit, see Query Validation Exit.
1- to 8-character module name
(No default)
Specifies the amount of space on the DQF (Found Table) that a single EXTRACT request can allocate at one time. This limit prevents one user from using excessive table space. If the limit is exceeded, CA Dataquery terminates the EXTRACT command and releases the assigned space. The value coded is in logical blocks; the number of logical rows that can be extracted at one time depends on the length of the logical row. For an estimate, divide 760 by the logical row length (total length of all columns and keys named by the average PRINT or DISPLAY).
1—9999
20
Specifies the length of a SET result in EXTRACT output. If 8 is specified and the SET result is greater than 15 digits in length, the value extracted will be zero (0). If 16 is used, all SET result values will be extracted as packed decimal length 16. If 8 is used, all SET result values will be extracted as packed decimal length 8. Setting the value to zero and continuing to process the rest of the output permits the program to continue. No other error message or error return code is set.
8 or 16
8
|
Copyright © 2014 CA.
All rights reserved.
|
|