DSXchange

Definitely, I need to read and write to the same table, but in two seperated oracle stage ? How come it is going to cause trouble ? Why can you make sure it is because you are reading and writing to the same table that cause trouble. Our process is to read from a table, compared with an input datase...

I get a few jobs constantly hang up after we clicked the run button, only in some scenario it works through. However, if we set $APT_DISABLE_COMBINATION to TRUE, all these jobs are fine. Anybody encountered this situation as well, why $APT_DISABLE_COMBINATION value to FALSE will cause this kinds of ...

I set a timestamp type column in DS, and let DS create table in oracle.

Finally, DS create a date type column in oracle insead of timestamp , Anybody can help me in this problems.

Many Thanks

Did you set the environment variable APT_ORACLE_LOAD_DELIMITED in your job? Also are there any double quotes in the input data? What error did you get in the sqlldr log? Can you post the sqlldr log file? Sounds like there might be a bug when DataStage creates the load file and doesn't inherit the e...

Sounds like there might be a bug when DataStage creates the load file and doesn't inherit the explicit column definitions into this file. You should take it up with your support provider. ... thanks for your output. I still couldn't make it work. I use upsert method at this moment. And I raised my ...

JoshGeorge wrote:Is there a chance that there is something wrong with your job design? I just ran the above example and it gives me the right answer.

Hi Josh,

I guess that is possible because of the input link sequences, Can you just swap your input link to see what will happen?

We didn't Enable RCP.

How come DS will automatically truncate the column length to the smaller one ? it will generate heaps of wrong results ...

I just can't believe it....

I found a very weired things in Join stage, I couldn't understand why DS works like that . Sequencial file stage 1 Varchar(3) 001 002 003 Sequencial file stage 2 varchar(5), varchar(5) 0010, apple 001, pear Inner join 1 and 2 will get 001, apple 001, pear However, if I increase sequencial file1 from...

No, it doesn't have.

RCP was disabled in our project ?

Does it cause problems ?

Why there is no length specified in DS generated control file ? and How can I make DS generated a length specified column ??

Thanks

oracle datatype varchar2(1000)

In datastage, I try varchar(1000), and longVarchar(1000), all failed

Yes, I tried varchar and longVarchar in datastage.

I got a problem when I try to load data file to oracle by datastage. If the column length is more than 300, I always get an oracle errors say column lengh exceed maxium length. And if I change the loading method to upsert, it is OK, I can even insert 4000 length column into oracle. But when I change...

Thanks, I guess so.

But I just couldn't find it.