Given a sequence name, I need to query all the job names inside that sequence and its subsequences.
I know this has been asked before, I did my homework by searching and reading the related posts. There are two possible approaches, right?
1.- To use a transform routine issuing a SELECT from the tables DS_JOBOBJECTS and DS_JOBS or,
2.- To use an UV Stage to execute a similar query.
I am trying the second approach. In order to access the tables in the UV Stage, I first defined the ODBC connection in the uvodbc.config file:
Code: Select all
<DBUnidat>
DBMSTYPE = UNIDATA
network = TCP/IP
service = uvserver
host = 192.168.50.107
After filling the fields of the Import Meta Data dialog, I always get the message: "Failed to connect to database".
I am trying with different users and account values, but apparently the error has nothing to do with those fields.
Any idea of what I am doing wrong? Thanks in advance.
Yonny.