DSXchange

Hi, I have a strange problem with ODBC stage. I using a job to load history data into Oracle table for individual years. After running for couple of years, when I run the job to load a new year data it stops loading. It doesn't give any errors or stops processing...the count remains 0/0 for all stag...

Thanks everyone for your suggestions.

It worked finally !!!

Sri.

I tried this path...but still no success. when i execute the dsjob cmd I got err msgs First asking for vmdsapi.dll then dsclnt32.dll and then dsrpc32.dll. The first one I got it from /dsdk/bin folder and the rest two from my local machine system32 folder. Now that the dsjob is running, I tried to ex...

I am running the dsjob cmd from the ... ascential\datastage folder. Is this what you meant by path or something related to server.

Correct me if I am wrong.

Hi, I am new to this tool and I need some help. I am trying to run the job from my local machine and I am using dsjob to do that. But i am getting a msg that the cmd is not recoginsed. I am able to compile the job from cmd prompt using dscc but to execute dsjob do I have to set any envr variables or...

Has you said I checked the oracle tbl. The datatype is just NUMBER withour any length in it.

Would it make any difference.

I did use the trimB but not change in the outcome. The final data from the DS is right but still I get this msg. Also the size and types are the same.

Thanks,
Sri

This msg is a warning in the datastage. When I check the data in the msg box, the data is built correctly, but is not written into the oracle tbl. This is the msg i get. GL_Facts..Fact_Dimension_Lkp.tgt_Fact_tbl: DSD.BCIPut call to SQLExecute returned informational message. SQLSTATE=01004, DBMS.CODE...

Hi, I am trying to load data into Oracle tbl. And I am getting this error saying "Data has been truncated". I checked the size, datatype of the fields in my transformations and Oracle tbls and they match. What else could be the problem. Did anyone come across this problem. Any suggestion w...

Hi Roy and Keith,

The solution worked like a charm. Thank you. You made the solution look so simple.

Thanks once again ....I appreciate your help.

Sri.

I have a scenario where I need to lookup a table which has 3 columns called Begin_Range,End_Range and Acct_Name. The base table has a column Account. I need to lookup the Xref table and based on the range it belongs,extract the corresponding Acct_Name. The lookup has no primary key. Can anyone sugge...

Thanks Roy... I sure will check with my DBA.

Hi, I am designing an ODBC stage where in I need to update existing rec's and insert new records. I want to clarify one of the options given in the Update Action Drop-Menu. In that there is a option saying Update existing records and insert new records. My question is when inserting a new record wil...

Hi ,

I need to generate sysdate in datastage which I will be using later to do comparision with dates in my table.

Any suggestions as to how to generate sysdate in DS.

Thanks,
Sri.

Thanks Ray & Ketfos

The suggestions worked like a charm. Now I need to figure out how to generate sysdate in datastage. Any suggestions for this.

Srikanth.