splitting files

[kavuri]

Hi,
here I am having millions of records in DB2. I need to transform them and pass into text files. I want to split the flat files such that each contains 50,000 records. Is there any way to do. If so how can we name the files?

Thanks in advance.

Kavuri

[iDomz]

you can use unix split command.

split -l 10000 -a 3 filename 'splitfile.'

will split filename into multiple files of 10000 lines each, each named
splitfile.aaa, splitfile.aab etc..

There could be a ds way of doing this, but I am not upto it yet.

Cheers,
D

[bcarlson]

The file stages can export to a fileset. A big benefit is that the files are created concurrently so exporting 1 million records into 10 files should be a fraction of the time of exporting 1 million records into 1 file.

Check the online documentation for how to do this with the file stages. I think both the sequential file stage and complex file stages can do this. But check the docs to be sure.

Brad.