How does CA Telon Import a DB2 Table into the TDF?

Document ID : KB000105001
Last Modified Date : 05/07/2018
Show Technical Document Details
Introduction:
Importing a DB2 table from the DB2 Catalog, into Data Administration (Option 2), of the Telon Design facility 
Question:
How does CA Telon handle the Importing of a DB2 Table, into the TDF? 
Environment:
CA Telon interfacing with the DB2 catalog.
Answer:
Here is how our CA Telon program of TNMCDB2I is handled. 
1.We send the source for this program as CAWLSRC(#DB2ICOB) 
2. Each site makes modifications to the source to fit their shop standards. 
3. Then you will send the program through the following steps. 

//* DB2 PRE COMPILE OF TNMCDB2I 
//************************************************ 
//DB2PC EXEC PGM=DSNHPC,REGION=4096K, 
// PARM=('SOURCE','HOST(IBMCOB)','APOST') 

//* COMPILE THE GENERATED PROGRAM 
//***************************************************************** 
//COB EXEC PGM=IGYCRCTL,REGION=512K,COND=(5,LT,DB2PC), 
// PARM='SOURCE,MAP,LIST,SSRANGE,LIB,APOST,NOSEQ,RENT,XREF' 

//* LINK THE GENERATED PROGRAM 
//************************************************************ 
//LKED EXEC PGM=IEWL,REGION=1024K, 
// PARM='MAP,XREF,LIST,NORENT,REUS,AMODE=31,RMODE=24' 
//SYSIN DD * 
INCLUDE SYSLIB(DSNELI) 
ENTRY TNMCDB2I 
NAME TNMCDB2I(R) 

//********************************************************* 
//* DB2BIND - BIND THE PLAN FOR THE SQL INTERFACE 
//SYSTSIN DD * 
DSN SYSTEM(D11A)      <== your DB2 Subsystem 
BIND PLAN(TNMCDB2I) MEMBER(TNMCDBRM) ACT(REPLACE) ISOLATION(CS) 
END 
/* 
//SYSIN DD * 
GRANT EXECUTE ON PLAN TNMCDB2I TO PUBLIC; 
Additional Information:
Since TNMCDB2I is dynamically called, it must be available to the Telon Design Facility at runtime.