Can I modify #DB2ICOB to my specifications?
search cancel

Can I modify #DB2ICOB to my specifications?

book

Article ID: 12587

calendar_today

Updated On:

Products

Telon Application Generator

Issue/Introduction

Telon and interfacing with the DB2 Catalog.



Can I modify my #DB2ICOB source to my specifications?

Environment

Importing a DB2 table from the DB2 CATALOG.

Resolution

THIS INTERFACE MODULE MUST BE INSTALLED BY EACH INSTALLATION 

THAT WILL USE THE DB2 CATALOG ACCESS FACILITY OF THE TDF.    

                                                             

AFTER IT HAS BEEN INSTALLED AND THE INSTALLATION HAS REVIEWED

THE INTERFACE, CHANGES MAY BE MADE TO SUPPLY PARAMETERS TO   

THE CALLING TDF PROGRAM THAT ARE NOT AVAILABLE AT ALL DB2    

INSTALLATIONS.  EXAMPLES ARE:                                

   - USING COMMENT FOR DESCRIPTION OF THE TABLE;             

   - USING LABEL FOR THE DCLGEN MEMBER OF THE TABLE;         

   - USING LABEL FOR THE HOST VARIABLE ALIAS OF THE COLUMN;  

   - USING ADDITIONAL "SYSIBM" TABLES FOR ADDITIONAL INFO.   

THERE ARE COMMENTS THAT START WITH *I THAT SHOW HOW TO USE   

THE SYSIBM.SYSINDEXES AND SYSIBM.SYSKEYS CATALOG TABLES TO   

CREATE EXTRA "TLNROW"S THAT REFLECT THE APPROPRIATE "KEYS"   

OF A TABLE BEING IMPORTED.  THE INSTALLATION OF THIS FACILITY

IS NOT REQUIRED, BUT IT IS QUITE USEFUL AND SHOWS HOW ADD-  

ITIONAL FUNCTION CAN BE ADDED TO THE INTERFACE.  IT HAS NOT  

BEEN MADE A STANDARD FEATURE BECAUSE IT DOES CONSUME MUCH MORE

RESOURCES DUE TO THE LACK OF AN INDEX ON "SYSIBM.SYSKEYS".   

Additional Information

A SUMMARY OF THE STEPS REQUIRED TO INSTALL THIS MODULE ARE:

 

1. CREATE A VIEW OF SYSIBM.SYSTABLES AND SYSIBM.SYSCOLUMNS 

2. COPY THIS MEMBER TO "TNMCDB2I" AND THEN MODIFY IT TO    

   CONFORM TO THE VIEWS CREATED IN STEP 1.                 

3. USE A BATCH COMPILE PROC (WITH DB2 SUPPORT) TO          

   COMPILE AND LINK THIS MEMBER INTO THE TELON LOAD LIBRARY

4. CREATE A PLAN USING THE DBRM FROM THIS MODULE           

5. MODIFY THE TDF CLIST TO EXECUTE THE TDF UNDER THE DSN   

   COMMAND PROCESSOR USING THE ABOVE PLAN