DSXchange

Doesn't really matter what user you log in with, the jobs run under whatever user ('engine credentials') has been setup for running jobs. Guessing that's your issue here. Yes. When checking the environment variables of the job, it has USER=dsadm1 HOME=/home/dsadm1 ISUSER=AA That's why I export HOME...

I have a ksh as below to run rexec command. When I run the ksh in command line, it can finish successfully. But when I login to Datastage with the same user AA and invoke it from execute command stage, it gives an error: Password: 3004-303 There have been too many unsuccessful login attempts; please...

I got a weird issue on Job Status code in a sequence job. In sequence report, job BC is run as "validate only". So if validating ok, it should return job status = 11, but it actually returns job status = 0(as I remember 0 means job running, but why here it shows as No error). So if I use B...

I have a sequence job that invokes a korn shell. The sequence is like: job to create a flat file---->invoke a korn shell that use the flat file as input In the korn shell it reads from the flat file which has a list of items and then does some db2 database operation for each item in that file. There...

There is before/after sql and main sql in db2 api stage. When will ds do commit?
is it:
run before sql--->commit--->run main sql--->commit--->run after sql--->commit

or it treats before/main/after sql as one transaction and do just one commit at last?

The database is db2. I tried odbc and it works, but still don't know why db2 api gave that error, as the number of parameters(where ? shows) is the same as the number of columns...

Thanks guys. I will mark it as workaround.

My job design is like: several db2 api to select------> funnel--------->db2 api In the target db2 api, I use below user defined sql. The ? stands for the only one field that output by funnel. I got an error: This SQL statement did not contain the same number of parameters as columns on this link. My...

Hi guys, I use DB2 API stage as target stage and choose "clear the table then insert rows". What does DS do on this action? Does it execute below 2 sqls separately? Delete from XXX table; Insert into XXX table; Will DS keep the table lock between these 2 sqls? or it will release the lock a...

Hi all My MainSequence job is like: StartLoop------->Invoke JobSequence1------>Invoke JobSequence2---->EndLoop JobSequence2 is multi-instance, and each time the same instance is invoked within the loop. I choose "Reset if required then run" when invoking JobSequence2. And the trigger is se...

Thanks Ernie.

The MQ connector could act in request/reply mode, to get the corresponding response msg. I found out it's a bug of DS 8.1. After the Fix Pack 1 is installed, this problem is solved.

Hi all There's a weird problem of External Source Stage. Pls help.. My job is like: External Source---->XML Input----->Transformer--->Sequential File | |rej link to Peek Stage | Peek In External Source: Source Method=Specific Program Source Program = ls "#FileName#" Most of the time this j...

Hi all, I'm using MQ Connector to send msg to the request queue and meanwhile waiting for reply msg from the response queue. The job design is like this: sequential file --->MQ Connector ------> sequential file I could send and get reply msg successfully if there's no other message on the response q...