I have a IMS region, which is connected to a DB2 subsystem.
I have a IMS-DC DB2 program.
I have the SQLCA in working storage and a SELECT statement in the program. Otherwise its all plain cobol
I have compiled the program using Changeman, using the following options switched on :-
You need to select for DB2-IMS attach facility and not for DB2 call attach, since its only used when you are using call attach facility. Include an LCT entry for DFSLI000 stub. recompile the program. do check for db2 precompile option in the changeman.
Make sure the table exists in the same lpar in which you are logged in. The transacation name should be the plan name for the package. Atleast, these are the step that worked for me. Hope, it will help you or someone else if you are not able to resolve the issue yet.