Debug a sql db2 code

[julen]

Hi everydoby!!

Is it possible with an application/programm, point the exact line of error in my code.



My sql db2 is for an as/400.

Any ideas of different applications/Programms??

Thanks.

 

[MarcLodge]

Julen,
What language is your host for the SQL? I understand that you are running on an as/400 but what is the host language that the sql is embedded in? Cobol? PL/1? Or is it a stored procedure or similar?

Any way, you should be able to put debugging displays into the language in order to identify the exact point of error. Have a look at other programs at your site to see how they determine errors - usually this type of thing is pre-defined, and all you have to do is clone it for your program.

If needs be, post the code here if it is not too big.

Hope this helps.

Marc

 

[julen]

Hi!

Thanks. My code is PL/SQL.


What I mean, is that if it is an application/program that in a real time can debug/trace the code.


Thanks again!!

 

[MarcLodge]

Hi Julen,
I've not used the AS/400 so am not aware of the various real time debugging tools that might be available. I would be surprised if there aren't any. Ask around at your site, I would imagine that any available tools would be widely known.

If all else fails, are you able to add display messages to the PL/SQL along the lines of:

"About to execute 1st SQL statement"
"1st SQL statement executed sucessfully"
"About to execute 2nd SQL statement"
"2nd SQL statement failed - SQLCODE is " SQLCODE

Marc