DSQQW global variables

Global variables whose names begin with DSQQW provide information about the current query environment.

The following DSQQW global variables are currently available:
Name Length Description
DSQQW_AUTOMATION 1 Indicates whether the application was started as an Automation server.
DSQQW_CONNECTIONS 1 Controls the use of database server connections while running a procedure. Value can be zero (0) to minimize the number of connections or one (1) to allow a new connection for each RUN QUERY command. Specifying a value of zero (0) can force the distributed product to reset or complete a data object before continuing execution of a procedure. The default value is zero (0).
DSQQW_DQ 1 The value of a double quote character. This variable can be used in queries and procedures to eliminate the need for the user to enter quotes with a text value. The default value is the double quote character.
DSQQW_EXP_DT_FRMT 1 The format to use when exporting data with the EXPORT DATA command in a procedure. Specify the value of:
  • zero (0) for text format
  • two (2) for HTML format
  • three (3) for CSV format
  • four (4) for IXF format
  • five (5) for dbase III files
  • six (6) for Shapefile format
  • seven (7) for WQML format
  • eight (8) for XML format
  • nine (9) for PDF format
  • ten (10) for XLS format
  • eleven (11) for XLSX format
DSQQW_EXP_OUT_MDE 1 The IXF variation to use when exporting data to an IXF file. Value can be zero (0) for System/370 character-mode IXF or one (1) for PC/IXF. The default value is one (1).
DSQQW_FST_SV_DATA 1 Controls the use of "fast mode" when saving data with the SAVE DATA command in a procedure. Value can be zero (0) to use regular save mode (not fast mode); one (1) to use fast mode with ORDER BY clause(s) stripped; or two (2) to use fast mode with ORDER BY clause(s). The default value is zero (0).
DSQQW_HTML_REFTEXT 55 The text that appears in a report when the &REF variable is used. The default value is "Back To".
DSQQW_OLD_PF6_MAP 1 Choose behavior for the F6 shortcut key.

NO: Use default mapping for F6, that is, create new Visual Query when F6 is pressed.

YES: Use QMF 10 Mapping for F6, that is, if visual query is not open, create one. If one or more visual queries are open, then switch to last active SQL tab of a Visual Query.
DSQQW_ORIENTATION 0 The orientation of the application. The value is zero (0) for left-to-right orientation. The value is one (1) for right-to-left orientation.
DSQQW_PROC_FAIL_ON_ERROR 1 Stops procedure execution if any of the procedure commands fails. A value of zero (0) specifies the procedure will continue. A value of one (1) specifies the procedure will stop.
DSQQW_PROC_OUTPUT   Output file name for a procedure.
DSQQW_PROC_WNDWS 1 Controls what happens to intermediate result windows created by running a procedure. The value of zero (0) will close all intermediate windows, leaving only the final result window open at the end of the procedure. The value of one (1) will leave all windows open at the end of the procedure. The value of two (2) will close all intermediate windows, and will also close the procedure window if the procedure is run indirectly (run from another procedure or from the command line). The default value is one (1).
DSQQW_QUERY_LANG 1 Specifies the subtype of query created when a DISPLAY QUERY command is executed but no query object exists. Value can be zero (0) for a query in the SQL view or one (1) for a query in the prompted view. The default value is zero (0).
DSQQW_QUERY_PREP 1 Specifies whether the query on a RUN command is to be prepared or run. The results of prepared queries are not returned to the user's workstation. Value can be zero (0) to prepare the query, or one (1) to run the query. The default value is one (1).
DSQQW_QUERY_PRESERVE_SORT 1 Specifies whether the query sorting order defined by a user is saved within the query and used every time the query is run. Value can be zero (0) - not to preserve the sorting order, or one (1) - to preserve the sorting order. The default value is one (1).
DSQQW_REUSE_OBJS 1 Specifies whether existing windows displaying retrieved objects are reused, or if a new window opens every time an object is selected. Value can be zero (0) to always open objects in new windows, or (1) to activate an existing window if the selected object is already open. The default value is one (1).
DSQQW_RPT_COPIES 10 Specifies the number of copies to print when printing a report with the PRINT REPORT command in a procedure. The default value is one (1).
DSQQW_RPT_FONT 55 Specifies the font face name to use when printing a report with the PRINT REPORT command in a procedure. The default value is "Monospaced".
DSQQW_RPT_FONT_BD 1 Specifies the font bold attribute to use when printing a report with the PRINT REPORT command in a procedure. A value of zero (0) specifies not bold and a value of one (1) specifies bold. The default value is zero(0).
DSQQW_RPT_FONT_CS 3 The character set of the font to use when printing a report with the PRINT REPORT command in a procedure. The default value is zero (0).
DSQQW_RPT_FONT_IT 1 Specifies the font italic attribute to use when printing a report with the PRINT REPORT command in a procedure. A value of zero (0) specifies not italic and a value of one (1) specifies italic. The default value is zero (0).
DSQQW_RPT_FONT_SZ 2 Specifies the font point size to use when printing a report with the PRINT REPORT command in a procedure. The default value is ten (10).
DSQQW_RPT_LEN_TYP 1 Specifies the type of page length that will be used when printing a report with the PRINT REPORT command or exporting a report with the EXPORT REPORT command in a procedure. Value can be zero (0) to automatically fit the length to the printed page, one (1) to specify an explicit number of lines, or two (2) to specify a continuous report with no page breaks. The default value is zero (0).
DSQQW_RPT_NUM_CHR 10 Specifies the number of characters to fit across a printed page when printing a report with the PRINT REPORT command or exporting a report with the EXPORT REPORT command in a procedure. This has an effect only when DSQQW_RPT_WID_TYP is one (1). The default value is eighty (80).
DSQQW_RPT_NUM_LNS 10 Specifies the number of lines to fit down a printed page when printing a report with the PRINT REPORT command or exporting a report with the EXPORT REPORT command in a procedure. This has an effect only when DSQQW_RPT_LEN_TYP is one (1). The default value is sixty(60).
DSQQW_RPT_ORIENT 1 The page orientation to use when printing a report with the PRINT REPORT command or exporting a report with the EXPORT REPORT command in a procedure. Value can be zero (0) for portrait or one (1) for landscape. The default value is zero (0).
DSQQW_RPT_OUT_TYP 1 The format to use when printing a report with the PRINT REPORT command in a procedure. Value can be zero (0) for text or two (2) for HTML. The default value is zero (0).
DSQQW_RPT_TD_TYP 1 Date format for TD edit code. Value can be zero (0) for ISO format, one (1) for USA format, two (2) for EUR format or three (3) for JIS format. The default value is zero (0).
DSQQW_RPT_TT_TYP 1 Time format for TT edit code. Value can be zero (0) for ISO format, one (1) for USA format, two (2) for EUR format or three (3) for JIS format. The default value is zero (0).
DSQQW_RPT_USE_PS 1 Specifies what page formatting options (page length, page width, etc.) to use when printing a report with the PRINT REPORT command in a procedure. Value can be zero (0) to use the values specified on the PRINT REPORT command or in global variables, or one (1) to use the values specified in the form's page setup. The default value is one (1).
DSQQW_RPT_WID_TYP 1 Specifies the type of page width when printing a report with the PRINT REPORT command in a procedure. Value can be zero (0) to automatically fit the width to the printed page, one (1) to specify an explicit number of characters or two (2) to specify a continuous line. The default value is zero (0).
DSQQW_SHOW_QUERY 1 Specifies which view of a query to display when a SHOW QUERY command is issued from a procedure. Value can be zero (0) for SQL or prompted view, one (1) for results view, two (2) for build view, or three (3) for layout view. The default value is zero (0).
DSQQW_SQ 1 The value of a single quote character. This variable can be used in queries and procedures to eliminate the need for the user to enter quotes with a text value. The default value is a single quote character (").
DSQQW_SV_DATA_C_S 10 The number of rows to insert before committing the unit of work when saving data with a SAVE DATA command in a procedure. Value can be zero (0) for all of the rows or an explicit number of rows. The default value is zero (0).
DSQQW_SV_DATA_T_M 1 Specifies how source and target column data types are matched when using the SAVE DATA command. The value can be zero (0) to require exact data type matches, one (1) to allow data type conversions with no possible data loss, or two (2) to allow all data type conversions that are supported by the database. The default value is one (1).
DSQQW_UEDIT_JAR 55 The name of the JAVA archive file that contains user edit routines.