Hi,
I have a Table which contains 1 million rows. I want to do an unload of
the table and do some massaging (tranforming) of data and do a load to
a different table where the column attributes are different.
My question is
1) What options should I use to do a unload so that the unload is very
fast using Platinum Fast unload. The table has many columns which
defined as VARCHAR.
2)Is there a provision to convert the column values from the source
table which has varchar to a decimal value defined in the Target
table?.
I thought I will do an unload and massage the data and load it to the
Target table.
Here is the options I have given
FASTUNLOAD
INPUT-FORMAT TABLE
OUTPUT-FORMAT D
DISPLAY-STATUS 500000
SORTSIZE 4M
ALLMSGS
VSAM-BUFFERS 360
SHRLEVEL I
UNLDDN SYSREC
CTLDDN SYSCTL
LOAD-CONTROL FASTLOAD
SQL-ACCESS EXTENSION
Let me know your thoughts.
Thanks
Rajeev