Page 1 of 1

Writing to a file from a routine

Posted: Mon Sep 19, 2005 1:09 pm
by Emilio
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!! :?

Posted: Mon Sep 19, 2005 4:02 pm
by kcbland
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.