Natural for Mainframes	Version 8.2.6 for Mainframes	SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT

This Natural profile parameter is used to specify the parameters for the database management interfaces Natural for DB2, Natural for SQL/DS and Natural SQL Gateway. It corresponds to the NTDB2 macro in the Natural parameter module.

The following topics are covered:

• DB2 Parameter Syntax

• NTDB2 Macro Syntax

• Keyword Subparameters

• Example of DB2 Parameter

• Example of NTDB2 Macro

DB2 Parameter Syntax

The DB2 parameter is specified as follows:

See Keyword Subparameters.

NTDB2 Macro Syntax

The NTDB2 macro is specified as follows:

         NTDB2 BTIGN=value,                                            *
               CONVERS=value,                                          *
               CONVRS2=value,                                          *
               DB2COLL=value,                                          *
               DB2GROV=value,                                          *
               DB2PLAN=value,                                          *
               DB2SSID=value,                                          *
               DB2XID=value,                                           *
               DDFSERV=value,                                          *
               DELIMID=value,                                          *
               EBPFSRV=value,                                          *
               EBPMAX=value,                                           *
               EBPPRAL=value,                                          *
               EBPSEC=value,                                           *
               ETIGN=value,                                            *
               FSERV=value,                                            *
               MAXLOOP=value,                                          *
               MAXSTMT=value,                                          *
               NNPSF=value,                                            *
               NNPSF=value,                                            *
               NSBDATE=value,                                          *
               NSBPORT=value,                                          *
               PSCIGN=value,                                           *
               REFRESH=value,                                          *
               RETRYPO=value,                                          *
               RWRDONL=value,                                          *
               STATDYN=value

See Keyword Subparameters.

Keyword Subparameters

There are two groups of keyword subparameters:

General Keyword Subparameters

BTIGN | CONVERS | CONVRS2 | DDFSERV | DELIMID | EBPFSRV | EBPPRAL | EBPSEC | EBPMAX | ETIGN | FSERV | MAXLOOP | MAXSTMT | NNPSF | NSBDATE | NSBHOST | NSBPORT | PSCIGN | REFRESH | RETRYPO | RWRDONL | STATDYN

Special Keyword Subparameters

DB2COLL | DB2GROV | DB2PLAN | DB2SSID | DB2XID

Notes:

1. These special keyword subparameters belong together. They apply only to DB2 for z/OS in environments using CAF or RRSAF.
2. They provide DB2 connecting and resource functionality, which in earlier versions was only supplied by the NATPLAN program. These parameters apply only to DB2 for z/OS and to environments where either the DB2 Call Attachment Facility (CAF) or the DB2 Resource Recovery Services Attachment Facility (RRSAF) is used. An exception to this is the Natural for DB2 stored procedure environment, where DB2 already provides the DB2 resources based on the stored procedure creation parameter COLLID. Therefore, the keyword subparameters mentioned here are not used in a Natural for DB2 stored procedure environment. Before the very first DB2 SQL access is performed by Natural for DB2 in a CAF or RRSAF environment, Natural connects to the desired DB2 subsystem (DB2SSID), and the desired plan (DB2PLAN) is allocated.
3. If the application already connected to DB2 by NATPLAN before the first SQL request, the NTDB2 or DB2 parameters are ignored and the connection already established is used.

BTIGN - Ignore BACKOUT TRANSACTION Error

BTIGN=value enables you to ignore the error which results from a BACKOUT TRANSACTION statement that was issued too late for backing out the current transaction, because an implicit Syncpoint has previously been issued by the TP monitor.

Notes:

1. This parameter is relevant in CICS and IMS TM environments only.
2. This subparameter is ignored by Natural SQL Gateway.

CONVERS - Conversational Mode under CICS

CONVERS=value is used to allow conversational mode in CICS environments where no Natural file server is used.

Notes:

1. If this subparameter is set to OFF and no Natural file server is used, you cannot continue database loops across terminal I/Os; if so, the following codes may occur.
2. With Natural for DB/2 and Natural for SQL/DS, DB2 SQLCODE -501, 504, 507, 514 or 518 apply.
3. With Natural SQL Gateway, Connex SQLCODE -4011 applies.
4. If, in a CICS environment, you are using the function SQL Services (NDB/NSQ) or SQL Services (NSB) (described in the Database Management System Interfaces documentation) without Natural for DB2 file server, you must specify CONVERS=ON, otherwise the error mentioned above can occur.

CONVRS2 - Conversational Mode 2 under CICS

CONVRS2=value allows/disallows the conversational mode 2 in CICS environments.

Notes:

1. This subparameter is used to control conversational mode 2 in CICS environments. Conversational mode 2 means that update transactions are spawned across terminal I/Os until either an explicit COMMIT or explicit ROLLBACK has been issued (Caution: DB2 and CICS resources are kept across terminal I/Os!). This means CONVRS2=ON has the same effect as the Natural profile parameter PSEUDO=OFF, except that the conversational mode is entered after a DB2 update statement (UPDATE, DELETE, INSERT) and left again after a COMMIT or ROLLBACK, while PSEUDO=OFF causes conversational mode for the total Natural session.
2. See also CALLNAT subprogram NDBCONV (described in the Database Management System Interfaces documentation), which allows setting or resetting conversational mode 2 dynamically.

DB2COLL – DB2 Collection Name

DB2COLL=value specifies the collection name of DB2 packages used by the application in an environment where the RRSAF interface is used.

Notes:

1. This subparameter is only honored by Natural for z/OS.
2. This parameter is only honored by the RRSAF interface if the DB2PLAN character contains as first character a question mark.
3. See also Special Keyword Subparameters.

DB2GROV – DB2 Group Override

DB2GROV=value specifies whether the connection to the DB2 system identified by DB2SSID is to be made to the single DB2 subsystem or to the DB2 sharing group, in case there exists a DB2 sharing group and a single DB2 with the identical DB2SSID.

Notes:

1. This subparameter is only honored by Natural for z/OS.
2. See also Special Keyword Subparameters.

DB2PLAN – DB2 Plan Name

DB2PLAN=value specifies the plan name used by the application.

Notes:

1. This subparameter is only honored by Natural for z/OS.
2. See also Special Keyword Subparameters.

DB2SSID – DB2 Subsystem Identifier

DB2SSID=value specifies the name of the DB2 sharing group or the name of the DB2 subsystem to be connected to.

Notes:

1. This subparameter is only honored by Natural for z/OS.
2. See also Special Keyword Subparameters.

DB2XID – DB2 Global Transaction ID

DB2XID=value specifies whether the RRSAF interface should use a global transaction ID or not.

Notes:

1. This subparameter is only honored by Natural for z/OS.
2. See also Special Keyword Subparameters.

DDFSERV - Alternate DD Name for Natural File Server

DDFSERV=value specifies a DD name for the Natural file server module.

Note:
This subparameter is ignored by Natural for SQL/DS.

DELIMID - Escape Character for Delimited Identifiers

DELIMID=value specifies the escape character to be used for generating delimited SQL identifiers for the column names and table names in SQL statements.

Notes:

1. A delimited identifier is a sequence of one or more characters enclosed in escape characters. You must specify a delimited identifier if you use SQL-reserved words for column names and table names, as demonstrated in Example of DELIMID.
2. To enable generation of delimited identifiers, DELIMID must be set to double quotation mark ('') or single quotation mark (').
3. The escape character specified for DELIMID and the SQL STRING DELIMITER are mutually exclusive. This implies that the mark (double or single quotation) used to enclose alphanumeric strings in SQL statements must be different from the value specified for DELIMID.
4. If you enable delimited identifiers, ensure that the value specified for DELIMID also complies with the SQL string delimiter value of your DB2 installation.
5. See also the RWRDONL subparameter to determine which delimited identifiers are generated in the SQL string.

Example of DELIMID

In the following example, a double quotation mark ('') has been specified as the escape character for the delimited identifier:

Natural statement:

SELECT FUNCTION INTO #FUNCTION FROM XYZ-T1000

Generated SQL string:

SELECT "FUNCTION" FROM XYZ.T1000

EBPFSRV - Editor Buffer Pool for Natural File Server

EBPFSRV=value specifies whether the Natural file server uses the Software AG Editor buffer pool as the storage medium.

Note:
This subparameter is ignored by Natural for SQL/DS.

EBPMAX - Editor Buffer Pool Maximum Allocation

EBPMAX=value specifies the maximum number of blocks to be allocated to each user of the Natural file server if the Software AG Editor buffer pool is used as the storage medium.

Notes:

1. This subparameter defines the upper limit for the allocation of buffer pool blocks to a single user.
2. If the EBPFSRV subparameter is set to OFF, EBPMAX is not used at runtime.
3. This subparameter is ignored by Natural for SQL/DS.

EBPPRAL - Editor Buffer Pool Primary Allocation

EBPPRAL=value specifies the number of blocks to be allocated primarily to each user of the Natural file server if the Software AG Editor buffer pool is used as the storage medium.

Notes:

1. If the EBPFSRV subparameter is set to OFF, EBPPRAL is not used at runtime.
2. This subparameter is ignored by Natural for SQL/DS.

EBPSEC - Editor Buffer Pool Secondary Allocation

EBPSEC=value specifies the number of blocks to be allocated secondarily to each user of the Natural file server if the Software AG Editor buffer pool is used as the storage medium.

Notes:

1. The secondary allocation is used to allocate buffer pool blocks to the user if the primary allocation amount is already exhausted.
2. If the EBPFSRV subparameter is set to OFF, EBPSEC is not used at runtime.
3. This subparameter is ignored by Natural for SQL/DS.

ETIGN - Ignore END TRANSACTION Error

ETIGN=value is used to handle END TRANSACTION statements in a message-driven IMS region (MPP or message-oriented BMP).

Notes:

1. This subparameter is relevant in IMS MPP and message-oriented BMP environments only.
2. In such a region, an END TRANSACTION cannot be executed by the Natural IMS TM Interface and is therefore ignored without any notification. In such situations, the ETIGN subparameter can be used to issue an error message instead.
3. This subparameter is ignored by Natural for SQL/DS and Natural SQL Gateway.

FSERV - Activate Natural File Server

FSERV=value specifies whether the Natural file server is to be used and whether it can be disabled in the case of an initialization error.

Notes:

1. If FSERV is set to ON and the Natural file server is not operational, the initialization of Natural for DB2 is terminated with a corresponding Natural error message. The Natural interface to DB2 is disabled, and any SQL call is rejected with a corresponding error message.
2. This subparameter is ignored by Natural for SQL/DS.

MAXLOOP - Maximum Number of Nested Program Loops

MAXLOOP=value specifies the maximum possible number of nested SQL database access statements.

MAXSTMT - Maximum Number of Allocated Dynamic SQL Statements

MAXSTMT=value specifies the maximum possible number of allocated dynamic SQL statements for the Natural SQL Gateway.

Note:
This subparameter is ignored by Natural for DB2 and Natural for SQL/DS.

NNPSF - Set Natural Numerics' Positive Sign to F

NNPSF=value is used to change the sign character of positive Natural variables which have format N, if they are filled from the SQL database system. Usually, these variables have the C as the positive sign character. If the subparameter NNPSF is set to ON, F is used as the positive sign character.

Note:
This subparameter is ignored by Natural for SQL/DS.

NSBDATE - Set Natural SQL Gateway Date String Format

NSBDATE=value specifies the format in which the Natural SQL Gateway server returns SQL date strings to the application. The application returns an SQL date as a string in the ISO format (YYYY-MM-DD) by default. NSBDATE=E enables the application to return SQL date strings in the EUR format (DD.MM.YYYY).

Note:
This subparameter is ignored by Natural for DB2 and Natural for SQL/DS.

NSBHOST - Set Natural SQL Gateway Server Host Name

NSBHOST=value specifies the Natural SQL Gateway server TCP/IP host name used to communicate from TP-monitor environments such as CICS or Com-plete to CONNX JDBC in order to access SQL databases.

Notes:

1. If the host name specification contains dots (.), the host name should be surrounded with single quotes.
2. This subparameter is ignored by Natural for DB2 and Natural for SQL/DS.

Example:

NSBHOST='IBM2.HQ.SAG'

NSBPORT – Set Natural SQL Gateway Server TCP/IP Port Number

NSBPORT=value specifies the TCP/IP port number to which the Natural SQL Gateway server listens.

Note:
This subparameter is ignored by Natural for DB2 and Natural for SQL/DS.

Example:

NSBPORT=4713

PSCIGN - Treat Positive SQLCODEs as SQLCODE 0

PSCIGN=value influences the treatment of positive SQLCODEs returned from the SQL database system.

Notes:

1. If the subparameter PSCIGN is set to OFF, a NAT3700 error message is issued.
2. If the subparameter PSCIGN is set to ON, positive SQLCODEs are treated as if they were zero; that is, no NAT3700 error message is issued.

REFRESH - Refresh Setting of DB2 Server and Package Set

REFRESH=value is used to automatically set the DB2 server and package set to the values that applied when the last transaction was executed.

Notes:

1. Server and package set are refreshed by using the CONNECT TO server-name and SET CURRENT PACKAGESET = 'package-name' SQL statements of DB2.
2. This subparameter is ignored by Natural SQL Gateway.

RETRYPO - Number of Positioning Retries

RETRYPO=value delimits the number of retries done by Natural for DB2 in order to reposition a dynamic scrollable cursor in a pseudo-conversational environment (IMS MPP or CICS).

Notes:

1. This subparameter is ignored by Natural SQL Gateway and Natural for SQL/DS.
2. This subparameter applies only to dynamic scrollable cursors.
3. In pseudo-conversational environments, cursors are closed at terminal I/O. For dynamic scrollable cursors the current absolute position number and the current key column values are saved. After terminal I/O, the dynamic scrollable cursor is opened again and positioned absolutely to the position of the saved absolute position. The contents of the key columns are compared with the saved values. If they match, processing continues with the next database operation requested.
4. If the contents of the key columns do not match the saved values, the next rows are fetched and compared with the saved values until either the values match or no row is found or the RETRYPO count is exhausted. In the latter cases, the cursor is repositioned to the saved position and the prior rows are fetched and compared until either the values match or no row is found or the RETRYPO count is exhausted. In the latter cases, a NAT3703 error message is issued. If a row is fetched whose key columns match the saved values, processing continues with the next database instruction.
5. RETRYPO delimits the retries in each direction (next or prior).

RWRDONL - Generate Delimited Identifiers for Reserved Words Only

RWRDONL=value determines which identifiers are generated as delimited identifier in an SQL string.

Note:
RWRDONL only takes effect if the setting of the DELIMID subparameter allows delimited identifiers.

STATDYN - Allow Static to Dynamic Switch

STATDYN=value is used to allow dynamic execution of statically generated SQL statements if the static execution returns an error.

Note:
This subparameter is ignored by Natural SQL Gateway.

Example of DB2 Parameter

DB2=(FSERV=DIS,DELIMID=DQ,RWRDONL=ON,STATDYN=ALWAYS)

Example of NTDB2 Macro

         NTDB2 FSERV=ON,                                               *
             DELIMID=DQ,                                               *
             NSBHOST=LOCALHOST,                                        *
             NSBPORT=4851,                                             *
             RWRDONL=ON

www.softwareag.com

Copyright © 1979-2016 Software AG, Darmstadt, Germany.

SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT