Search found 6 matches

by Suntles Singh
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...
by Suntles Singh
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...
by Suntles Singh
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.
by Suntles Singh
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?
by Suntles Singh
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.

Go to advanced search