Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SQLCODE says NO ADDR when compiled using Changeman

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
murali922

New User


Joined: 25 Jul 2005
Posts: 92
Location: India

PostPosted: Tue Aug 07, 2007 11:15 am    Post subject: SQLCODE says NO ADDR when compiled using Changeman
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
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 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    Post subject: Re: SQLCODE says NO ADDR when compiled using Changeman
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.

Regards,
Majid
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Finding the plan when code compiled u... Ahemad DB2 1 Fri Dec 01, 2017 6:38 pm
No new posts Changeman - VV MM elixir1986 Compuware & Other Tools 7 Thu Aug 31, 2017 9:45 pm
No new posts Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us