Unload data based on some keys from IMS DB

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

I am trying to unload data from IMS DB, using FILE-AID,Unloading is working for me. I have to unload based on some keys.......... How to do that???

Devzee · Posted: Tue May 08, 2007 8:34 pm

In FileAid Extract option, there is option:

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

Thanh you .

Actually we have to specify the key to be searced in that PS right? Shall i give the key alone in the PS? If i am giving the key in PS , in what position i have to place the key the file in PS? Can i specify the key alone in the file?

eg:
My key is : A00001

PS

A00001

is it enough?

one more question?

After unloading the file, is it possible to read via application program.(Using ordinary file read)
or else is it possible to use GN or GU call to get data from the file.(I am new to IMS)

Devzee · Posted: Wed May 09, 2007 8:54 am

Try selecting the Extract option in File Aid and see what happens next.

In the next screen there is option for giving the key data and also you can map with cobol copybook for inputting key values.

After the extract is succesful, you can read data using ordinary file read and no need to use DLI Calls to interpret data of the extracted file.

After trying post your reply.

Bitneuker · Posted: Thu May 10, 2007 12:39 am

Nagendran · New User Joined: 24 Jan 2007 Posts: 89 Location: USA

After.. Unloading data from IMS DB. The dataset contains record in Following order.

Eg... Consider two segments A and B,

Segment occurence of A
Segment occurence of B
Segment occurence of B
Segment occurence of A
Segment occurence of B
Segment occurence of B
Segment occurence of B
Segment occurence of A
Segment occurence of B

The no of child segment occurence is different for each root segment occurence...

How to read it through application program in the order in which segment present??

how to identify the segment occurence we are going ot read????

Thanks in Advance,
Nagu

Bitneuker · Posted: Fri May 11, 2007 12:23 am

What about normal programming as if it was an OS-sequential file with two levels? We call this the level-method. Read the first A, process it and read all subsequent B's until the read one is another A. Looks like normal programming to me and has nothing to do with IMS. Unless your last question made things more special, in which case you should explain more.