DSXchange

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 ,

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.

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

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.