Hi experts,
I have 10 textfiles.Each File has a Column_Total in its Trailer.Different columns are used to calculate for Column_Total in every file.How can we check the Column_Total in Datastage by a common job for all text files.
can anyone suggest regarding this?
Thanks in Advance,
sri
Trailer
Moderators: chulett, rschirm, roy
This would only work if all your text files are of the same format; unless you want to store the schema of all the files and use that parameterized.
One simple method would be to use a transform stage variable to keep a running total, then when you read the trailer record (which you would need to somehow detect in the transform stage) you compare that value to the stage variable and if they are different you would take an error output link from that stage.
One simple method would be to use a transform stage variable to keep a running total, then when you read the trailer record (which you would need to somehow detect in the transform stage) you compare that value to the stage variable and if they are different you would take an error output link from that stage.
</a>