DSXchange

I am at a site that has multiple Universe 10.0 databases on HP/UX boxes. I have just installed DataStage 7.0 on a Windows box which is on the network.

The Unix boxes have UVNET installed and can set up remote account pointers between them.

I can not seem to do the same from the Windows box via telnet into local host and setting up a UV.ACCOUNT pointing to the Unix Servers.

I would like to be able to access these databases from DataStage and import metadata via Universe Files, not Tables.

Can this be accomplished?

DataStage is NOT UniVerse - hasn't been since version 5.2. Therefore, if you want to use UV/Net, you will need to install UniVerse and UV/Net on the DataStage server machine.

But this isn't actually necessary. DataStage can use the UCI to access a remote UniVerse database. You need to set up a data source definition that specifies the remote host of the UniVerse database in uvodbc.config (and use the UV stage).

I spoke with IBM yesterday and found out the following.

Although you can setup an ODBC DSN and connect to the Universe box via Universe Tables, you can also set up a UV.ACCOUNT to point to a remote Universe Database without setting up ODBC. Once this is done, you can see the data files in the Manager using the Import / Universe Files.

In either instance, ODBC or UV.ACCOUNT, a connection port number will need to follow the remote server name/IP address. Ie. 123.222.333.10:31438

31438 is the default port number

Uvnet will need to be installed on the remote box.

You can also set up remote file pointers in a VOC. UniVerse-to-UniVerse these have the form hostname!pathname in field 2 (and field 3), which triggers the UV/Net software.
Presumably, therefore, you can include the port number in this construct too, for example hostname:port!pathname.