IBM Mainframe Forum Index
Log In
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register

SQLCODE says NO ADDR when compiled using Changeman

IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message

New User

Joined: 25 Jul 2005
Posts: 92
Location: India

PostPosted: Tue Aug 07, 2007 11:15 am
Reply with quote

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


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 icon_biggrin.gif .
Back to top
View user's profile Send private message
Majid Hussain

New User

Joined: 18 Aug 2007
Posts: 20
Location: Bangalore

PostPosted: Sun Oct 28, 2007 8:03 pm
Reply with quote

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.

Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools


Similar Topics
Topic Forum Replies
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts SQLCODE=-204 SQLSTATE=42704 DB2 4
No new posts Getting sqlcode 805 while executing R... DB2 10
No new posts Different result between normal rexx ... CLIST & REXX 2
No new posts SQLCODE -950 in PREPARE statement ... DB2 2
Search our Forums:

Back to Top