Files made out of table records

[kashif007]

Is there a way if we can produce a file for each record that is present in a table using Ascential. For example if I have 10000 unique records in a table can I have each unique record in a different .txt file as output. Please tell me if it can be done in Ascential. I need to convert a table which has 10000 unique records into 10000 different .txt files, each file containing one unique record. Please suggest.

Thanks

[DSguru2B]

It will be really messy with a datastage job.
A much easier way is to create a single text file and then run a simple shell script on the file that creates equivalent number of files as unique records.

[asorrell]

Another alternative is to create a DataStage Server job that consists of nothing but "Job Control". However you have to create the job control yourself manually (not through the gui).

The Job Control uses a customized version of the BASIC language. Using BASIC you could fairly quickly open a single input file and then use a loop to output each line to a separate output file. It would only take about a dozen lines of code.

If you need documentation on the Basic language you can use this link to get an online copy of the manual:

http://publibfi.boulder.ibm.com/epubs/pdf/25126200.pdf

The version used by DataStage is slightly older than that, but the manual should be fairly accurate.

Note: Some would consider this solution "messy" (as DSguru2B put it) because many developers don't know how to write or support the BASIC code, making it hard to maintain over time.

[ray.wurlod]

Can you do this with the XML Output stage?

You don't need the linked manual; the DataStage BASIC manual which you have with your client has everything you need.