469,288 Members | 2,353 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,288 developers. It's quick & easy.

Regd: Platinum Fast Unload

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

Nov 12 '05 #1
0 3893

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Raquel | last post: by
1 post views Thread by DB2 Novice | last post: by
1 post views Thread by hal | last post: by
1 post views Thread by Hal | last post: by
3 posts views Thread by Gauthier Segay | last post: by
2 posts views Thread by The Doctor | last post: by
reply views Thread by lokey03081 | last post: by
reply views Thread by fogleman44523 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.