DSXchange

Forget JobMonApp on this thread - it's irrelevant. Open a new thread for that or, better, Search for it.

Now check your uvodbc.config file for an entry for the DSN.

THE file has got the following entries

<NZSQL>
DBMSTYPE = ODBC
network = TCP/IP
service = uvserver
host = 8.1.50.40

<NZSQL_PASD_TST>
DBMSTYPE = ODBC
network = TCP/IP
service = uvserver
host = 8.1.50.40

the pull down menu shows the first one NZSQl but not the second one.

Which pull-down menu?

The pull-down menu in an ODBC stage only shows data sources from which you have imported at least one table definition. It is driven by the Repository table in which table definitions are stored.

Check it while importing odbc table definitions. Can you see it in the pull down menu there ?

the data source name pull down menu shows only the first one that is nzsql but does not show me the other me at all.

kishoreramachandran wrote:THE file has got the following entries

THE file where? There's one in your $DSHOME directory and one in each Project, which one is this?

this is in /usr/local/Ascential/DataStage/DSEngine/uvodbc.config

Have a peek at the one in your specific Project you are trying to Import from. Bet it only mentions the one you see in your 'pull down menu'.

what actually you want me to check

what will the name of the file in the home directory

Not the home directory, the project directory.

In the project directory the file you need to check is called uvodbc.config.

There is one in each project directory as well as the one in the DSEngine directory; the latter is a "catch all" in case there isn't one in the project directory.

This file:

/usr/local/Ascential/DataStage/Projects/<yourprojectname>/uvodbc.config