DSXchange

Hi all...:) I am facing a strange issue. I have one server job. It has got 4 parameters. TAR_DSN,TAR_PWD,TAR_USER,WORKDIR. The issue is, even if i give wrong parameters(any of the 4 or all the 4) and validate it it will say Validated OK. Initially the password was encrypted. I changed it to string f...

Hi all, I am getting a lot of triggered mails from one of the projects. It has got my mail id in the administrator. From the logs( from director) i can see the jobs were run last on 16th of this month. But all the mails i got were of date11/20/2008. The jobs has got aborted as per the mail. i am qui...

can anyone tell me what is the command to execute a perscript using job control ?

can u make it a little more clear??
is it job control wat u are mentioning?

i need this project to be run after a batch job.
But for a batch job there is no ExecSh option...

Hi, I have one perl script ( PerlProjectb) as after job subroutine of my project- ProA. After completion of ProA, this shud run ProB which is another project. But while runnig the script in unix i got an error like this.... Invalid arguments: dsjob -run [-mode <NORMAL | RESET | VALIDATE>] [-param <n...

can anyone tell me the significance of "create hash file" option for ahsh files?
thanks in advance...

Thanks a lot Ray and Chulett...

the issue is resolved. Primary key value, i loaded in the parent table and also i used generated sql.

Now its working fine...

One more thing...when i give insert and update as generated sql(INSERT ROWS WITHOUT CLEARING for insert and UPDATE EXISTING ROWS ONLY for updating) i am getting a new error: ORA-02291: integrity constraint (DLEUSER.FK_NICBCUSTDETL_DLCUST) violated - parent key not found Is this becuase one of the ke...

i am trying to insert(update also) data from a hash file to Oracle table. hashed-->>Transformer-->>Oracle stage. this is the inseret query INSERT INTO CUSTOMER_DETAIL (INS_CO_DL_CUST_ID,LOC_DL_CUST_ID,COLL_FLG,USER_ID,APPL_ID,LOCK_ID,REC_DT) VALUES (:1,:2,:3,:4,:5,:6,:TO_DATE(:7, 'YYYY-MM-DD HH24:MI...

can a nullable field in a table be specified as the primary key in a hashed file. i am extracting data from oracle stage and storing it in hashed file. the filed appl_id is a nullable field in oracle stage...and i am using this field as key in hash file...is this correct? also the exact value in thi...

I am merging two files using merge. there is one common primary key. the output of merge is given to a sequential file.till then no probs. after that, the output of seq file is given to a transformer and a hash file is used as look up. the joined data is written into the seq file, but lines are show...

Hii there,

What is datastage PX?

can neone please explain?

Hii there,

Can anyone explain what exactly happens wen we validate a job using director?

Thanks in advance...

i dont know what an escape character actually is.
By default it was \ in the merge state, so i didn't change it.
please explain what it exactly means.