DSXchange

What i need is a way to control my jobs in some sort of loop such that a new file is passed on every loop my job is hitting the db and taking a file and processing it .what i need is to loop this thing in a sequence so that ..like if there are 10 files in the db ...the job can run 10 times and proce...

First link is sequential file>>>second link is transformer where column is mapped>>>Third link is Db2udb tried Db2api too....

Another job i tired is
Sequential file >>>Db2

third job i tired is
db2>>Sequential file

all are showing pin not initialized error for db2

Actually the problem is that we are able to run the same job in our production environment(windows server)we are not able to run any job involving db2 connection the problem is with db2 connection please guide us how to solve this connection issue with db2.We tried to make a new job and re import it...

Nop instead of IDENT1 we are getting "TRANSFORMER STAGE1:Pin 2 not initialized"

we are able to run the same job on windows server but unable to do so on aix server

Yes we tried but no luck...still getting "pin 2 not initialized error"

chulett wrote:Question - does this imply that you do not get the error if you run the job from the Director?

No we are unable to open the director so we can't see what's hapenning over there

while trying to open director i am getting error"request time out:810015"

Problem description 1) We are having a sample job which will read from sequential file and insert a row to database(using DB2 connector stage). This database is a remote database. When we are running the job using dsjob command it is failing with error "PIN2 not initialized". PIN2 is DB2C...

how to deplop a package on aix using istools

What is the execute command i should write in execute command stage in sequence looping for reading a sequential file and if i find it empty it returns false.please reply as soon as possible

i made a job wher i want the loop to terminate after x times .here x is dynamic which is number of data elements coming.i wrote a query and got the count but how to insert it as parameter for loop end activity as it will keep changing

can i schedule a datastage job on server itself