Reading and Writing in same table

mallikharjuna · Post by **mallikharjuna** » Thu Jul 21, 2016 11:32 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Jul 21, 2016 4:04 pm

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.

SURA · Post by **SURA** » Thu Jul 21, 2016 5:52 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Jul 21, 2016 6:59 pm

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

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

SURA · Post by **SURA** » Thu Jul 21, 2016 7:08 pm

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