Configurate DS to UniData

jseclen · Post by **jseclen** » Fri Mar 28, 2008 12:50 pm

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 ,

ray.wurlod · Post by **ray.wurlod** » Fri Mar 28, 2008 4:38 pm

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.

jseclen · Post by **jseclen** » Wed Apr 02, 2008 5:04 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Apr 02, 2008 6:30 pm

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.