Application Programming Defaults Panel 2 (DSNTIP4, DSNTIP41)

This topic shows detailed information about System Parameters - Application Programming Defaults Panel 2 (DSNTIP4, DSNTIP41).

This block is a continuation of DSNTIPF and shows application programming defaults.

The values shown are used as default values by the program preparation panels, the program preparation CLIST (DSNH), and the 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.

APPLICATION PROGRAMMING DEFAULTS PANEL 2 (DSNTIP4,DSNTIP41)    
---------------------------------------------------------------
DECIMAL ARITHMETIC (DECARTH)..............................DEC15
USE FOR DYNAMIC RULES (DYNRULS).............................YES
STATIC DESCRIBE (DESCSTAT)..................................YES
DATE FORMAT (DATE)..........................................ISO
TIME FORMAT (TIME)..........................................ISO
LOCAL DATE LENGTH (DATELEN).................................N/A
LOCAL TIME LENGTH (TIMELEN).................................N/A
IMPLICIT TIMEZONE.......................................CURRENT
STD SQL LANGUAGE (STDSQL)....................................NO
PAD NULL-TERMINATED (PADNTSTR)...............................NO
APPL COMPAT LEVEL (APPLCOMPAT)..............................N/A
LIKE BLANK INSIGNIFICANT (LIKE_BLANK_INSIGNIFICANT).........N/A
FULLY QUALIFIED NAME OF DSNHDECP LOAD MODULE...................
  SYS1.DSNEXIT(DSNHDECP)                                       
PACKAGE DEPENDENCY LEVEL(PACKAGE_DEPENDENCY_LEVEL)......PACKAGE 

DECIMAL ARITHMETIC (DECARTH)

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: QWPBARTH

USE FOR DYNAMIC RULES (DYNRULS)

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

STATIC DESCRIBE (DESCSTAT)

Shows whether Db2 builds a DESCRIBE SQLDA when binding static SQL statements.

A DESCRIBE cannot be issued against a static SQL statement except:

• In a distributed environment, where Db2 for z/OS is the server and the requester supports extended dynamic SQL. In this instance, a DESCRIBE on an SQL statement in the extended dynamic package appears to Db2 as a DESCRIBE on a static SQL statement in the Db2 package.
• When an application uses a stored procedure result set, the application must allocate a cursor for that result set. The application can do this using a DESCRIBE CURSOR statement. The SQL statement actually described is the one with the cursor declared in the stored procedure. If that statement is static, a static SQL statement must be described.

When NO (default), Db2 does not generate a DESCRIBE SQLDA at BIND time for static SQL statements. If a DESCRIBE request is received at execution time, Db2 generates an error. However, if the describe request comes from a DESCRIBE CURSOR statement, Db2 satisfies the request but is only able to provide data type and length information. Column names are not provided.

When YES, Db2 generates a DESCRIBE SQLDA at BIND time so that DESCRIBE requests for static SQL can be satisfied during execution.

Note: You must rebind packages after this value has been set to YES.

This option increases the size of some packages because the DESCRIBE SQLDA is now stored with each statically-bound SQL SELECT statement.

Install parameter DESCRIBE FOR STATIC on panel DSNTIP4, or ZPARM DESCSTAT in DSN6SPRM.

Field Name: QWP4DSST

DATE FORMAT (DATE)

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

TIME FORMAT (TIME)

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

LOCAL DATE LENGTH (DATELEN)

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

LOCAL TIME LENGTH (TIMELEN)

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

IMPLICIT 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

STD SQL LANGUAGE (STDSQL)

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

PAD NULL-TERMINATED (PADNTSTR)

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

APPL COMPAT LEVEL (APPLCOMPAT)

Specifies the Db2 level for downward compatibility with applications. The ZPARM name is APPLCOMPAT in DSN6SPRM.

Field Name: QWP4APCO_VAR

LIKE BLANK INSIGNIFICANT (LIKE_BLANK_INSIGNIFICANT)

YES indicates that blanks are not significant when Db2 applies the LIKE predicate to a string. Blanks are significant in Db2 10.

This setting corresponds to field LIKE BLANK INSIGNIFICANT on installation panel DSNTIP41. The ZPARM name is LIKE_BLANK_INSIGNIFICANT in DSN6SPRM.

Field Name: QWP4LBIN

FULLY QUALIFIED NAME OF DSNHDECP LOAD MODULE

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

Field Name: QWPBLNM

PACKAGE DEPENDENCY LEVEL(PACKAGE_DEPENDENCY_LEVEL)

The PACKAGE_DEPENDENCY_LEVEL subsystem parameter specifies whether packages record package-level dependencies only or record both package-level and statement-level dependencies. Possible values are:

PACKAGE

Packages record only package-level dependencies.

STATEMENT

Packages record both package-level and statement-level dependencies.

Field Name: QWP4PKGDEPLVL