Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Assembler program , -804 sql code error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PL/I & Assembler
View previous topic :: :: View next topic  
Author Message
Jimy Carol

New User


Joined: 31 Aug 2012
Posts: 25
Location: Australia

PostPosted: Thu Aug 01, 2013 7:39 pm    Post subject: Assembler program , -804 sql code error
Reply with quote

Hello ,

I have changed an Assmebler program which has SQL db2 call for SYSIBM.SYSTABLES , After inserting the new lines I am getting SQLERROR -804, reason code =16 , To check if the problem is beacause of my new code I commented the the call to the new routine , Still the problem occured . When i removed the new para completely by delelting the lines , the problem got fixed . I am not able to understand how the new code is affecting the SQl code despite its not executed . My compilation went fine with no addressability issue .

thanks for any pointers ,

Regards
carol
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1713
Location: UK

PostPosted: Thu Aug 01, 2013 7:48 pm    Post subject:
Reply with quote

And the SQL bind?
Back to top
View user's profile Send private message
Jimy Carol

New User


Joined: 31 Aug 2012
Posts: 25
Location: Australia

PostPosted: Thu Aug 01, 2013 8:01 pm    Post subject:
Reply with quote

Nic Clouston wrote:
And the SQL bind?


Hvnt bind , Not changed the SQL part , moroever the code works well after removing the new lines .
Back to top
View user's profile Send private message
prino

Active Member


Joined: 07 Feb 2009
Posts: 982
Location: Oostende, Belgium

PostPosted: Thu Aug 01, 2013 8:33 pm    Post subject:
Reply with quote

IIRC, the SQL translator generates "SQL statement numbers" based on the relative number of the sourceline of the SQL statement, and given the fact that removing the new lines and re-aasmbling the code result in no error, it also seems that you do not use the SQL consistency tokens.
Back to top
View user's profile Send private message
Jimy Carol

New User


Joined: 31 Aug 2012
Posts: 25
Location: Australia

PostPosted: Thu Aug 01, 2013 9:15 pm    Post subject:
Reply with quote

I bind the program again , still the problem persist.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 01, 2013 9:27 pm    Post subject:
Reply with quote

Hello,

Suggest hyou show your dba the colmpile/bind. Whetever is causing this is site-specific and your dba should be able to help.

It sounds as though code was changed that was not intended to be changed . . .
Back to top
View user's profile Send private message
Jimy Carol

New User


Joined: 31 Aug 2012
Posts: 25
Location: Australia

PostPosted: Thu Aug 01, 2013 9:48 pm    Post subject:
Reply with quote

prino wrote:
IIRC, the SQL translator generates "SQL statement numbers" based on the relative number of the sourceline of the SQL statement, and given the fact that removing the new lines and re-aasmbling the code result in no error, it also seems that you do not use the SQL consistency tokens.



Thanks for sharing this Prino !! the problem was actually with SQL token , after your hint I analyzed some other programs in my system and found that i am missing one macro in my program which does the tokenization of SQL in programs , after build of program with missing macro , Bind sql , the programs is running beautifully .
thank you all gentleman for the help
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Aug 01, 2013 9:58 pm    Post subject:
Reply with quote

Good to hear it is working - thank you for letting us know icon_smile.gif

d
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 -> PL/I & Assembler All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 3 Mon Dec 05, 2016 11:57 am
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us