DSXchange

Here is the way that we fixed this. 1.Create a shell script that would generate a file that would containing ODBC entries - We parameterised databasenames,servernames to script. 2. Only in the parallel job where it connects to database - add a existing environmental variable which contains the defau...

Hi All , I got some funny requirement to connect to more than 300 SQL Server Databases and run a simple query on each database. I have created a Job which would connect to all of these , All the DSN/connection entries were added to .odbc.ini file and I am parameterizing the connection name to run th...

Thank you very much guys

I am new to Datastage and unable to write a routine in simple steps. None of the links are giving a valid response on google. I am not sure in which language/script the DS routines are written atleast to refer sample routines. Someone gave a link to regularly used routines and the link is already ex...

I cannot use a Reject link for a source connector . It throws a compile time error.

IBM documentations says that its known issue that it allows to create a reject link in designer but cannot compile the same.

Hi, I am looking for a better approach to solve this. my job needs to test connectivity of databases . We have designed a job which would connect to a single database and runs a small query. When our the parallel jobs completes we are writing the status a success to a report file and if the job Para...