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
 

 

Multi row fetch - "for read only"

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Nileshkul

New User


Joined: 09 May 2016
Posts: 9
Location: India

PostPosted: Sun Aug 14, 2016 12:52 am    Post subject: Multi row fetch - "for read only"
Reply with quote

Help with a query please.
Planning to use multirow fetch in online screen. So have a query : does use of 'FOR FETCH ONLY' or 'FOR READ ONLY' allowed on multi row fetch cursor? Is it useful, benefecial to mention FOR FETCH on multi row fetch cursor?
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Sun Aug 14, 2016 10:00 pm    Post subject:
Reply with quote

Do you have manuals ? If not then look at the top part of this forum and then look what's the clause. This time I found for you, look here and there is no harm writing a simple program and test yourself or ask DBA.
Back to top
View user's profile Send private message
Nileshkul

New User


Joined: 09 May 2016
Posts: 9
Location: India

PostPosted: Sun Aug 14, 2016 10:13 pm    Post subject: Sorry if I was not clear
Reply with quote

My question was specific to multi row fetch cursor, planning to read 100 rows in single fetch
Thanks - will check manual for multi row fetch & sorry if I was not clear
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Mon Aug 15, 2016 8:33 am    Post subject:
Reply with quote

Why do you think the Read Only clause differs for multi row fetch without reading manuals?
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 Amount field is getting corrupted whe... thesumitk SYNCSORT 5 Tue Oct 18, 2016 8:20 pm
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts "DFSRRC00 vs IKJEFT01" for ... arunsoods All Other Mainframe Topics 5 Fri Aug 12, 2016 9:54 pm
No new posts Reading selected volumes of a multi-v... RickBig JCL & VSAM 6 Wed Jul 13, 2016 7:26 pm


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