|
View previous topic :: View next topic
|
| Author |
Message |
tuxama
New User
Joined: 25 Jan 2007
Posts: 42
Location: france
|
|
|
|
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 |
|
 |
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
| 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 |
|
|
tuxama
New User
Joined: 25 Jan 2007
Posts: 42
Location: france
|
|
|
|
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 |
|
|
|
|
