IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Will cursors work with SPUFI!


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
abcd.us786

New User


Joined: 06 Dec 2006
Posts: 5
Location: India

PostPosted: Mon Jan 08, 2007 12:36 pm
Reply with quote

will cursors work with SPUFI !!!!

if yes plz give an example code!
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Mon Jan 08, 2007 12:42 pm
Reply with quote

Hi There,


Quote:
will cursors work with SPUFI !!!!


What do u mean by that we use cursor in our program to handle multiple record o/p but in spufi it will give u file output so there is no need to give cursor there u can directly give ur select query no matter how many record are o/p

Hope it will helpful
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Mon Jan 08, 2007 1:36 pm
Reply with quote

Why can't you simply try it?

O.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Mon Jan 08, 2007 2:32 pm
Reply with quote

Hi,
guptae wrote:
we use cursor in our program to handle multiple record o/p but in spufi it will give u file output so there is no need to give cursor there
Huh, I always thought cursors were input?

Correct me if I'm wrong.

Bill
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Mon Jan 08, 2007 2:46 pm
Reply with quote

Hi Bill,

Quote:
What do u mean by that we use cursor in our program to handle multiple record o/p but in spufi it will give u file output so there is no need to give cursor there u can directly give ur select query no matter how many record are o/p


I specify that we used to give cursor in our program when we are expecting more than one row as o/p & we want to process all the records

Hope i made myself clear enough
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Mon Jan 08, 2007 3:04 pm
Reply with quote

Hi,

Oh, yes, I understand now. My mistake was I thought o/p was from the program while you meant from the select..... icon_lol.gif

Bill

Ekta? Could you help me understand sooner by using a little more punctuation or maybe a new line for each thought or statement?

Thanks you very much for responding to my confusion,

Bill (again icon_lol.gif )
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DELETE SPUFI DB2 1
No new posts isfline didnt work in rexx at z/OS ve... CLIST & REXX 7
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
No new posts Beautifying the SPUFI output DB2 5
No new posts Positioned Deletes/Updates using curs... DB2 3
Search our Forums:

Back to Top