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

Multi row fetch - "for read only"


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

New User


Joined: 09 May 2016
Posts: 24
Location: India

PostPosted: Sun Aug 14, 2016 12:52 am
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

Global Moderator


Joined: 21 Sep 2010
Posts: 2567
Location: NYC,USA

PostPosted: Sun Aug 14, 2016 10:00 pm
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: 24
Location: India

PostPosted: Sun Aug 14, 2016 10:13 pm
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

Global Moderator


Joined: 21 Sep 2010
Posts: 2567
Location: NYC,USA

PostPosted: Mon Aug 15, 2016 8:33 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts XML Parsing in COBOL creating "h... COBOL Programming 0
No new posts Need to read duplicate rows from tabl... DB2 3
No new posts Read 4MB message and split into multi... COBOL Programming 9
No new posts How do i verify the char field is hav... PL/I & Assembler 1
No new posts how to read accounting information in... COBOL Programming 1
Search our Forums:

Back to Top