For -305 , if you are facing -305 during the fetch from the table , that means there is atleast one column which you fetched is having a null value. You can resolve this by declaring S9(4) comp. field in working storage and use this field in the 'fetch into' cursor along with the host variable of the field which is returning Null . This will return SQL code =0 and and value in the S9(4) comp field declared will be negative (-1)
18.30 - we can go for distinct or ‘fetch first 1 row only’ clause as well
All the videos are very informative. Thanks for the great initiative.
Good content. It was very helpfull
Very Useful, Thanks!!
Thanks Vinod for watching the video. Glad to hear that!👍
Helpfully one
Thanks Dear 👍
@@MainframeGuru anytime bro
Last SQL with select * you can't use just group by one column
good one
Hi, could you please make some video on sort utilites.
for how many years experience does this questions ask
You, should know this in less than 6 months.
❤
can u please explain resolve process of -811 and 305 error codes
for -811, we need to use cursor. for -305 we should use Null Indicator.
For -305 , if you are facing -305 during the fetch from the table , that means there is atleast one column which you fetched is having a null value.
You can resolve this by declaring S9(4) comp. field in working storage and use this field in the 'fetch into' cursor along with the host variable of the field which is returning Null . This will return SQL code =0 and and value in the S9(4) comp field declared will be negative (-1)