Interface Data

Copy member PTCSQLRT contains the following sub-parameters:

Sub-parameter Description

RTNCD

A four (4) digit computational number returned with each call indicating results of processing. A zero value means no errors were detected.

ERR-SECTION

A thirty (30) character field used to send the name of the COBOL SECTION issuing a call to process a fatal application error.

OPERID

An eight (8) character field that contains the user ID used to initiate this run.

BATCH-RUN-ID

A thirty (30) character field that contains the batch run ID used to initiate this run or a value of "N" if no batch run ID was required.

SQL-CURSOR-COMMON

A four (4) digit computational number representing a shared resource connection unit.

CURSOR-CNT

Work field—not used by application program.

SQL-CURSOR-SAVES

Work field—not used by application program.

ACTION

Constants described previously in ACTION parameter.

OPTION-SW

A one (1) character code used with the process select statement function to indicate that positioning is required for subsequent UPDATE and DELETE statements.

ERROR-DISC-SW

This field is used for ROLLBACK processing and is not used by application program.

DBTYPE-SW

An eight (8) digit computational number used to define the current database type being accessed.

 

00 Not set

 

01 SQLBase

 

02 DB2

 

04 Oracle

 

08 SQL Server

 

10 ALLBASE

 

11 RDB

DB2-WORK-AREA

Work field—not used by application program.

SQLRT-CHECK

Work field—not used by application program.