Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Unload data based on some keys from IMS DB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Tue May 08, 2007 7:34 pm    Post subject: Unload data based on some keys from IMS DB
Reply with quote

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???
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue May 08, 2007 8:34 pm    Post subject:
Reply with quote

In FileAid Extract option, there is option:
Code:
 Extract based on key values


Try this
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Wed May 09, 2007 8:03 am    Post subject: Re: Unload data from IMS DB
Reply with quote

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)
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Wed May 09, 2007 8:54 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Thu May 10, 2007 12:39 am    Post subject: Re: Unload data from IMS DB
Reply with quote

Nagendran wrote:
is it possible to use GN or GU call to get data from the file.


[joke mode on]You might try and inform us whether you succeeded icon_wink.gif If you succeeded please post at this forum[/joke mode]

OS files don't support DLI calls, just IMS databases and GSAM.
Back to top
View user's profile Send private message
Nagendran

New User


Joined: 24 Jan 2007
Posts: 89
Location: USA

PostPosted: Thu May 10, 2007 8:43 pm    Post subject: Re: Unload data based on some keys from IMS DB
Reply with quote

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
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Fri May 11, 2007 12:23 am    Post subject:
Reply with quote

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.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts opening a dataset after reading it fr... arunsoods DFSORT/ICETOOL 5 Wed Oct 04, 2017 3:54 pm
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us