DSQQW_AUTOMATION |
1 |
Indicates whether the current instance of QMF
for Windows was started to service OLE automation requests (value
is 1) or to service the user interface (value is 0). |
DSQQW_CONNECTIONS |
1 |
Use server connections while running a procedure.
This setting controls the number of server connections for procedures.
- 0 = minimize the number of connections. This is the default.
Specifying a value of 0 can force QMF for Windows to reset or complete
a data object before continuing the execution of a procedure.
If set to 0, you specify a linear connection, which means that
the first query must complete before the next is run. These queries
are run in a series.
- 1 = all: a new connection for each RUN QUERY command
If set to 1, subsequent connections are opened so the queries
are run in parallel (at the same time).
Note:
This global variable is designed to be used with DSQQW_FST_SV_DATA
(by which the query will be PREPARED only on RUN QUERY. |
DSQQW_DQ |
" |
Double-quote character |
DSQQW_EXP_DT_FRMT |
1 |
Format for EXPORT DATA. Value can be:
- 0 = text. This is the default.
- 2 = html
- 3 = csv (comma-separated value)
- 4 = ixf
For the EXPORT command, you can export the report to a file name
with a file type of .qmf, .html or .txt.
Note:
In a procedure (with a .txt file type), if no options
are specified as delimiters, the default is spaces. |
DSQQW_EXP_OUT_MDE |
1 |
IXF mode for procedures. Value can be:
- 0 = System/370 character mode IXF. This is the default.
- 1 = PC/IXF
|
DSQQW_FST_SV_DATA |
1 |
Use 'Fast Save' mode for SAVE DATA. Value can be:
- 0 = do not use fast mode. This is the default.
- 1 = use fast mode
|
DSQQW_HTML_REFTXT |
55 |
Text for &REF form variable. The default is 'Back To'. |
DSQQW_PROC_OUTPUT |
|
Report Center will pass the path name and file
name to a procedure that uses &DSQQW_PROC_OUTPUT.
EXPORT REPORT TO &DSQQW_PROC_OUTPUT
Alternatively:
EXPORT DATA TO &DSQQW_PROC_OUTPUT |
DSQQW_QUERY_LANG |
1 |
Subtype of query created by DISPLAY QUERY when no query object exists. Value can be:
- 0 = SQL. This is the default.
- 1 = prompted
|
DSQQW_QUERY_PREP |
|
Prepare the query on a RUN command instead of running. This option invokes the PREPARE SQL command.
DB2 will check the query syntax and the existence of every object
associated with the query. Internal calculations will be performed,
but no data will be sent to the client.
This option can be used to validate queries with complicated
calculations or ones that will return significant data. Value can
be:
|
DSQQW_RPT_COPIES |
10 |
Number of copies for PRINT REPORT. The default is 1.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used. If it is set
to 2, the global variable settings are used. |
DSQQW_RPT_FONT |
55 |
Font for PRINT REPORT. The default is 'Courier New'.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used. If it is set
to 2, the global variable settings are used. |
DSQQW_RPT_FONT_BD |
1 |
Bold attribute for PRINT REPORT. The default is 0.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set
to 2, the global variable settings are used. |
DSQQW_RPT_FONT_IT |
1 |
Italic attribute for PRINT REPORT. The default is 0.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set
to 2, the global variable settings are used. |
DSQQW_RPT_FONT_SZ |
2 |
Font size for PRINT REPORT. The default is 10.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set
to 2, the global variable settings are used. |
DSQQW_RPT_LEN_TYP |
1 |
Type of page length for PRINT REPORT. The value can be:
- 0 = fit the length of the printed page. This is the default.
- 1 = specify an explicit number of lines
- 2 = specify a continuous report with no page breaks
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set
to 2, the global variable settings are used. |
DSQQW_RPT_NUM_CHR |
10 |
Number of characters across a printed page for PRINT REPORT. This has an effect only when DSQQW_RPT_WID_TYP is 1. The default
value is 80.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set
to 2, the global variable settings are used. |
DSQQW_RPT_NUM_LNS |
10 |
Number of lines down a page for PRINT REPORT. This has an effect only when DSQQW_RPT_LEN_TYP is 1. The
default value is 60.
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set
to 2, the global variable settings are used. |
DSQQW_RPT_ORIENT |
1 |
Page orientation for PRINT REPORT. The value can be:
- 0 = portrait. This is the default.
- 1 = landscape
Note:
If DSQQW_RPT_USE_PS is set to 1, the Page Setup options are used; if it is set
to 2, the global variable settings are used. |
DSQQW_RPT_USE_PS |
1 |
Set of page formatting options (page length,
page length) for PRINT REPORT. The value can be:
- 0 = use the values specified on the PRINT REPORT command or in global variables
- 1 = use the values specified in the form document's
page setup. This is the default.
Note:
If this value is set to 1, the Page Setup options
are used; if it is set to 2, the global variable settings are used. |
DSQQW_RPT_WID_TYP |
1 |
Type of page width for PRINT REPORT. The value can be:
- 0 = fit the width in the printed page. This is the default.
- 1 = specify an explicit number of characters.
Note:
If this value is set to 1, the Page Setup options
are used; if it is set to 2, the global variable settings are used. |
DSQQW_SHOW_QUERY |
1 |
View of a query for SHOW QUERY. The value can be:
- 0 = SQL or prompted view. This is the default.
- 1 = results view
|
DSQQW_STRIP_SPACE |
1 |
Remove trailing spaces from objects retrieved
from server. The value can be:
- 0 = retain trailing spaces
- 1 = remove trailing spaces. This is the default.
|
DSQQW_SV_DATA_C_S |
10 |
Rows to insert before commit for SAVE DATA. Value can be:
- 0 = all rows. This is the default.
- n = where n equals
an explicit number of rows
|
DSQQW_UEDIT_DLL |
55 |
DLL implementing user edit routines. The default
value is rsuedit.dll |
DSQQW_PROC_WNDWS |
|
Procedure results options. The values are:
|