Writer instructions | ||
Purpose | Use this page to display a banner announcement on each page of the space. Create the Space announcements page in the master space, outside of the Home branch. You can version the Space announcements page to enable different banners to be published into different target spaces, however, the banner that is displayed in the versioned (master) space itself only displays the most recently-published banner. If you find errors in the banner area of your versioned space and you are sure the Space announcements page is set up correctly, try publishing the page to the same space. For more information, see Space-announcements-banners. | |
Removing | When an announcement is no longer needed, remove the BMC Space Banner macro. | |
Translation | Localized spaces using the L10n Viewport theme must change the name of this page to Space announcements l10n. See Configuring-the-Scroll-ViewPort-theme-for-translated-spaces. | |
Usage | Choose one or none of the following BMC Space Banner macros. If your space requires another kind of announcement, you can use this page in coordination with your team lead and editors. | |
SQL INSERT load JCL
You can code and submit the JCL on the following pages to execute the load process without invoking the interactive phase of the Load function. The required parameter information and DD statements for File-AID/RDX-specific steps are described following the JCL.
SQL Insert Load JCL (continues on next page)
//* CREATE:- CREATE TABLES AND INDEXES.
//* --------------------------------------------------------------------
//CREATE EXEC PGM=XFREXEC,REGION=8192K,COND=(4,LT),
// PARM=(FR,7,B)
//*
//STEPLIB DD DSN=Combined-File-AID/RDX-load-libraries,DISP=SHR
// DD DSN=DB2-load-library,DISP=SHR
//RDXMLIB DD DSN=File-AID-message-library,DISP=SHR
//EXTRACT DD DSN=extract-file,
// DISP=SHR
//EXTPARMS DD DSN=TSOID01.prefix.PARMS.Dnnnnnn.Tnnnnnn.suffix,
// DISP=SHR
//SYSOUT DD SYSOUT=(*)
//RDXSQLCD DD SYSOUT=(*)
//SYSPRINT DD SYSOUT=(*)
//SYSUDUMP DD SYSOUT=(*)
//TPTPRINT DD SYSOUT=(*)
//SYSTERM DD SYSOUT=(*)
//SYSIN DD DSN=TSOID01.prefix.VBCNTL.Dnnnnnn.Tnnnnnn.suffix(DB2CREAT),
DISP=SHR
//* XFRJSTRT
//*-------------------------------------------------------------------
//* CLEAN1ST: - THIS STEP WILL ENSURE THAT ALL TEMPORARY FILES
//* USED IN THIS JOB ARE DELETED.
//* - THIS ALLOWS FOR KEEPING AND RERUNNING THE JOB EVEN IF
//* SUBSEQUENT STEPS FAIL.
//* - THIS JCL IS ALSO RESTARTABLE AT ANY STEP BY CODING
//* RESTART=XXXXXXXX ON THE JOBCARD. (XXXXXXXX = STEPNAME)
//*-------------------------------------------------------------------
//CLEAN1ST EXEC PGM=IDCAMS,COND=(4,LT),DYNAMNBR=2048
//SYSPRINT DD SYSOUT=*
//SYSIN DD * IDCAMS DELETE STATEMENTS FOLLOW
DELETE File-AID-sort-file
DELETE File-AID-split-file
SET MAXCC=0
SET LASTCC=0
/*
//*
//* --------------------------------------------------------------------
//* LDDRV:- LOAD DRIVER
//* THE FOLLOWING IS PERFORMED IN THIS STEP.
//* - CHECK USERS AUTHORITY TO RUN ALL THE STEPS
//* - ENSURE TABLES EXIST.
//* - SPLIT EXTRACT FILE INTO SEPARATE LOAD FILES.
//* --------------------------------------------------------------------
//LDDRV EXEC PGM=XFREXEC,COND=(4,LT),REGION=8192K,
// PARM=(FR,3,B)
//*
//STEPLIB DD DSN=Combined-File-AID/RDX-load-libraries,DISP=SHR
// DD DSN=DB2-load-library,DISP=SHR
//RDXMLIB DD DSN=File-AID-message-library,DISP=SHR
//EXTRACT DD DSN=extract-file,
// DISP=SHR
//EXTPARMS DD DSN=TSOID01.prefix.PARMS.Dnnnnnn.Tnnnnnn.suffix,
// DISP=SHR
//*
//DISCARDS DD DSN=File-AID-discard-file,
// DCB=(RECFM=VB,LRECL=302,BLKSIZE=306,DSORG=PS),
// SPACE=(TRK,(1,1),RLSE),
// UNIT=SYSDA,
// DISP=(NEW,CATLG,DELETE)
//*
SQL Insert Load JCL (continues on the next page)
//SPLITnnn DD DSN=File-AID-split-file,
// DCB=(RECFM=VB,LRECL=302,BLKSIZE=0),
// SPACE=(TRK,(5,1),RLSE),
// UNIT=SYSDA,
// DISP=(NEW,CATLG,DELETE)
//SRTCDnnn DD DSN=TSOID01.prefix.FBCNTL.Dnnnnnn.Tnnnnnn.suffix(SRTCDnnn),
// DISP=SHR
//SYSOUT DD SYSOUT=(*)
//RDXSQLCD DD SYSOUT=(*)
//SYSPRINT DD SYSOUT=(*)
//SYSTERM DD SYSOUT=(*)
//SYSIN DD DSN=TSOID01.prefix.VBCNTL.Dnnnnnn.Tnnnnnn.suffix(DB2LCT),
// (DISP=SHR)
//*
//*-------------------------------------------------------------------
//* SORTnnn:- SORT INPUT FILE FOR TABLE TSOID01.CUSTOMER_TABLE
//*-------------------------------------------------------------------
//SORTnnn EXEC PGM=SORT,COND=(4,LT)
//*
//STEPLIB DD DSN=SYS1.SORTLIB,
// DISP=SHR
//SYSOUT DD SYSOUT=(*)
//DFSPARM DD DSN=TSOID01.prefix.FBCNTL.Dnnnnnn.Tnnnnnn.suffix(DFSPARM),
// (DISP=SHR)
//$ORTPARM DD DSN=TSOID01.prefix.FBCNTL.Dnnnnnn.Tnnnnnn.suffix($ORTPARM),
// (DISP=SHR)
//SORTIN DD DSN=File-AID-split-file,
// DISP=(OLD,KEEP,KEEP)
//S
ORTOUT DD DSN=File-AID-sort-file,
// DCB=(RECFM=VB,LRECL=103,BLKSIZE=27998),
// SPACE=(27998,(2,2),RLSE),
// UNIT=SYSDA,
// DISP=(NEW,CATLG,DELETE)
//SORTWK01 DD UNIT=SYSDA,
// SPACE=(19069,(00003),,,ROUND),
// DISP=(NEW,DELETE,DELETE)
//SORTWK02 DD UNIT=SYSDA,
// SPACE=(19069,(00003),,,ROUND),
// DISP=(NEW,DELETE,DELETE)
//SORTWK03 DD UNIT=SYSDA,
// SPACE=(19069,(00003),,,ROUND),
// DISP=(NEW,DELETE,DELETE)
//SYSIN DD DSN=TSOID01.prefix.FBCNTS.Dnnnnnn.Tnnnnnn.suffix(SRTCDnnn),
// DISP=(OLD,KEEP,KEEP)
//*
//*-------------------------------------------------------------------
//* DELETE:- DELETE ROWS FROM SPECIFIED TABLES
//*-------------------------------------------------------------------
//DELETE EXEC PGM=XFREXEC,REGION=8192K,COND=(4,LT),
// PARM=(FR,6,B)
//*
//STEPLIB DD DSN=Combined-File-AID/RDX-load-libraries,DISP=SHR
// DD DSN=DB2-load-library,DISP=SHR
//RDXMLIB DD DSN=File-AID-message-library,DISP=SHR
//EXTPARMS DD DSN=TSOID01.prefix.PARMS.Dnnnnnn.Tnnnnnn.suffix,
// DISP=SHR
//SYSIN DD DSN=TSOID01.prefix.VBCNTL.Dnnnnnn.Tnnnnnn.suffix(DB2LCT),
// (DISP=SHR)
//DLRPT DD SYSOUT=(*)
//SYSOUT DD SYSOUT=(*)
//RDXSQLCD DD SYSOUT=(*)
//SYSPRINT DD SYSOUT=(*)
//S
YSTERM DD SYSOUT=(*)
//*
SQL Insert Load JCL
//* LOAD SQL INSERT:- LOAD TO TABLES USING SQL INSERT
//*-------------------------------------------------------------------
//LDSQLIN EXEC PGM=XFREXEC,REGION=8192K,COND=(4,LT),
// PARM=(FR,5,B)
//*
//STEPLIB DD DSN=Combined-File-AID/RDX-load-libraries,DISP=SHR
// DD DSN=DB2-load-library,DISP=SHR
//RDXMLIB DD DSN=File-AID-message-library,DISP=SHR
//EXTPARMS DD DSN=TSOID01.prefix.PARMS.Dnnnnnn.Tnnnnnn.suffix,
// DISP=SHR
//SYSIN DD DSN=TSOID01.prefix.VBCNTL.Dnnnnnn.Tnnnnnn.suffix(DB2LCT),
// (DISP=SHR)
//LOADIN DD DSN=TSOID01.prefix.SORTnnn.Dnnnnnn.Tnnnnnn.suffix,
// DISP=(OLD,KEEP,KEEP)
//XCPTNRPT DD SYSOUT=(*)
//TOTLSRPT DD SYSOUT=(*)
//COMMTRPT DD SYSOUT=(*)
//RDERRORS DD SYSOUT=(*)
//SYSOUT DD SYSOUT=(*)
//DISCARDS DD DSN=TSOID01.DISCARD,
// DISP=MOD
//SYSPRINT DD SYSOUT=(*)
//SYSUDUMP DD SYSOUT=(*)
//TPTPRINT DD SYSOUT=(*)
//SYSTERM DD SYSOUT=(*)
//* XFRLDND
//*-------------------------------------------------------------------
//* CLEANLST: - THIS STEP WILL PERFORM A DELETE OF ALL TEMPORARY
//* FILES USED IN THIS JOB.
//* - KEEPING THE fileS UNTIL ALL STEPS RUN SUCCESSFULLY
//* ALLOWS FOR THE RESTARTING OF THE JCL AT ANY STEP.
//*-------------------------------------------------------------------
//CLEAN1ST EXEC PGM=IDCAMS,COND=(4,LT),DYNAMNBR=2048
//SYSPRINT DD SYSOUT=*
//S
YSIN DD * IDCAMS DELETE STATEMENTS FOLLOW
DELETE File-AID-sort-file
DELETE File-AID-split-file
SET MAXCC=0
SET LASTCC=0
/*
//*
//*-------------------------------------------------------------------
//* CLEANCTL: - THIS STEP WILL PERFORM A DELETE OF THE TWO CNTL
//* DATASETS USED BY THIS JOB FOR THE SYSIN DATA.
//* - THE DATASETS ARE ONLY DELETED IF ALL THE PREVIOUS
//* STEPS RUN SUCCESSFULLY; THIS ALLOWS FOR RESTARTING
//* OF THE JOB AT ANY STEP.
//*-------------------------------------------------------------------
//* NOTE! - THIS STEP IS CONDITIONED ON AN OPTION ON THE GLOBAL
//* OPTIONS SCREEN
/*-------------------------------------------------------------------
//CLEANCTL EXEC PGM=IEFBR14,COND=(4,LT)
//*
//DFBPDSE DD DSN=TSOID01.prefix.FBCNTL.Dnnnnnn.Tnnnnnn.suffix,
// DISP=(OLD,DELETE,DELETE)
//DVBPDSE DD DSN=TSOID01.prefix.VBCNTL.Dnnnnnn.Tnnnnnn.suffix,
// DISP=(OLD,DELETE,DELETE)
//*-------------------------------------------------------------------
//* CLEANCTL: - THIS STEP WILL PERFORM A DELETE OF THE EXTPARMS
//* DATASETS USED BY THIS JOB FOR.
//* - THE DATASETS ARE ONLY DELETED IF ALL THE PREVIOUS
//* STEPS RUN SUCCESSFULLY; THIS ALLOWS FOR RESTARTING
//* OF THE JOB AT ANY STEP.
//*-------------------------------------------------------------------
//* NOTE! - THIS STEP IS CONDITIONED ON AN OPTION ON THE GLOBAL
//* OPTIONS SCREEN
/*-------------------------------------------------------------------
//CLEANEXT EXEC PGM=IDCAMS,COND=(4,LT),DYNAMNBR=2048 XFRJCLXT
//SYSPRINT DD SYSOUT=*
//SYSIN DD * IDCAMS DELETE STATEMENTS FOLLOW
DELETE extract-parms-file,
SET MAXCC=0
SET LASTCC=0
//*
//* /*XFRJCLXT*/
//
CREATE Step Parameter List and DD Statements
XFREXEC is the File-AID/RDX program name.
The parameter information in the PARM field on the EXEC statement for the CREATE step must have the following format:
EXEC Statement PARM Field—CREATE Step
Parameter | Default Value | Length | Description |
|---|---|---|---|
Product | FR | 2 | File-AID/RDX |
Option | 7 | 1 | File-AID/RDX option number. |
Operating Mode | B | 1 | B : Batch |
The following DD statements are required for the CREATE step:
DD Statements—CREATE Step
DD Statement | Description |
|---|---|
STEPLIB | File-AID/RDX load libraries (CXVJLOAD and SXVJLOAD); Db2 load library. |
RDXMLIB | Library containing File-AID/RDX messages. |
EXTRACT | File containing the extracted data. |
EXTPARMS | File containing the load parameters (see EXTPARMS File). |
SYSOUT | Output class for error messages and reports. |
RDXSQLCD | Output class for detailed SQL error information from Db2. |
SYSPRINT | Standard output stream. |
SYSTERM | Output class for runtime errors. |
TPTPRINT | Standard output stream for optional diagnostics. |
SYSIN | DDL for tables and indexes to be created (see Create DDL (member Db2CREAT)). |
Create DDL
Member Db2CREAT in the SYSIN control card PDSE contains the DDL for tables and indexes to be created (see the following figure).
Create DDL (member Db2CREAT)
--CREATE TABLE/INDEX DDL FOR: TSOID02.CUSTOMER_TABLE
--
CREATE TABLE TSOID02.CUSTOMER_TABLE
(CUSTOMER_NUMBER CHAR(6) NOT NULL WITH DEFAULT,
COMPANY_NAME CHAR(30) NOT NULL WITH DEFAULT,
ADDRESS CHAR(30) NOT NULL WITH DEFAULT,
CITY CHAR(25) NOT NULL WITH DEFAULT,
STATE CHAR(2) NOT NULL WITH DEFAULT,
ZIP_CODE CHAR(9) NOT NULL WITH DEFAULT,
COUNTRY CHAR(20) NOT NULL WITH DEFAULT,
AREA_CODE CHAR(3) NOT NULL WITH DEFAULT,
TELEPHONE_NUM CHAR(7) NOT NULL WITH DEFAULT,
CONTACT_NAME CHAR(30) NOT NULL WITH DEFAULT,
CONTACT_TITLE CHAR(30),
CONTACT_ADDR CHAR(30),
CONTACT_CITY CHAR(25),
CONTACT_STATE CHAR(2),
CONTACT_ZIP CHAR(9),
CONTACT_COUNTRY CHAR(10),
CONTACT_AREA_CD CHAR(3),
CONTACT_TELEPHONE CHAR(7),
PRIMARY KEY (CUSTOMER_NUMBER)
) IN DATABASE TSOID01H;
--
CREATE UNIQUE INDEX TSOID02.CUST_IDX
ON TSOID02.CUSTOMER_TABLE
(CUSTOMER_NUMBER ASC)
CLUSTER
SUBPAGES 4
BUFFERPOOL BP0
CLOSE YES;
--
--CREATE TABLE/INDEX DDL FOR: TSOID02.CONTACT_TABLE
--
CREATE TABLE TSOID02.CONTACT_TABLE
(CUSTOMER_NUMBER CHAR(6) NOT NULL WITH DEFAULT,
CONTACT_ID CHAR(2) NOT NULL WITH DEFAULT,
CONTACT_NAME CHAR(30) NOT NULL WITH DEFAULT,
TITLE CHAR(30),
CONTACT_CODE CHAR(4) NOT NULL WITH DEFAULT,
ADDRESS CHAR(30) NOT NULL WITH DEFAULT,
CITY CHAR(25) NOT NULL WITH DEFAULT,
STATE CHAR(2) NOT NULL WITH DEFAULT,
ZIP_CODE CHAR(9) NOT NULL WITH DEFAULT,
COUNTRY CHAR(20) NOT NULL WITH DEFAULT,
AREA_CODE CHAR(3) NOT NULL WITH DEFAULT,
TELEPHONE_NUM CHAR(7) NOT NULL WITH DEFAULT,
PRIMARY KEY (CUSTOMER_NUMBER,
CONTACT_ID)
) IN DATABASE TSOID01H;
--
C
REATE UNIQUE INDEX TSOID02.CONT_IDX
ON TSOID02.CONTACT_TABLE
(CUSTOMER_NUMBER ASC,
CONTACT_ID ASC)
CLUSTER
SUBPAGES 4
BUFFERPOOL BP0
CLOSE YES;
--
--ALTER TO ADD FOREIGN KEYS TO ALL TABLES
--
ALTER TABLE TSOID02.CONTACT_TABLE
ADD FOREIGN KEY
(CUSTOMER_NUMBER)
REFERENCES TSOID02.CUSTOMER_TABLE
ON DELETE CASCADE;
LDDRV Step Parameter List and DD Statements
XFREXEC is the File-AID/RDX program name.
The parameter information in the PARM field in the EXEC statement must have the format as shown in the following table:
EXEC Statement PARM Field——LDDRV Step
Parameter | Default Value | Length | Description |
|---|---|---|---|
Product | FR | 2 | File-AID/RDX |
Option | 3 | 1 | File-AID/RDX option number. |
Operating Mode | B | 1 | B : Batch |
The following DD statements are required for the LDDRV step:
DD Statements—LDDRV Step
DD Statement | Description |
|---|---|
STEPLIB | File-AID/RDX load libraries (CXVJLOAD and SXVJLOAD); Db2 load library. |
RDXMLIB | Library containing File-AID/RDX messages. |
EXTRACT | File-AID/RDX extract file name. |
EXTPARMS | File containing the load parameters (see EXTPARMS File). |
DISCARDS | File-AID/RDX discard file. |
SPLITnnn | Output file to which File-AID/RDX writes data for a single table from the extract file.
|
SRTCDnnn | Control card used by File-AID/RDX to sort each split file before the data is loaded into a table.
|
SYSOUT | Output class for error messages and reports. |
RDXSQLCD | Output class for detailed SQL error information from Db2. |
SYSPRINT | Standard output stream. |
SYSTERM | Output class for runtime errors. |
TPTPRINT | Standard output stream for optional diagnostics. |
SYSIN | File-AID/RDX’s Load Control Table (member Db2LCT). Used to verify authorities and identify tables that need to be created. For more information, see Db2 Load Control Table. |
Db2 Load Control Table
The Load Control Table (member Db2LCT in the SYSIN control card PDSE) contains information about the source and target tables (see the following figure). It is the input (SYSIN) to the LDDRV step.
Load Control table (member Db2LCT)
*
*
* SOURCE AND TARGET OBJECTS
* ----------------------------------
SC: FARDX
ST: PART_TABLE
TI: DEL=Y DEP=N ROW COUNT= 29 NNN E REP=N
TC: FARDX
TT: PART_TABLE
*
* TABLE CONTROL NUMBER
CN: 001
*
*
* NULL CCSID
* TARGET COLUMN NAME DEF SOURCE COLUMN NAME TYPE OFFSET OFFSET LENGTH TARGET SOURCE
*-------------------- --- -------------------- ---- ------ ------ ------ ------ ------
PART_NUMBER N PART_NUMBER C 14 6
PART_NAME N PART_NAME C 20 25
EFFECT_DATE N EFFECT_DATE DT 45 10
EQUIVALENT_PART N EQUIVALENT_PART C 55 0 6
PURCH_PRICE N PURCH_PRICE D 61 2 9,2
SETUP_COST N SETUP_COST D 66 4 9,2
LABOR_COST N LABOR_COST D 71 6 9,2
UNIT_OF_MEASURE N UNIT_OF_MEASURE C 76 8 2
MATERIAL_COST N MATERIAL_COST D 78 10 9,2
REWORK_COST N REWORK_COST D 83 12 9,2
AVAILABILITY_IND N AVAILABILITY_IND C 88 1
ENGR_DRAW_NUM N ENGR_DRAW_NUM C 89 6
*
*
* SOURCE AND TARGET OBJECTS
* ----------------------------------
SC: FARDX
ST: ORDER_TABLE
TI: DEL=Y DEP=N ROW COUNT= 35 NNN E REP=N
TC: FARDX
TT: ORDER_TABLE
*
* TABLE CONTROL NUMBER
CN: 002
*
* NULL CCSID
* TARGET COLUMN NAME DEF SOURCE COLUMN NAME TYPE OFFSET OFFSET LENGTH TARGET SOURCE
*-------------------- --- -------------------- ---- ------ ------ ------ ------ ------
ORDER_NUMBER N ORDER_NUMBER C 12 6
CUST_NUM N CUST_NUM C 18 6
SOC_SEC_NUM N SOC_SEC_NUM C 24 11
CREDIT_CARD_NUM N CREDIT_CARD_NUM C 35 16
ORD_TYPE N ORD_TYPE C 51 8
Each source/target pair is identified by its table control number and for each, there are two tables. The first table contains the following information:
Db2 Load Control Table—Source and Target Table Information
Field Name | Description | |
|---|---|---|
SC: | The source table creator ID | |
ST: | The source table name | |
TI: | Table information | |
DEL | For TT: tables only. Indicates whether or not rows should be deleted before the load is executed. | |
Y | Delete rows before loading using the DELETE step. | |
N | Do not delete rows before loading. | |
DEP | For TT: tables only. Indicates whether or not File-AID/RDX should attempt to replace (update) existing rows from the target table with rows from the source table. | |
Y | Yes | |
N | No | |
Row Count | For TT: tables only. Identifies the number of rows to be loaded into the target table. | |
N or Y | Represents the D record supplement indicator (see also Product Record — 0). | |
N or Y | Represents the extract IMPLICITLY HIDDEN columns indicator (see also Extract IMPLICITLY HIDDEN columns). | |
N, C or V | Represents the compression indicator (see also Compress). | |
E or U | Represents the encoding indicator (see also Db2 Format). | |
REP=N or Y | Represents the replace matches indicator (see also Replace Matches). | |
TC: | The target table creator ID | |
TT: | The target table name | |
Table Control Number | ||
Cnnn: | The table control number has the prefix C for Create. | |
The second table contains the following column information:
Load Control Table—Column Mapping Information
Field Name | Description | |
|---|---|---|
Target / *Source Column Name | Contains a list of the target and source column names. the source column names are identified with an asterisk (*).This information is taken from the extract file and the Column Mapping screen. If you mapped any target columns to source columns with different names, those mappings are reflected here. | |
Def | Indicates whether the target column will contain the default value, a literal default value, or nulls. | |
Y | Yes - The column will contain the default value defined for it. | |
N | No - The column will contain the value of the source column. | |
L | Literal - The column will contain the value of the literal definition (Lnn) assigned to it during column mapping. | |
Type | Indicates the data type of the target columns. This information is taken from the extract file and the Column Mapping screen. | |
Offset | Indicates the offset for the source data in the extract file. | |
Null Offset | Indicates the offset for null indicators for the source data in the extract file. | |
Length | Indicates the length of the source columns. This information is taken from the extract file and the Column Mapping screen. | |
CCSID Target | Indicates the CCSID for the target column if it is Unicode encoded. | |
CCSID Source | Indicates the CCSID for the source column if it is Unicode encoded. | |
DELETE Step Parameter List and DD Statements
XFREXEC is the File-AID/RDX program name.
The parameter information in the PARM field in the EXEC statement must have the format as shown in the following figure:
EXEC Statement PARM Field—DELTEnnn Step
Parameter | Default Value | Length | Description |
|---|---|---|---|
Product | FR | 2 | File-AID/RDX |
Option | 6 | 1 | File-AID/RDX option number. |
Operating Mode | B | 1 | B : Batch |
The following DD statements are required for the DELETE step:
DD Statements—DELETE Step
DD Statement | Description |
|---|---|
STEPLIB | File-AID/RDX load libraries (CXVJLOAD and SXVJLOAD); Db2 load library. |
RDXMLIB | Library containing File-AID/RDX messages. |
EXTPARMS | File containing the load parameters (see EXTPARMS File). |
SYSIN | File-AID/RDX’s Load Control Table. Used to verify authorities and identify tables that need to have all data deleted. For more information, see Db2 Load Control Table. |
DLRPT | Output class for File-AID/RDX Delete Report. |
SYSOUT | Output class for error messages and reports. |
RDXSQLCD | Output class for detailed SQL error information from Db2. |
SYSPRINT | Standard output stream. |
TPTPRINT | Standard output stream for optional diagnostics. |
SYSTERM | Output class for runtime errors. |
SORTnnn Step DD Statements
This step uses your site’s SORT utility. The following DD statements are required for the SORT step:
DD Statements—SORT Step
DD Statement | Description |
|---|---|
STEPLIB | Your site’s SORT library. |
SORTIN | SPLIT file from the LDDRV step. |
SORTOUT | Output from the SORT. |
SYSOUT | Output class for messages and reports. |
SORTWK01 | Work files required by the SORT utility. |
SYSIN | File-AID/RDX file that will contain the SORT cards generated by the LDDRV step. |
ICETOOL Step DD Statements
This optional step uses the ICETOOL utility. The following DD statements are required for the ICETOOL step:
DD Statements—ICETOOL Step
DD Statement | Description |
|---|---|
STEPLIB | Your site’s SORT library. |
DFSPARM | Supplies DFSORT program control statements and EXEC statement PARM options. |
$ORTPARM | Supplies SYNCSORT program control statements and EXEC statement PARM options. |
SYSOUT | Output class for messages and reports. |
TOOLMSG | Messages from the ICETOOL utility. |
DFSMSG | Messages from the individual sorts. |
CnnnCNTL | File that will contain the SORT cards generated by the LDDRV step. Associated with each SnnnIN DD. |
SnnnIN | SPLIT file from the LDDRV step. A unique DD generated for each split file to sort. |
SnnnOUT | Output from the SORT. A unique DD generated for each sort output file. |
SORTWK01 | Work files required by the SORT utility. |
TOOLIN | File that associates each CnnnCNTL, SnnnIN, and SnnnOUT DD for ICETOOL to sort. |
LDSQLIN Step Parameter List and DD Statements
XFREXEC is the File-AID/RDX program name.
The parameter information in the PARM field in the EXEC statement must have the format as shown in the following table:
EXEC Statement PARM Field—DELTE Step
Parameter | Default Value | Length | Description |
|---|---|---|---|
Product | FR | 2 | File-AID/RDX |
Option | 5 | 1 | File-AID/RDX option number. |
Operating Mode | B | 1 | B : Batch |
The following DD statements are required for the LDSQLIN step:
DD Statements—LDSQLIN Step
DD Statement | Description |
|---|---|
STEPLIB | File-AID/RDX load libraries (CXVJLOAD and SXVJLOAD); Db2 load library. |
RDXMLIB | Library containing File-AID/RDX messages. |
EXTPARMS | File containing the load parameters (see EXTPARMS File). |
SYSIN | File-AID/RDX’s Load Control Table. Used to verify authorities and identify tables that need to be created. For more information, see Db2 Load Control Table. |
LOADIN | Input file(s) generated during sort or split processing. |
SYSOUT | Output class for error messages and reports. |
RDERRORS | Output class for detailed SQL error information from Db2 and column mapping error information from File-AID/RDX. |
XCPTNRPT | Output class for Insert Exception Report. |
TOTLSRPT | Output class for Load Summary Report. |
COMMTRPT | Output class for Commit Report. |
DISCARDS | File-AID/RDX discard file. |
SYSPRINT | Standard output stream. |
TPTPRINT | Standard output stream for optional diagnostics. |
SYSTERM | Output class for runtime errors. |
SQL Insert Return Codes
An execution return code (RC) appears in the output listing. For return codes other than 0, an error code and message indicating the specific problem also appear in the listing. In general, the return codes can be summarized as follows:
Return Code | Description |
|---|---|
0 | Job ran to completion without error. |
4 | Job ran to completion without error, warnings issued. |
8 | Job ran with error. Subsequent job steps stopped. |
16 | Severe error, job aborted. |
Related topics