View previous topic :: View next topic
|
Author |
Message |
Suryyogi
New User
Joined: 17 Jun 2006 Posts: 27
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Yogesh,
I know nothing of IMS, but have you checked your EZT manual?
Bill |
|
Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
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 |
|
|
|