Need a better display for sql code.
Posted: Tue Mar 26, 2013 6:00 pm
In my program there is a select clause than i move sqlcode to a variable and display it, when it goes to an if(diferent from zeros) clause for an error routine it enters that -if but the display is 00000000. First i thought this had no logic then i wanna know if there is a better way to do this i apreciate your help thx.
I get display 00000000 from display variable
Thank you in advance.
select xxxx
into xxx
from xxx
where xxx
end exec
move sql code to variable
display variable
if sql code not equal zeros
perfor error routine ....
into xxx
from xxx
where xxx
end exec
move sql code to variable
display variable
if sql code not equal zeros
perfor error routine ....
I get display 00000000 from display variable
Thank you in advance.