Can I modify #DB2ICOB to my specifications?
Article ID: 12587
Updated On:
Products
Issue/Introduction
Telon and interfacing with the DB2 Catalog.
Can I modify my #DB2ICOB source to my specifications?
Environment
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
Feedback
