We dont have update access to the database with the username we provide in the mappings to connect to the target database.
Please let me know why we need an update access to the target database in normal scinario?
Update access to the target database
Moderators: chulett, rschirm, roy
Update access to the target database
Thanks,
Sonia
Sonia
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
Re: Update access to the target database
If you need to update any row on any table you need an update access on that table. From DataStage perspective if you are using any of the following loading strategies you need update access:sonia wrote:We dont have update access to the database with the username we provide in the mappings to connect to the target database.
Please let me know why we need an update access to the target database in normal scinario?
1) Update existing rows or insert new rows
2) Insert new rows or update existing rows
3) Update existing rows only
4) User defined SQl - If you doing updates using user defined sql
Regards,
-Sumit
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As far as the database is concerned, DataStage is just another client application.
The same rules apply for all connected clients. If you would need UPDATE privilege to perform some task as an interactive user, then you will need it to perform the same tasks as a DataStage user.
The same rules apply for all connected clients. If you would need UPDATE privilege to perform some task as an interactive user, then you will need it to perform the same tasks as a DataStage user.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Update access to the target database
Hi,
If you would need UPDATE privilege to perform insert,update and delete in the database as an interactive user, then you will need it to perform the same tasks as a DataStage user.
Thanks
Cnu[/url][/b]
If you would need UPDATE privilege to perform insert,update and delete in the database as an interactive user, then you will need it to perform the same tasks as a DataStage user.
Thanks
Cnu[/url][/b]