Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
The Change SQL iQuery Attributes (CHGIQRYA) command allows you to specify the defaults for the RUNIQRY and RUNIQRYF commands. When no value is specified for a parameter, these default values are used.
Top |
Keyword | Description | Choices | Notes |
---|---|---|---|
APPTITLE | Output Title Line 1 | Character value, *DFT | Optional, Positional 1 |
USRTITLE | Output Title Line 2 | Character value, *DFT | Optional, Positional 2 |
RPTTITLE | Output Title Line 3 | Character value, *DFT | Optional, Positional 3 |
COMMIT | Commitment control | *CHG, *UR, *CS, *ALL, *RS, *NONE, *NC, *RR, *AUTO | Optional, Positional 4 |
NAMING | Naming | *SYS, *SQL | Optional, Positional 5 |
DATFMT | Date format | *ISO, *USA, *EUR, *JIS, *MDY, *DMY, *YMD, *JUL, *JOB, ISO, USA, EUR, JIS, MDY, DMY, YMD, JUL, JOB | Optional, Positional 6 |
DATSEP | Date separator | *SLASH, *DASH, *PERIOD, *COMMA, *BLANK, /, -, ., ,, , *JOB | Optional, Positional 7 |
TIMFMT | Time format | *ISO, *USA, *EUR, *JIS, *HMS, ISO, USA, EUR, JIS, HMS | Optional, Positional 8 |
TIMSEP | Time separator | *COLON, *PERIOD, *COMMA, *BLANK, :, ., ,, , *JOB | Optional, Positional 9 |
OPTIMIZE | Optimization | *FIRSTIO, *ALLIO | Optional, Positional 10 |
DECPOINT | Decimal point | *PERIOD, *COMMA, *JOB, '.', ',', * | Optional, Positional 11 |
NULLCHAR | Null field symbol | Character value, *PERIOD, *PLUS, *MINUS, *ASTERISK, '+', '-', *, '.' | Optional, Positional 12 |
DDECHAR | Decimal Data Error symbol | Character value, *PERIOD, *PLUS, *MINUS, *ASTERISK, '+', '-', *, '.' | Optional, Positional 13 |
SPLFNAME | SPOOL File name | Name, *DFT | Optional, Positional 14 |
USRDTA | SPOOL File User data | Character value, *DFT | Optional, Positional 15 |
LPI | Lines per inch (LPI) | 8, 3.0, 4.0, 6.0, 7.5, 8.0, 9.0, 12.0 | Optional, Positional 16 |
CPI | Characters per inch (CPI) | *AUTO, 5.0, 10.0, 12.0, 13.3, 15.0, 16.7, 18.0, 20.0 | Optional, Positional 17 |
PAGESIZE | Page size | Element list | Optional, Positional 18 |
Element 1: Page length (height) | 0.0-255.0 | ||
Element 2: Page width | 0.0-378.0 | ||
Element 3: Unit of measure method | *UOM, *ROWCOL, *INCH, *CM | ||
OVRFLW | Overflow line | Integer, *AUTO | Optional, Positional 19 |
UOM | Unit of measure | *INCH, *CM | Optional, Positional 20 |
PAGRTT | Degree of page rotation | *REDUCE, *AUTO, *DEVD, *COR, 0, 90, 180, 270 | Optional, Positional 21 |
MSGF | Message file (language) | Qualified object name | Optional, Positional 22 |
Qualifier 1: Message file (language) | Name, COZLANGEN | ||
Qualifier 2: Message library | Name, IQUERY, *LIBL | ||
EMAILCMD | Email command to run (if any) | Command string | Optional, Positional 23 |
Top |
Specifies the first line of output headings for print and print-related output.
Top |
Specifies the title text for the second line of the output media. Used when OUTPUT(*PRINT) or OUTPUT(*) is specified.
Top |
Specifies the title text for the third line of the output media. Used when OUTPUT(*PRINT) or OUTPUT(*) is specified.
Top |
Top |
Specifies SQL naming convention used within the SQL statements.
Top |
Specifies the default date format for Date fields returned by SQL iQuery when the SQL statement is a SELECT statement.
Top |
Specifies the date separator used for *MDY, *DMY, and *YMD format dates.
Top |
Specifies the default Time format for Time fields returned by SQL iQuery when the SQL statement is a SELECT statement.
Top |
Specifies the separator used for time values.
Top |
Specifies the level of optimization to suggest to the SQE engine. This weighs heavily in the query processing but may be ignored if an alternative is determined to be a better option.
Top |
Top |
Top |
Top |
Specifies the SPOOLED FILE name when OUTPUT(*PRINT) is specified. The default name of SPOOLED FILES is normally QRYFREPORT.
Top |
Specifies the user data value to included in the SPOOLED FILE produced when OUTPUT(*PRINT) is specified.
Top |
Specifies the number of lines per inch for Print Files.
Top |
Specifies the characters per inch (across the page) when creating SPOOLED or PDF files.
Top |
Specifies the printed page dimensions. Specify the dimensions as "rows and columns", inches or centimeters.
Element 1: Page length (height)
Element 2: Page width
Element 3: Unit of measure method
Top |
Specifies spcifies the line number (regardless of the UOM setting) that triggers the Overlow Indicator in the application. Once this line is printed, the app skips to the top of the next page and continues printing.
Top |
Specifies the unit of measure for the PAGESIZE parameter. When the third element of PAGESIZE is *UOM, this parameter is used to determine the measurements of the page size.
Top |
Specifies the amount of page rotation to perform when sending the output to a Laser-like printer.
Top |
Top |
Top |
Example 1: Simple Command Example
CHGIQRYA KWD1(PARMVAL1)
This command <...>
Example 2: More Complex Command Example
CHGIQRYA KWD1(PARMVAL1) KWD2(PARMVAL2) KWD3(PARMVAL3)
This command <...>
Top |
*ESCAPE Messages
Top |