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
 

 

IMS DLI - About unload segment

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

New User


Joined: 25 Jan 2007
Posts: 32
Location: france

PostPosted: Tue Oct 23, 2007 2:49 am    Post subject: IMS DLI - About unload segment
Reply with quote

I am not a DBA, just a programmer.

My database structure (DLI)

Code:

ROOT
 !
SEGMENT B
 !
SEGMENT C
 !
SEGMENT D


Also I have in a sequential file (my input) a list of some root key (one per line).

What I need
Unload all C SEGMENTS in sequential file that the root parent as key belongs in the list of the input file.

The purpose of this is
Modify (ICETOOL) one value in all the C SEGMENTS unloaded and reload those in database.

Is it possible without writing a program ?
Yes. How ?

Thanks for help?

Right my english is poor... sorry.
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Oct 23, 2007 10:30 am    Post subject:
Reply with quote

Quote:
Modify (ICETOOL) one value in all the C SEGMENTS unloaded and reload those in database.


If you just want to change record type SEGMENT C, then in SORT there are options like IFTHEN or WHEN thru which you can just go and change only SEGMENT C records.
Back to top
View user's profile Send private message
tuxama

New User


Joined: 25 Jan 2007
Posts: 32
Location: france

PostPosted: Wed Oct 24, 2007 1:28 am    Post subject: Reply to: IMS DLI - About unload segment
Reply with quote

My question was not very clear !!

I find an answer in the IMSTOOL documentation.

1) To unload I used an IPR

2) To modify the value I needed in all the SEGMENTS C, I wrote an USER EXIT that is called by the IPR utility for each segment. I just needed to set in the OUTPUT card of the HPSIN :
- the option "dbrskip" to "Yes", in order to allows the database record skip option
- the option "ext" to "Yes", in order to indicates that segments are modified by the user exit.
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 Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts DB2 Unload format options Susanta DB2 2 Fri Aug 12, 2016 5:42 pm
No new posts DXT unload utility - DVRE0000 mistah kurtz DB2 1 Thu Jul 07, 2016 4:56 pm
No new posts How to suppress retun code of partil ... mkk157 DB2 9 Fri May 27, 2016 6:59 am
No new posts FAST UNLOAD and LOAD issue GaganGarg DB2 1 Mon Feb 15, 2016 2:30 pm


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