Writing to a file from a routine

Emilio · Post by **Emilio** » Mon Sep 19, 2005 1:09 pm

Hello!
I am fa

irly new to Ascential DataStage and I have some questions to some of you that are more experienced:

From a routine I need to write into a file.
For example if a code "60Delnq" in a field named "DELINQ60" has not match in Hashfile1, and "code "ALT" in a field "FORCL" has no match in Hashfile2, and so on. I need to write the header name and the code separated by commas into a sequential file like this:
DELINQ60, FORCL, ETC
60Delnq, ALT, ETC

By looking into some examples in the Ascential book, I think I can write the first code, but how do I add the second code separated by a comma or the next row.

Thank You!!

kcbland · Post by **kcbland** » Mon Sep 19, 2005 4:02 pm

Use the graphical metaphor and create a link out of a transformer stage. Use your functions or whatever to constrain the output.

Your initial idea is not a good choice, avoid independent file i/o from functions in a transformer stage. Let the tool do the work it was designed to do. You'll be happier with the result in the long run.