18.30 - we can go for distinct or ‘fetch first 1 row only’ clause as well
@sindhuvelusamy91163 жыл бұрын
All the videos are very informative. Thanks for the great initiative.
@shravyagshetty8 ай бұрын
Good content. It was very helpfull
@siddusmart93483 жыл бұрын
Helpfully one
@MainframeGuru2 жыл бұрын
Thanks Dear 👍
@siddusmart93482 жыл бұрын
@@MainframeGuru anytime bro
@vinodhkumar21563 жыл бұрын
Very Useful, Thanks!!
@MainframeGuru2 жыл бұрын
Thanks Vinod for watching the video. Glad to hear that!👍
@RAHUL-be8kv2 жыл бұрын
Last SQL with select * you can't use just group by one column
@TheTarakantGuide2 жыл бұрын
good one
@sumibharali40613 жыл бұрын
Hi, could you please make some video on sort utilites.
@krishna_is_great3 жыл бұрын
for how many years experience does this questions ask
@bjohnson83712 жыл бұрын
You, should know this in less than 6 months.
@-Mathanv11 ай бұрын
❤
@mahendrareddy57213 жыл бұрын
can u please explain resolve process of -811 and 305 error codes
@ABHISHEKI9873 жыл бұрын
for -811, we need to use cursor. for -305 we should use Null Indicator.
@ashwinkamat52143 жыл бұрын
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)