DSXchange

yes , I am not able to connect to the database

I have been told that the installation has been done on the server.

I have told that the installation has been done on the server , on my machine what exactly am I suppposed to do. I am not able to see the driver on my machine.

how to install a odbc driver on my machine

I have a odbc table and a sql that is going to insert records into that table .The sql is referrring to many other tables to populate this table and I need to check if some of them are null and replace with a different value. then should I have all those tables as input to my transformer.

I have got an odbc table as input and I am doing an insert on this table through a sql and this sql is joining many tables then is it required to refer to those table columns somewhere in the input or just the sql will take care of it. basically say input is table emp and I am inserting values to th...

if the script i am executing is 1.sh then after the dsexecute statment I have to give dsloginfo(systemOutput,1.sh) .then I have to give the next dsexecute to run the next script . if some scripts are not dependent on each other then can I create separate server job and do the same thing so that they...

when I am running in unix the will the command be

dsexecute("uv",cmd,output,0) what should i give for output, and if I have to code so many dsexecutes can I do it in 1 server job.

does it mean that the job will not have any stages .

if i use dsexecute to execute a shell script name 1.sh how do i give the parameters. can you help with the actual command.

none of the replies have helped me so far

basically what they plan is to cut and paste the same script with may be some minor changes and execute within datastage

they want everthing to be controlled through datatage

A series of scripts (ddl/dml) need to be run through the job sequencer.
the 1st script will be run with 5 different input values and then the 2nd script with the different set of input values and so on. What will be the best design for this.