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
 

 

Is it possible how to use scrollable db2 queries in IMS

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

New User


Joined: 19 May 2007
Posts: 25
Location: Chennai

PostPosted: Tue Nov 25, 2008 9:54 am    Post subject: Is it possible how to use scrollable db2 queries in IMS
Reply with quote

Need to scroll the pages in IMS online,is there any inbuilt function in db2 to query to handle
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 25, 2008 10:00 am    Post subject:
Reply with quote

Hello,

No. DB2 is a separate database system.

Possibly, i misunderstand what you are asking. . .
Back to top
View user's profile Send private message
MGayathri

New User


Joined: 19 May 2007
Posts: 25
Location: Chennai

PostPosted: Tue Nov 25, 2008 10:21 am    Post subject: Reply to: Is it possible how to use scrollable db2 queries i
Reply with quote

To my knowledge CURSOR WITH HOLD OPTION as we use for CICS pseudoconversation to scroll wont be applicable for IMS DC,is there any other method used?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 25, 2008 10:58 am    Post subject:
Reply with quote

Hello,

You need to be sure to not mix things across boundaries. The cursor in cics is fo db2 (or some other sql-based database).

Quote:
is there any other method used?
Yes, but with IMS you will need to issue commands to navigate thru the database.

If you look in the IMS part of the forum there are many examples as well as links to the IMS documentation (which you will want to bookmark for your use).

Also, at the top of the page is a link to "IBM Manuals". Among them are the IMS Command Reference and the IMS Programming Guide.
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 Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Re-write queries to minimize the effe... Anil Khanna DB2 6 Mon Aug 04, 2014 1:49 pm
No new posts How Panel having 2 scrollable areas i... sushanth bobby TSO/ISPF 11 Wed Feb 12, 2014 2:45 pm
No new posts Running multiple queries in a PS file... nikhil_bansal04 JCL & VSAM 12 Wed Dec 18, 2013 12:06 pm


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