Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 16
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: 1805
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: 16
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: 1805
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 Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm
No new posts Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us