DSXchange

there is alreadya routine present !

I need to start the key generation at a particular number, in this case is changing (Copy) the routine the best way to do this, I did read it before but I am not sure where !
Thanks,

Thanks Ray,
Got the above issue resolved after talking to our DBA who assigned more tablespace.

Hey Andrw,
Just curious, how do we disable indexes and rebuild them in context with a EE job?
Is it described int he documentation any where?
Thanks,

You bet !
Thanks Andrw

Hi Trying to load 10 million rows, using a simple EE job which reads from production and writes to development table. I am getting the following error and the job aborts, is there that I can do something, or do we have a parameter which alows us to drop the indexes and build them after the load! sql...

But I dont understand why the following statement doesnt work:

if IsNull(Src.Col1) then ' ' else Src.Col1

' '=Blank


Thanks,

It i sChar(4), so how do we handle this if it is varchar ?

Searched for it and I used the APT_ORACLE_PRESERVE_BLANKS, and set it to true.

The job finishes now!

Thanks a bunch guys.

Hi Arnd,

It is "NOT NULL CHAR(4)".

I tried to use

if IsNull(Src.Col2) then ' ' else Src.Col2

and it still aborts
Record 805: Rejected - Error on table SAP_ZAVL_PROJ, column ZAVL_PROJ_DESIGN_ID. ORA-01400: cannot insert NULL into (ZAVL_PROJ_DESIGN_ID)

is your name Arnold ?

Hi ,
The job works in 2 scenarios,

1)When I took the source column out and had a constant.

2) When I changed the constant to ' ' it works but I do not understand why it doesnt recognize the ' ' comming in !

Thanks

Hi Arnd,

It is complaining about inserting a blank into a field , but it is really not null .

Record 805: Rejected - Error on table SAP_ZAVL_PROJ, column ZAVL_PROJ_DESIGN_ID.ORA-01400: cannot insert NULL into (ZAVL_PROJ_DESIGN_ID)

Hi, I have a file which I load into a table. If I use UPSERT option in the Oracle enterprise stage, the job finishes fine, but If I use WRITE METHOD=LOAD & WRITE MODE= TRUNCATE, the job aborts with the following error! The system(sqlldr bdr@cooradevl31 CONTROL=ora.3331.899749.0.ctl LOG=ora.3331....

Thanks Ray!

Hi,

I donot have the table, bascially what is being done (Case statement ) has to be implemented over a file.
Thanks,