Hi, I am using DB2 Connector stage to update and insert records. I am getting The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. But same id is working fine when I use API stage, I am able to update and insert records using API stage.
Please suggest
DB2 Connector issue
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Check, double check and triple check the authorization in your Connector, or in the Data Connection object that it uses (and possible in the Parameter Set associated with that).
Test by manually overriding the user name and password with the correct values.
Test by manually overriding the user name and password with the correct values.
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.
Perhaps the connector stage requires some additional system privileges, such SELECT on certain DB2 system tables/views to collect metadata.
Choose a job you love, and you will never have to work a day in your life. - Confucius