InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSun, 07 Sep 2008 05:40:13 GMT20http://www.teradata.com/teradataforum/Topic11215-5-1.aspxIf you can use unix, there's the split command up to the task ...Mon, 14 Apr 2008 22:23:31 GMTjoedsilvahttp://www.teradata.com/teradataforum/Topic11215-5-1.aspxDear 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 attributesTo 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 DataFile 2 - 40% of total DataFile 3 - 40% of total DataMany thanks in advance.Mon, 14 Apr 2008 07:47:40 GMTjdeanz