DSXchange

Hello Guys
Is it possible in datastage wherein i have a one physical file ( say dataset) which is used as lookup file in a job and in the same job we are doing some write operation in same dataset. Will there be any data quality issues in this front ?

TIA
akash

Since datasets are not true database files but a structure with sequential files you cannot really do this; if the files are opened for "read" by one process then another cannot get "write" access concurrently.

Correct.

You could just save it as a separate dataset file.

Also please note: Dataset does not compromise only one file. It's one header file, and a set of data files, with locations usually defined in the configuration file (it's possible to use other configurations for specific datasets.)