Page 1 of 1
File Update & Delete in between job
Posted: Fri Jan 25, 2013 10:55 pm
by karthi_gana
All,
What will happen if the file (which is currently in use by datastage) got updated or deleted ?
Posted: Sat Jan 26, 2013 12:19 am
by ray.wurlod
What do you mean by "in use"? Most operating systems don't allow a file opened for writing (for example by DataStage) to be written to by any other process. Most operating systems implement NR1W (any number of readers OR one writer) locking on files. On that basis, if DataStage has the file open, no other application can change it.
Posted: Sat Jan 26, 2013 12:20 am
by chulett
Why not try it and see? Create a small test case, put it through the wringer and let us know.