IFCID 106 - Application Programming Defaults

Edit online

This topic shows detailed information about Record Trace - IFCID 106 - Application Programming Defaults.

This block shows application programming defaults.

The values shown are used as default values by the program preparation panels, program preparation CLIST (DSNH), and precompiler. They can also be used as defaults by other programs, such as IBM® Query Management Facility (QMF).

Changing some of these defaults is not recommended because changes can make the syntax of existing SQL statements invalid or affect the way application programs run.

Values set here are contained in load module DSNHDECP, in library prefix.SDSNEXIT, which can be loaded and accessed by application programs. When modifying DSNHDECP, do so only by changing and running the installation CLIST.

Do not modify the data in DSNHDECP. If you modify any installation parameters by changing job DSNTIJUZ directly, these values are not recorded for later updates, new installations, or migrations.

Record trace - IFCID 106 - Application Programming Defaults

The field labels shown in the following sample layout of Record Trace - IFCID 106 - Application Programming Defaults are described in the following section. 

                                      APPLICATION PROGRAMMING DEFAULTS                                                     
VERSION .........: 1210                  DECIMAL POINT OPT:               PERIOD  EBCDIC SBCS CCSID:                 1148  
DEFAULT SUBSYSTEM: DC61                  DEFLT ENC SCHEME :               EBCDIC  EBCDIC MBCS CCSID:                65534  
DEFAULT HOST LANG: IBMCOB                DISTR SQL STR DEL:                APOST  EBCDIC GBCS CCSID:                65534  
DECFLOAT RND MODE:            HALF EVEN  DEFLT DEC ARITHM :                DEC15  ASCII SBCS CCSID :                  819  
DEFAULT DELIMITER:                APOST  DEFLT MIXED GRAPH:                   NO  ASCII MBCS CCSID :                65534  
DEFLT SQL DELIMIT:                APOST  SQL LANG SUPP LVL:                   NO  ASCII GBCS CCSID :                65534 
DATE FORMAT .....: ISO                   USE FOR DYN RULES:                  YES  UNICOD SBCS CCSID:                  367 
TIME FORMAT .....: ISO                   DB2 DECP INDICAT :                X'D5'  UNICOD MBCS CCSID:                 1208 
IMP TIMEZONE ....:              CURRENT  LOCAL DATE LENGTH:                    0  UNICOD GBCS CCSID:                 1200 
IMP TIMEZONE(HEX):          X'9999999C'  LOCAL TIME LENGTH:                    0  NEWFUN CUR REL ..:                  N/A 
APPLIC ENCODING .: EBCDIC                PAD NULL-TERMIN .:                  YES  NEWFUN CUR REL-1 :                  N/A 
DSNHDECP DS NAME : SYS1.DSN.DC61.SDSNEXIT(DSNHDECP)                               NEWFUN CUR REL-2 :                  N/A 
DEFAULT LOCALE ..: 'BLANK'                                                                                                
                                                                                                                          
QWPBLVL .........: V12R1M0               QWPBLEN .........:                  260  QWPBEYE .........: DECP                 
QWPBCHAR ........: ALPHANUM
VERSION

The version, release, and modification level.

Field Name: QWPBREL

DECIMAL POINT OPT

Indicates whether the decimal contains a comma (,) or a period (.). This parameter is used for dynamic SQL and COBOL programs. It is not used or supported by other languages.

Install parameter DECIMAL POINT IS on panel DSNTIPF, or ZPARM DECIMAL in DSNHDECP.

Derivation: Db2 field QWPBDE

Field Name: QWPBDE

EBCDIC SBCS CCSID

The EBCDIC single-byte coded character set ID.

A coded character set identifier (CCSID) must be specified when DDF STARTUP OPTION field on panel DSNTIPR is set to AUTO or COMMAND, or when the MIXED DATA field on panel DSNTIPF is set to YES. When mixed data is used, valid Mixed Data CCSID must also be specified.

A nonexistent CCSID causes an error.

An incorrect CCSID can corrupt data.

Install parameter EBCDIC CCSID on panel DSNTIPF, or ZPARM SCCSID in DSNHDECP.

Field Name: QWPBSID

DEFAULT SUBSYSTEM

The MVS subsystem name for Db2. The name is used in member IEFSSN xx of SYS1.PARMLIB.

A valid name has 1-4 characters, the first must be A-Z, #, $, or @. Others must be A-Z, 1-9, #, $, or @. Default is DSN1.

Install parameter SUBSYSTEM NAME on panel DSNTIPM, or ZPARM SSID in DSNHDECP.

Field Name: QWPBSSID

DEFLT ENC SCHEME

The default encoding scheme, which can be ASCII or EBCDIC, or UNICODE.

Install parameter DEF ENCODING SCHEME on panel DSNTIPF, or ZPARM ENSCHEME in DSNHDECP.

Derivation: Db2 field QWPBENS

Field Name: QWPBENS

EBCDIC MBCS CCSID

The EBCDIC mixed coded character set ID.

A coded character set identifier (CCSID) must be specified when DDF STARTUP OPTION field on panel DSNTIPR is set to AUTO or COMMAND, or when the MIXED DATA field on panel DSNTIPF is set to YES. When mixed data is used, valid Mixed Data CCSID must also be specified.

A nonexistent CCSID causes an error.

An incorrect CCSID can corrupt data.

Install parameter EBCDIC CCSID on panel DSNTIPF, or ZPARM MCCSID in DSNHDECP.

Field Name: QWPBMID

DEFAULT HOST LANG
The default programming language for your site. This can be:
  • ASM
  • C
  • CPP
  • COBOL
  • COB2
  • IBMCOB
  • FORTRAN
  • PLI
When this is C or C++, you can fold SQL identifiers to uppercase.

Install parameter LANGUAGE DEFAULT on panel DSNTIPF, or ZPARM DEFLANG in DSNHDECP.

Field Name: QWPBLANG

DISTR SQL STR DEL

The SQL delimiter for bind operations at this Db2 if the requester does not provide Db2 with this information.

Field Name: QWPBDSD

EBCDIC GBCS CCSID

The EBCDIC graphic coded character set ID.

A coded character set identifier (CCSID) must be specified when DDF STARTUP OPTION field on panel DSNTIPR is set to AUTO or COMMAND, or when the MIXED DATA field on panel DSNTIPF is set to YES. When mixed data is used, valid Mixed Data CCSID must also be specified.

A nonexistent CCSID causes an error.

An incorrect CCSID can corrupt data.

Install parameter EBCDIC CCSID on panel DSNTIPF, or ZPARM GCCSID in DSNHDECP.

Field Name: QWPBGID

DECFLOAT RND MODE
The default rounding mode for the decimal floating point type. Possible values are:
X'80'
ROUND_CEILING
X'40'
ROUND_DOWN
X'20'
ROUND_FLOOR
X'10'
ROUND_HALF_DOWN
X'08'
ROUND_HALF_EVEN
X'04'
ROUND_HALF_UP
X'02'
ROUND_UP
Otherwise this field shows 'BLANK'.

ZPARM DEF_DECFLOAT_ROUND_MODE in DSNHDECP.

Field Name: QWPBDDRM

DEFLT DEC ARITHM

Indicates the rules of precision for a decimal field.

Install parameter DECIMAL ARITHMETIC on panel DSNTIP4, or ZPARM DECARTH in DSNHDECP.

Derivation : Db2 field QWPBAR

Field Name: QWPBAR

ASCII SBCS CCSID

The ASCII single-byte coded character set ID.

The default (0) means the installation has no ASCII databases, table spaces, or tables.

Install parameter ASCII CCSID on panel DSNTIPF, or ZPARM ASCCSID in DSNHDECP.

Field Name: QWPBASID

DEFAULT DELIMITER

Shows the string delimiter for COBOL. Default string delimiter is the quotation mark. This option is applicable to all types of COBOL.

Install parameter STRING DELIMITER on panel DSNTIPF, or ZPARM DELIM in DSNHDECP.

Field Name: QWPBDL

DEFLT MIXED GRAPH

Indicates whether the code points X'0E' and X'0F' are the shift-out and shift-in controls for character strings that include double-byte characters.

Install parameter MIXED DATA on panel DSNTIPF, or ZPARM MIXED in DSNHDECP.

Field Name: QWPBGRA

ASCII MBCS CCSID

Indicates the ASCII mixed coded character set ID.

The default (0) means the installation has no ASCII databases, table spaces, or tables.

Install parameter ASCII CCSID on panel DSNTIPF, or ZPARM AMCCSID in DSNHDECP.

Field Name: QWPBAMID

DEFLT SQL DELIMIT

The string delimiter for SQL.

Install parameter SQL STRING DELIMITER on panel DSNTIPF, or ZPARM SQLDELI in DSNHDECP.

Derivation: Db2 field QWPBSDL

Field Name: QWPBSDL

SQL LANG SUPP LVL
Shows whether SQL, the language standard used by applications, conforms to 1986 ANSI SQL standard.
YES
Conforms to the 1986 ANSI SQL standard
NO
Conforms to the SQL language defined by Db2
86
Conforms to the 1986 ANSI SQL standard

Install parameter STD SQL LANGUAGE on panel DSNTIP4, or ZPARM STDSQL in DSNHDECP.

Field Name: QWPBSQL

ASCII GBCS CCSID

Indicates the ASCII graphic coded character set ID.

The default (0) means the installation has no ASCII databases, table spaces, or tables.

Install parameter ASCII CCSID on panel DSNTIPF, or ZPARM AGCCSID in DSNHDECP.

Field Name: QWPBAGID

DATE FORMAT

Default output format for dates.

Valid formats are ISO (yyyy-mm-dd), USA (mm/dd/yyyy), EUR (dd.mm.yyyy), JIS (yyyy- mm-dd), or LOCAL (your choice, defined by a date exit routine). Db2 interprets the input date from the punctuation and converts the output date to the required format.

Install parameter DATE FORMAT on panel DSNTIP4, or ZPARM DATE in DSNHDECP.

Field Name: QWPBDATE

USE FOR DYN RULES

Shows whether Db2 uses the application programming defaults specified on this panel or those of the Db2 precompiler options for dynamic SQL statements bound using DYNAMICRULES bind, define, or invoke behavior.

When YES, the application programming (DSNHDECP) defaults are used for dynamic SQL statements in plans or packages bound using DYNAMICRULES bind, define, or invoke behavior.

The following defaults are affected:
  • DECIMAL POINT IS
  • STRING DELIMITER
  • SQL STRING DELIMITER
  • MIXED DATA
  • DECIMAL ARITHMETIC

When NO, values of the precompiler options are used for dynamic SQL statements in plans or packages bound with DYNAMICRULES(BIND).

Install parameter USE FOR DYNAMICRULES on panel DSNTIP4, or ZPARM DYNRULS in DSNHDECP.

Field Name: QWPBDRLS

UNICOD SBCS CCSID

Unicode Single Byte Character Set identification.

Parameter UNICODE CCSID in installation panel DSNTIPF, or ZPARM USCCSID in macro DSNHDECP.

Field Name: QWPBUSID

TIME FORMAT

Indicates the default output format for times.

Valid values are ISO (hh.mm.ss), USA (hh:mm AM), EUR (hh.mm.ss), JIS (hh:mm:ss), or LOCAL (your choice, defined by a time exit routine). Db2 interprets the input time from the punctuation and converts the output time to the required format.

Install parameter TIME FORMAT on panel DSNTIP4, or ZPARM TIME in DSNHDECP.

Field Name: QWPBTIME

DB2 DECP INDICAT

Indicates that DECP is supplied by Db2.

Using a Db2 supplied DECP could cause data corruption due to applications using wrong CCSIDs.

Field Name: QWPBDB2S

UNICODE MBCS CCSID

Unicode Mixed Character Set identification.

Parameter UNICODE CCSID in installation panel DSNTIPF, or ZPARM UMCCSID in macro DSNHDECP.

Field Name: QWPBUMID

IMP TIMEZONE

The implicit time zone that is associated with Db2 table columns and routine parameters that are declared as time stamp with time zone.

For IFCID 106 - Application Programming Defaults, this field is displayed twice, with its hex value and in a readable string.

This field corresponds to DSNHDECP field IMPLICIT_TIMEZONE.

Field Name: QWPBIMTZ

LOCAL DATE LENGTH

Shows the length of the longest field required to hold a locally defined date.

The default (0) indicates an IBM-supplied format (ISO, JIS, USA, or EUR).

Install parameter LOCAL DATE LENGTH on panel DSNTIP4, or ZPARM DATELEN in DSNHDECP.

Field Name: QWPBDLEN

UNICOD GBCS CCSID

Unicode graphics character set identification.

Parameter UNICODE CCSID in installation panel DSNTIPF, or ZPARM UGCCSID in macro DSNHDECP.

Field Name: QWPBUGID

IMP TIMEZONE (HEX)

The implicit time zone that is associated with Db2 table columns and routine parameters that are declared as time stamp with time zone.

For IFCID 106 - Application Programming Defaults, this field is displayed twice, with its hex value and in a readable string.

This field corresponds to DSNHDECP field IMPLICIT_TIMEZONE.

Field Name: QWPBIMTZ

LOCAL TIME LENGTH

Shows the length of the longest field required to hold a time when a locally defined time format is used.

The default (0) indicates an IBM-supplied format (ISO, JIS, USA, or EUR).

Install parameter LOCAL TIME LENGTH on panel DSNTIP4, or ZPARM TIMELEN in DSNHDECP.

Field Name: QWPBTLEN

NEWFUN CUR REL

If YES, the Db2 subsystem/group is running in New Function Mode. At this mode/catalog level, the New Function Mode is enabled and available. The Db2 catalog is completely Unicode (UTF-8) and long names can be used.

Install parameter INSTALL TYPE on panel DSNTIPA1, or ZPARM NEWFUN in DSNHDECP.

Field Name: QWPBNEWF

APPLIC ENCODING

Application encoding scheme.

Install parameter APPLICATION ENCODING on installation panel DSNTIPF, or ZPARM APPENSCH in DSNHDECP.

Field Name: QWPBAPSC

PAD NULL-TERMIN

Shows whether output host variables that are NULL-terminated strings are padded with blanks and a NULL terminator.

When NO, NULL-terminated output host variables have the NULL terminator placed at the end of actual data returned in the host variable. When YES, NULL-terminated output host variables have the NULL terminator placed at the end of the string, after the string has been padded with blanks from the end of the actual data to the declared length of the output host variable.

Install parameter PAD NUL-TERMINATED on installation panel DSNTIP4, or ZPARM PADNTSTR in DSNHDECP.

Field Name: QWPBPAD

NEWFUN CUR REL-1

Shows the current release minus one of the new-function mode (NEWFUN).

Field Name: QWPBNEWFN1

DSNHDECP DS NAME

Shows the fully qualified DECP name of the data set from which the DSNHDECP module was loaded.

Field Name: QWPBLNM

NEWFUN CUR REL-2

Shows the current release minus two of the new-function mode (NEWFUN).

Field Name: QWPBNEWFN2

DEFAULT LOCALE

The system LOCALE LC_CTYPE.

A locale is the part of the system environment that depends on language and cultural conventions. An LC_TYPE is a subset of a locale that applies to character functions. The UPPER, LOWER, and TRANSLATE scalar functions use the CURRENT LOCALE LC_CTYPE system default or special register. The results of these functions can vary, depending on the setting of the locale.

The following values are possible:
BLANK
The source field is empty.

This is the default, unless it is necessary to run the UPPER, LOWER, or TRANSLATE functions for data that must be interpreted using the rules provided by specific locales, for example, En_US or Fr_CA.

1st word
The source field contains left-justified word(s), where each byte of a word is > X'40'. It can be a single word or several ones, delimited by bytes <= X'40'.
Note: These hexadecimal codes do not represent printable characters.
N/P
The source field contains regular words that are not left-justified. This means that the first bytes are <= X'40'. N/P is also shown if the whole source field only consists of bytes < X'40', such as zeros.

Install parameter LOCALE LC_CTYPE on panel DSNTIPF, or ZPARM LC_TYPE in DSNHDECP.

Field Name: QWPBLCTP

DSNHDECP DS NAME

The system LOCALE LC_CTYPE.

A locale is the part of the system environment that depends on language and cultural conventions. An LC_TYPE is a subset of a locale that applies to character functions. The UPPER, LOWER, and TRANSLATE scalar functions use the CURRENT LOCALE LC_CTYPE system default or special register. The results of these functions can vary, depending on the setting of the locale.

The following values are possible:
BLANK
The source field is empty.

This is the default, unless it is necessary to run the UPPER, LOWER, or TRANSLATE functions for data that must be interpreted using the rules provided by specific locales, for example, En_US or Fr_CA.

1st word
The source field contains left-justified word(s), where each byte of a word is > X'40'. It can be a single word or several ones, delimited by bytes <= X'40'.
Note: These hexadecimal codes do not represent printable characters.
N/P
The source field contains regular words that are not left-justified. This means that the first bytes are <= X'40'. N/P is also shown if the whole source field only consists of bytes < X'40', such as zeros.

Install parameter LOCALE LC_CTYPE on panel DSNTIPF, or ZPARM LC_TYPE in DSNHDECP.

Field Name: DSNHDECP

QWPBLVL

This field is for IBM service.

Field Name: QWPBLVL

QWPBLEN

Shows the length of the control block.

Field Name: QWPBLEN

QWPBEYE

Shows the control block eyecatcher (DECP).

Field Name: QWPBEYE

QWPBCHAR

Shows the default character set, ALPHANUM or KATAKANA.

ZPARM CHARSET in DSNHDECP.

Field Name: QWPBCHAR