How to Split Output file using SQL?
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


How to Split Output file using SQL? Expand / Collapse
Author
Message
Posted 4/14/2008 7:47:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 4/14/2008 7:44:41 AM
Posts: 1, Visits: 11
Dear Experts,

Is there any function to split the output file into difference files, irregarless the file format?
i.e: By Row, by file size, by sampling, by attributes

To split every 1000th row of total 10,200 row.
The output:
11 Files (1000 row for each files + 1 file with remaining 200 row)


To split by sampling of 20%,40% and 40%
The output:
File 1 - 20% of total Data
File 2 - 40% of total Data
File 3 - 40% of total Data

Many thanks in advance.
Post #11215
Posted 4/14/2008 10:23:31 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 7/7/2008 1:09:24 AM
Posts: 425, Visits: 396
If you can use unix, there's the split command up to the task ...
Post #11221
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 7:17pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 10 queries. Compression Disabled.