|
View previous topic :: View next topic
|
| Author |
Message |
sajjan jindal
Warnings : 1
New User
Joined: 09 Sep 2007
Posts: 60
Location: india
|
|
|
|
Hi,
I have a requirement such that the four programs could be accessing the table at the same time.
Is there any facility such that when one program accesses the table the other program will wait. (like suspend)
I was told that the program will fail with an error code of -904.
Regards,
Sajjan Jindal. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
I was told that the program will fail with an error code of -904. |
You were told wrong.
| Quote: |
| I have a requirement such that the four programs could be accessing the table at the same time. |
It is quite normal to have multiple online and batch programs accessing a common table at the same time. In fact, this is one of the biggest features of having a database. . .
| Quote: |
| Is there any facility such that when one program accesses the table the other program will wait |
If you are talking about batch jobs, schedule the jobs to not run concurrently. Your scheduling people will know how to do this. |
|
| Back to top |
|
|
|
|
