MVSFORUMS.com

Rohit Sharma · Beginner Joined: 30 Jan 2004 Posts: 5 Topics: 3

Hi,

My requirement is as follows
I have an IMS database with EMP as parent Segment and PAY as the only child segment. I need to change the value of a packed field in PAY segment to a constant value (say packed value of 5) for those EMP segments for which the field AGE in the Parent segment EMP is more than '50'.

Please let me know how can we achieve this through Datavantage and if possible through INSYNC. I need to have this as a batch job.

Thanks in advance,
Rohit.

kolusu · Posted: Fri Jan 30, 2004 6:45 am Post subject:

Rohitsharma,

You can code a simple cobol pgm with GHU (get hold unique) call and then use REPL (replace) call to change the contents of the pay segment. I also think it can be done with file-aid provided your shop has file-aid IMS.

Hope this helps....

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Rohit Sharma · Beginner Joined: 30 Jan 2004 Posts: 5 Topics: 3

Thanks for the reply, Kolusu. But I need to frequently change different fields of database. This is required for testing some specific conditions. I wanted to avoid writing a Cobol program and achieve it through JCL itself. I don't have File-aid but have INSYNC at my shop.

Please let me know how can this be achieved by Datavantage and INSYNC, if at all it can be done.

Thanks,
Rohit.