473,382 Members | 1,078 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

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 4052

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Raquel | last post by:
Hello!! Am receiving the following error on Platinum (CA) FASTLOAD: PTGL407- DATA OBJECT IN RESTART MODE-RESTART PARAMETER REQUIRED PFL0011E-DATA OBJECT IN RESTART MODE-UTILITY MISMATCH
1
by: DB2 Novice | last post by:
Hi, What are the utils provided by IBM to fast load and unload DB2 in Unix and Windows env. I read about High Performance Unload and this is just Unload, waht about Load? What is the best way...
1
by: hal | last post by:
I have an application that includes an activex component that consumes resources that must be released when the a page is unloaded. Toward this end I subscribe to the unload event of the body...
1
by: Hal | last post by:
My most sincere gratitude to anyone who can help me work around this! I have work that needs to be done in javascript on the client whenever a page is unloaded. To this end, I subscribe to...
3
by: Gauthier Segay | last post by:
Hello, I've an application where all my pages implement a PAGE_CODE string property, this property is stored in HttpContext.Current.Items. In some page, I must persist data in session while...
18
by: B D Jensen | last post by:
Hello! I have an big table with 50Gb data, written som functions that cleanup data and want to do something like this insert into newtable select id, func1(col1), func2(col2) from oldtable; ...
2
by: The Doctor | last post by:
Does anyone know the RGB colour code for platinum? -- Member - Liberal International This is doctor@nl2k.ab.ca Ici doctor@nl2k.ab.ca God, Queen and country! Beware Anti-Christ rising! Voting...
0
by: lokey03081 | last post by:
crack copy dvdxcopy platinum 3.2.1.0 http://cracks.00bp.com F R E E
0
by: fogleman44523 | last post by:
dvd fab platinum crack http://cracks.12w.net F R E E
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.