Sequential File stage - writing to a Link name

[vnspn]

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.

[chulett]

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.

[vnspn]

Thanks for the information Craig...