Hi,
In the server job, I am using a Sybase table (which is read only) as the source table. While running the job I am getting the following warning:
"SRC_CMC_SBSB_SUBSC: Sybase Server warning 3906 (severity 16): Attempt to BEGIN TRANSACTION in database 'fidelis_311' failed because database is READ ONLY"
My question is: If the source database is read only cant we select the required rows and populate another database(which is not read only)?
Thanx
Subra
Issue with source tables which are read only.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 22
- Joined: Fri Oct 15, 2004 11:53 pm
- Location: Bangalore, India
- Contact:
It shouldn't be an issue.
Is there a way to not have it think it's transactional work? For example, in the OCI stages you can change the Transaction Isolation property from 'Read Commited' to 'Read-Only' - is there an equivalent in whatever stage you are using?
![Confused :?](./images/smilies/icon_confused.gif)
Is there a way to not have it think it's transactional work? For example, in the OCI stages you can change the Transaction Isolation property from 'Read Commited' to 'Read-Only' - is there an equivalent in whatever stage you are using?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 22
- Joined: Fri Oct 15, 2004 11:53 pm
- Location: Bangalore, India
- Contact:
-
- Participant
- Posts: 22
- Joined: Fri Oct 15, 2004 11:53 pm
- Location: Bangalore, India
- Contact: