DSXchange

FYI , if it helps, I have also set the APT_ORACLE_PRESERVE_BLANKS to true for this job.

Hi, The CurrentDate() is in column in the transformer and the format as seen in the peek (reject) is 2007-03-08, the date column table has been defined as date but when I import the metadata using Orchestrate or ODBC it comes in as timestamp, I did try to use CurrentTimestamp() in the transformer bu...

For testing purpose, Iam inserting CurrentDate() and all the rows are bieng rejected with 1403 SQL code, I am using Insert then Update, also did try Update then insert. Its wierd, that all the rows re being rejected without being inserted or updated.

Thanks it works

Hi, I have a source col and I need to drop the last character off it , here is what I tried to do Stage Variable: Len1=Len(Src.Col1) Output=Src.col1[1,Len1] Apparently I cannot use the Stage variable , is there any other way I can do it. Src=abcdef Required Tgt=abcde The source length is varying and...

The error I get int he first case is SQL CODE 1403, I am investigating into it, I an loading a blank oralce table with Insert then Update.

In the second case when you mean default value what would it be, 9999-99-99 or can we insert null vlaue ' ' ?

thanks,

Hi, One of the jobs reads from SQL server and writes to Oracle table, the date column in the target oracle is Nullable and in the transformer I set it to SetNull() , it rejects all the rows ( there are no rows to view in the reject file though!) . So how do we insert null vlaues into a oralce date c...

Hi,

Can we parameterize the job name in the Job Activity stage? Is there a work around for it. I have some logic a seq performs, which is needed for multiple jobs, I looking a way to avoid designing a seq around all jobs instead.

Thanks,

Will try to delete it from this forum, I thought I was posting it in EE forum!

moving to right forum

Thank you guys, will stage the data before I load.

Hi, I need to desing a job which reads from Oracle source table and loads the same Oracle table with some transformations done on some columns, can we do that or will be locked or go into a cycle mode. For example: Source: Table A Col1 , col2, code st1, 10, a st2, 20, a st3, 40, a Target: Table A (A...

Control-M calls the DataStage job, so I am not sure what you mean by the basic control job, can you elaborate?

Thanks,

Hi We run our jobs from Control-M and sometimes the DS job when kicked off aborts due to resource issues, so what I am planning to do is , re-run the DS job 3 times before we get a page, is this possible through a script or other means. In control-M, we can set up a job to rerun for a certain number...

I am sorry, I was wrong in calulating the first time, it does not count the instances for the following command

SH -c "dsjob -ljobs proj1 | wc -l"

thanks !