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

How to Write IMS RETRIEVE - SELECT statement in Easytrieve


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Suryyogi

New User


Joined: 17 Jun 2006
Posts: 27

PostPosted: Wed Jan 31, 2007 8:52 am
Reply with quote

I want to write a report on IMS DB.
I have 4 segments as below :
key
LEVEL 1 (ROOT) Policy policy no
2 Account act no
3 Covrage date
3 Bill date

I want to retirive some info from pol,bill segment giving condition
on dates of coverage and bill also.

How should I write the RETRIEVE - SELECT statement in eztrieve for this?
Or if it is not possible then what is another easy way ?
Please help me to get efficient solution for this.....

Thank you
Yogesh
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Sat Feb 03, 2007 10:58 pm
Reply with quote

Yogesh,

I know nothing of IMS, but have you checked your EZT manual?

Bill
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sat Feb 03, 2007 11:30 pm
Reply with quote

EZT is similar to any other mainframe programming language, it's possible to perform READ / UPDATE etc on IMS DB segments.
In EZT the programming is easier than COBOL.

There are two ways to read IMS DB in EZT.

1. Read all segments from Database sequentially. This will be handled in the JOB statement.

2. Use Qualified SSA's and read database segment.

Reply which approach you are looking for?
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 -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Dynamically pass table name to a sele... DB2 2
No new posts Using Java/C/C++ to retrieve dataset ... Java & MQSeries 6
This topic is locked: you cannot edit posts or make replies. How To Write, Compile and Execute Cob... COBOL Programming 5
No new posts Compare two files with a key and writ... SYNCSORT 3
Search our Forums:

Back to Top