Introduction:
Import a Table from the DB2 Catalog, into the Telon Design Facility.
Question:
When I try and Import a DB2 Table from the DB2 catalog, using a CA D2 command in Option 2 Data Administration when within the Telon Design Facility, I am getting a Load Failure with an abend S806(member not in indicated library).
Environment:
Any version of DB2 with a supported version/release of Telon
Answer:
After you have made your source changes to # DB2ICOB, that are shop specfic, and then recompiling your #DB2ICOB, and creating an executable of TNMCDB2I using:
LINKAGE EDITOR CONTROL CARDS
INCLUDE SYSLIB(DSNELI)
ENTRY TNMCDB2I
NAME TNMCDB2I(R)
do a bind of the Package and a Bind of the Plan.
Copy your new TNMCDB2I module into your CAWLOAD, as when you do a CA D2 in the TDF, it will search your TNSYSLIB file at runtime.
Or if you created a separate Loadlib, you can concatenate your new loadlib to the ALLOC F(TNSYSLIB)
Additional Information:
CREATE A PLAN USING THE DBRM FROM THIS MODULE
THIS PLAN CAN BE ANY NAME, AND MUST BE AUTHORIZED FOR
EXECUTION (NOT FOR MODIFICATION) BY ANY TELON USER WHO
MAY USE OPTION 2 OF THE TDF TO ACCESS THE DB2 CATALOG.
MODIFY THE TDF CLIST TO EXECUTE THE TDF UNDER THE DSN
COMMAND PROCESSOR USING THE ABOVE PLAN