Search found 6 matches
- Wed May 03, 2017 1:42 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: Get record count also along with SUM.
- Replies: 2
- Views: 1273
Re: Get record count also along with SUM.
Thank you so much.
- Wed May 03, 2017 11:52 am
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: Get record count also along with SUM.
- Replies: 2
- Views: 1273
Get record count also along with SUM.
Hi, I know tha tusing SUM FIELDS I can sum the values in an input file in sort but how can I get the count of the fields too which are summed up? For example, if my input is like this: ABC 250 ABC 150 EFG 700 EFG 100 EFG 100 EFG 050 The output should look like: ABC 400 2 EFG 950 4 Please let me know...
- Wed Dec 30, 2015 11:33 am
- Forum: Interview Questions.
- Topic: Find the number of records fetched in a cursor.
- Replies: 9
- Views: 2146
Re: Find the number of records fetched in a cursor.
While working with cursors, I need to know the number of records selected by a cursor. I want to know this before processing the first row is fetched by cursor. Can we get this information from a variable of SQLCA? I don't know the answer to it. Need help. Let's take a step back and understand what...
- Tue Dec 29, 2015 2:00 pm
- Forum: Interview Questions.
- Topic: Find the number of records fetched in a cursor.
- Replies: 9
- Views: 2146
Re: Find the number of records fetched in a cursor.
Ok. But I still not sure why it is not possible.
- Mon Dec 28, 2015 2:33 pm
- Forum: Interview Questions.
- Topic: Find the number of records fetched in a cursor.
- Replies: 9
- Views: 2146
Re: Find the number of records fetched in a cursor.
Thank for the answers. So basically, it is not possible actually?
- Mon Dec 21, 2015 5:00 pm
- Forum: Interview Questions.
- Topic: Find the number of records fetched in a cursor.
- Replies: 9
- Views: 2146
Find the number of records fetched in a cursor.
Hi
While working with cursors, I need to know the number of records selected by a cursor. I want to know this before processing the first row is fetched by cursor. Can we get this information from a variable of SQLCA? I don't know the answer to it. Need help.
While working with cursors, I need to know the number of records selected by a cursor. I want to know this before processing the first row is fetched by cursor. Can we get this information from a variable of SQLCA? I don't know the answer to it. Need help.