Application Programming Defaults Panel 1 (DSNTIPF)

This topic shows detailed information about System Parameters - Application Programming Defaults Panel 1 (DSNTIPF).

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.

Note: The fields shown on this panel depend on the installed Db2 version.

System Parameters - Application Programming Defaults Panel 1 (DSNTIPF)

The field labels shown in the following sample layout of System Parameters - Application Programming Defaults Panel 1 (DSNTIPF) are described in the following section. 


APPLICATION PROGRAMMING DEFAULTS PANEL 1 (DSNTIPF)             
--------------------------------------------------             
DEFAULT HOST LANGUAGE (DEFLANG)..........................IBMCOB
DECIMAL POINT OPTION (DECIMAL)...........................PERIOD
DEFAULT DELIMITER (DELIM)...............................DEFAULT
DEFAULT SQL DELIMITER (SQLDELI).........................DEFAULT
DIST SQL STRING DELIMITER (DSQLDELI)......................APOST
DEFAULT MIXED GRAPHIC (MIXED)................................NO
EBCDIC SBCS CCSID (SCCSID)................................1,140
EBCDIC MBCS CCSID (MCCSID)..................................N/P
EBCDIC GBCS CCSID (GCCSID)..................................N/P
ASCII SBCS CCSID (ASCCSID)..................................437
ASCII MBCS CCSID (AMCCSID)..................................N/P
ASCII GBCS CCSID (AGCCSID)..................................N/P
UNICODE SBCS CCSID (USCCSID)................................367
UNICODE MBCS CCSID (UMCCSID)..............................1,208
UNICODE GBCS CCSID (UGCCSID)..............................1,200
DEFAULT ENCODING SCHEME (ENSCHEME).......................EBCDIC
APPLICATION ENCODING (APPENSCH)..........................EBCDIC
LOCALE LC_TYPE (LC_CTYPE).................................EN_US
DECFLOAT ROUND MODE (DEF_DECFLOAT_ROUND_MODE)...ROUND_HALF_EVEN
DEFAULT CHARSET (CHARSET)..............................ALPHANUM
DEFAULT HOST LANGUAGE (DEFLANG)
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

DECIMAL POINT OPTION (DECIMAL)

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

DEFAULT DELIMITER (DELIM)

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

DEFAULT SQL DELIMITER (SQLDELI)

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

DIST SQL STRING DELIMITER (DSQLDELI)

Shows the SQL string delimiter used by this Db2 for bind operations when the requester does not give Db2 that information.

Install parameter DIST SQL STR DELIMTR on panel DSNTIPF, or ZPARM DSQLDELI in DSNHDECP.

Field Name: QWPBDSSD

DEFAULT MIXED GRAPHIC (MIXED)

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

EBCDIC SBCS CCSID (SCCSID)

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

EBCDIC MBCS CCSID (MCCSID)

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

EBCDIC GBCS CCSID (GCCSID)

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

ASCII SBCS CCSID (ASCCSID)

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

ASCII MBCS CCSID (AMCCSID)

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

ASCII GBCS CCSID (AGCCSID)

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

UNICODE SBCS CCSID (USCCSID)

Unicode Single Byte Character Set identification.

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

Field Name: QWPBUSID

UNICODE MBCS CCSID (UMCCSID)

Unicode Mixed Character Set identification.

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

Field Name: QWPBUMID

UNICODE GBCS CCSID (UGCCSID)

Unicode graphics character set identification.

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

Field Name: QWPBUGID

DEFAULT ENCODING SCHEME (ENSCHEME)

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

APPLICATION ENCODING (APPENSCH)

Application encoding scheme.

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

Field Name: QWPBAPSC

LOCALE LC_CTYPE (LC_TYPE)

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

DECFLOAT ROUND MODE (DEF_DECFLOAT_ROUND_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

DEFAULT CHARSET (CHARSET)

Shows the default character set, ALPHANUM or KATAKANA.

ZPARM CHARSET in DSNHDECP.

Field Name: QWPBCHAR