By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,026 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

Regd: Platinum Fast Unload

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.