Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Using Static SQL : Task F: Link the Static SQL Handler

Task F: Link the Static SQL Handler
Sample JCL
To link the Static SQL handler, use the JCL generated as member LINKDB2S in the file specified in @DB2SERVERJCL when you run @STATICSQL.
The JCL keeps a history of all the EXEC statements used to link the handlers generated each time you ran @STATICSQL. Ensure that the proper EXEC statement (the one containing the prefix/suffix you chose when you ran @STATICSQL) is uncommented (MEMBER=prefix/suffixGEMP in the JCL mentioned above).
Default Static SQL Handlers
The generated Static SQL handler defaults to AMODE(31) and RMODE(ANY). If you use a Static SQL handler with the TIBCO Service Gateway for IMS/DB, you must add the default AMODE and RMODE to the link control card input statements as follows:
AMODE(31), RMODE(24)
The following JCL shows the changes to make to each link control card member generated by @STATICSQL if you are using the TIBCO Service Gateway for IMS/DB.

 
INCLUDE OBJECT2(D2CSGEMP)
MODE AMODE(31),RMODE(24)
ENTRY D2CSGEMP
NAME D2CSGEMP(R)

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved