MVSFORUMS.com

SRI123 · Beginner Joined: 01 Jun 2012 Posts: 18 Topics: 7

Hi
Employee table contains - EMP-NO Integer, DOJ DATE, DATE-REL DATE, SAL DECIMAL(9,2)

I want to unload the data from the above table and reformat the data and load the data to another table.

Want to reformat the data such that new field EXP INT has to be calculated ( difference of DOJ and current date. And new field BONUS DECIMAL(9,2) has to be added based on years of EXP field. IF EXP < 2 THEN 100000 otherwise 200000
Reformatted data is like this: EMPNO, DOJ, SAL,BONUS
Load reformatted data into another table with fields:
EMPNO INTEGER, DOJ DATE, SAL DECIMAL(9,2),BONUS DECIMAL(9,2)

Question is what is the unload jcl and load jcl used so that data can be modified and loaded back ?

Thanks

Nic Clouston · Posted: Fri Aug 28, 2015 5:50 am Post subject:

Why unload? Why not INSERT into new table values (SELECT from old table)?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

SRI123 · Beginner Joined: 01 Jun 2012 Posts: 18 Topics: 7

Since data needs to be reformatted;

CZerfas · Intermediate Joined: 31 Jan 2003 Posts: 211 Topics: 8

If there are too many rows to be inserted, you could "unload" your source table with a SELECT making all the needed reformats running under DSNTIAUL and, with a propper load statement, load the stuff into the target table

regards
Christian

Nic Clouston · Posted: Fri Aug 28, 2015 6:38 am Post subject:

Do the reformatting in the SELECT eg (not real code but shows you the concept)

SRI123 · Beginner Joined: 01 Jun 2012 Posts: 18 Topics: 7

Ok thats good idea.thanks

Instead of reformatting while unloading, want to do it while loading.

So how to keep the condition in load statement. And do I need to change the data format from FILE S9(9) COMP to Integer of table field ? If yes, how to change?

Nic Clouston · Posted: Fri Aug 28, 2015 9:11 am Post subject:

Why are you insisting on doing an unload? You can insert into table b the row that you have just selected from table a along with the derived columns. All one statement. One oass of the data. Have you started trying things out with SPUFI?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

shekar123 · Posted: Fri Aug 28, 2015 9:33 am Post subject:

Please post your columns of the new table to which you want the load of the data to happen.
_________________
Shekar
Grow Technically

kolusu