Writing to a file from a routine
Posted: 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!!
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!!