DSXchange

Hi guys,

I need to load more than one file into DB2 tables using Datastage, I tried using the Folder stage but everything was written into one line and my sql script to extract substrings in the file so as to pupulate my table field failed. Is there any other stage I can use to achieve this in a best possible way. The files are of the same format and structure. Plz plz gurus help a brother out.

Thank you in advance.

Mfanas,

You can achieve this using LINK COLLECTOR only if the metadata is same on all the files.

Regards
JK

mfanas wrote:Hi guys,

I need to load more than one file into DB2 tables using Datastage, I tried using the Folder stage but everything was written into one line and my sql script to extract substrings in the file so as to pupulate my table field failed. Is there any other stage I can use to achieve this in a best possible way. The files are of the same format and structure. Plz plz gurus help a brother out.

Thank you in advance.

Use a Transformer stage to parse the record structure. This can have separate outputs for each of the DB2 tables. There is no need whatsoever for a Link Collector stage.