Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Will cursors work with SPUFI!

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Will cursors work with SPUFI!
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: 1187
Location: Bangalore,India

PostPosted: Mon Jan 08, 2007 12:42 pm    Post subject:
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: 2360
Location: Israel

PostPosted: Mon Jan 08, 2007 1:36 pm    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Mon Jan 08, 2007 2:32 pm    Post subject:
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: 1187
Location: Bangalore,India

PostPosted: Mon Jan 08, 2007 2:46 pm    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Mon Jan 08, 2007 3:04 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts What is the maximum number of sort wo... Pravina M SYNCSORT 2 Mon Mar 14, 2016 4:51 pm
No new posts Problems in File-Aid / DB2 Spufi whil... amitc23 CLIST & REXX 6 Fri Feb 12, 2016 1:59 pm
No new posts Not able to access the DB2 via SPUFI sakthikumarT DB2 6 Sat Nov 28, 2015 1:52 am
No new posts JCL -> Rexx -> XMITIP : Doesnt ... enrico-sorichetti CLIST & REXX 2 Thu Aug 06, 2015 11:09 pm
No new posts Select Variable=string Rexx does not ... Csongor CLIST & REXX 11 Thu May 07, 2015 9:33 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us