View previous topic :: View next topic
|
Author |
Message |
Jimy Carol
New User
Joined: 31 Aug 2012 Posts: 25 Location: Australia
|
|
|
|
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 |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
And the SQL bind? |
|
Back to top |
|
|
Jimy Carol
New User
Joined: 31 Aug 2012 Posts: 25 Location: Australia
|
|
|
|
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 |
|
|
prino
Senior Member
Joined: 07 Feb 2009 Posts: 1306 Location: Vilnius, Lithuania
|
|
|
|
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 |
|
|
Jimy Carol
New User
Joined: 31 Aug 2012 Posts: 25 Location: Australia
|
|
|
|
I bind the program again , still the problem persist. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Jimy Carol
New User
Joined: 31 Aug 2012 Posts: 25 Location: Australia
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for letting us know
d |
|
Back to top |
|
|
|