Hi,
We have a question about the Sequential File stage. When we write to a Sequential File stage, by default the File Name in the properties of the stage is the name of the input link. We would have to explicitly change that to a physical file location and a file name on the server.
If we do run the Job without changing the default File name, for example which might be as "DSLink5", where does this data / file reside? Also if we are going to write a hugh number of records to the output file, is it not advisable to write to this kind of just a Link name? Or is it simply doesn't make any difference specifying the output file name as "DSLink5"?
Thanks.
Sequential File stage - writing to a Link name
Moderators: chulett, rschirm, roy
Of course it makes a difference and you must change the filename to a 'real' one from the default of the linkname. Otherwise, all you have is a relative filename rather than the absolute one you need and the file will end up in the job's Project directory named 'DSLink5'.
And if it's a 'huge number of records' you stand a very good chance of filling up the file system where DataStage is installed and corrupting all of your Projects.
And if it's a 'huge number of records' you stand a very good chance of filling up the file system where DataStage is installed and corrupting all of your Projects.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers