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).
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: