Hi Forum
I will prepare a demo using DataStage 7.5.2 server and UniData 6, how i configurate this conection??? in the pdf says change the uvodbc.config, but dont says thats necesary install unidata client in the DS server ,, is necesary??? or DS dont need its???
I need to know all steps to prepare this demo ... i hope you can help me !!!
Thanks ,
Configurate DS to UniData
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Configurate DS to UniData
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The UniData server does not have to be on the same machine as the DataStage server. An entry in the uvodbc.config file tells DataStage where the UniData instance is.
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.
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Ray,
I'd configure my UniData conection in the uvodbc.config with this values
<UDUni>
DBMSTYPE = UNIDATA
network = TCP/IP
username = p1002
service = udserver
host = 100.128.11.4
account = /tell/data/C3Dic/customer
When i try to import metadata using the Manager show me this message
SQLExecDirect: Failed with SQLSTATE S0002 - Native error 0, [IBM][SQL Client][UNIDATA]You have no privilege on file UD_SQLTABLES
Why appear this message ???
Thanks
I'd configure my UniData conection in the uvodbc.config with this values
<UDUni>
DBMSTYPE = UNIDATA
network = TCP/IP
username = p1002
service = udserver
host = 100.128.11.4
account = /tell/data/C3Dic/customer
When i try to import metadata using the Manager show me this message
SQLExecDirect: Failed with SQLSTATE S0002 - Native error 0, [IBM][SQL Client][UNIDATA]You have no privilege on file UD_SQLTABLES
Why appear this message ???
Thanks
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Because you lack SELECT privilege on UD_SQLTABLES, which must be read to determine whether the table name you are attempting to query exists as an SQL table in UniData.
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.