DB2 Multi row fetch

Dhrubojoty mukherjee · New User Joined: 23 Mar 2010 Posts: 14 Location: kolkata

What will be the SQL code at the last rowset fetch in case of multirow fetch in DB2. And exactly when it'll get SQL Code 100..

chandan.inst · Posted: Tue Nov 12, 2013 11:34 am Post subject: Reply to: DB2 Multi row fetch

Hi,

I will try to explain with an example.

Suppose you have a select query which will fetch around 250 rows and you have an cursor associated with query which is multi-fetch cursor with rowset positioning for 100 rows.

In such case you will get sqlcode 100 for the third fetch.

For first two fetches it will retrieve 100 rows each along with sqlcode 0 and third fetch will return only 50 rows along with sqlcode 100.

Hope this helps

Regards,
Chandan

Dhrubojoty mukherjee · New User Joined: 23 Mar 2010 Posts: 14 Location: kolkata

Thanks Chandan for your reply. But I just want to know when it gets SQL code +354..

dick scherrer · Posted: Tue Nov 12, 2013 8:15 pm Post subject:

Hello,

Why did you not mention the +354 originally?

We can't help much if you don't post the question you want answered . . .

GuyC · Posted: Tue Nov 12, 2013 8:24 pm Post subject:

when some rows have warnings
Warnings like
+802 if you fetch colA / colB and sometimes colB is zero.
+445 Truncation has occured
...

Dhrubojoty mukherjee · New User Joined: 23 Mar 2010 Posts: 14 Location: kolkata

So when some one gets sql code +354, it warns that it is the last row set fetch.And at the next row set fetch it'll get 100.

Akatsukami · Posted: Wed Nov 13, 2013 11:07 pm Post subject:

chandan.inst · Posted: Thu Nov 14, 2013 11:59 am Post subject: Reply to: DB2 Multi row fetch

Though Guyc is already explained let me try to explain again and I would suggest you to refer manuals.

This is what manual says for + 354
+354
A ROWSET FETCH STATEMENT MAY HAVE RETURNED ONE OR MORE ROWS OF DATA. HOWEVER, ONE OR MORE WARNING CONDITIONS WERE ALSO ENCOUNTERED. USE THE GET DIAGNOSTICS STATEMENT FOR MORE INFORMATION REGARDING THE CONDITIONS THAT WERE ENCOUNTERED

Lets say you are fetching 100 rows in a fetch and out of 100 rows around 10 rows has any sql error or warning then you will get +354

Hope its clear now

Regards,
Chandan

Dhrubojoty mukherjee · New User Joined: 23 Mar 2010 Posts: 14 Location: kolkata

Thanks a ton ...Chandan....