DSXchange

Hi All,

I have to read and write data in same table with timeId change we have to append same records in table. could you please let me know it is possible in same job without having locks and other issues. i am using sql server database.

Thanks
Mallikharjuna Reddy

Almost certainly NO.

This is what is called a "blocking operation", and would thwart pipeline parallelism, so it is banned in parallel jobs.

It may be possible, provided that the writing stage uses auto-commit, and the reading stage is far enough downstream for the commits to have taken effect. But I don't really recommend this approach.

Server jobs can use blocking operations.

Job1 - Read and write it in a file.
Job2 - Insert / Update

SURA wrote:Job1 - Read and write it in a file.
Job2 - Insert / Update

Which part of "in same job" wasn't clear?

Same thought as like you guys have, but rather than saying that, given an option to use it