SQLCODE says NO ADDR when compiled using Changeman

murali922 · New User Joined: 25 Jul 2005 Posts: 92 Location: India

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
program.

I have compiled the program using Changeman, using the following options switched on :-

IMS DLITxxx ENTRY
XPEDITER
DB2-IMS ATTACH
DB2-CALL ATTACH

Now when I invoke the online transaction, when control comes to the EXEC SQL, it never
really executes it. When I check SQLCODE, it says NO ADDR.

I am 100 % positive that the SQL statement is not at fault. I just want to know why the SQL statement
doesnt get executed, and what does it mean when SQLCODE says NO ADDR.

Thanks for the help

.

Majid Hussain · New User Joined: 18 Aug 2007 Posts: 20 Location: Bangalore

Hi Murali,

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.

Regards,
Majid