DSXchange

I have to compare with target database its to expensive.
I want to say to datastage I want to go one with portion load of 100 (array size) thought the 1 row for example is reported with primary key violation.

Hi , Roy !

Can you be more specific .
With search with "preemptive measures " I dont get any topic .

May be explain me the basic idea of it

Hi! I get error primary key violation for one row. I use ODBC stage If array size is 1 the error reported as warning and if array size 100 the error reported as fatal and all job failed. I want get warning not to fail my job and I want to use 100 in array size for perfomance issue. Any ideas or I ne...

I still dont understand why even with singl link to table and transaction size set to 0 if i have warning on first row and stop the job from job sequence all rows after first are inserted/updated on database

And how to do rollback with singl link ? Doesnt matter two or more

I want to use different ODBC stages accordin my logic in transformer
and if any of links failed i want to undo all changes are made

Yes,elavenil ! You are right I try to find out how if I use different links to different ODBC stages on the same table the job hung up with parameters another from 1,1 for transactional size and array size. On other side i need to use 0 on transaction size to do abort and it seems it wont do any upd...

Hi !

I need help . I try to connect to hash file with UV stage And dont succeed

Wich stage exactly I need use (Universe ,Unidata,Unidata 6)

why i see connection name if i need to connect to file ?

May be there is some posting ? I need somthing for details steps

There is an option called 'On Fail', you set the appropriate value depends on your req.

Where do you see it ? On wich page ?

I dont work with oracle .It there somthing like this for sql server?

Add checkpoint option is to restart the job in the Job sequence from where it failed after the fixing the problem. This would not help rolling back the data in the database. It means if I restart the job it restarts from job was failed ? Can I compile the sequence and stiil job restart from this fa...

Thank you all ! I set the commit size to 0 and still new rows was inserted . MAy be I need set Isolation level another from NONE ? I use two different ODBC stages one for insert and one for update with transaction size 0 the job hung up during run. And only option set to transaction size to 1 is wor...

Hi !

I want to rollback all changes are made to databse if job returning with Status Failed from sequence.

If there is anyway to do so ?

Thanks in advance

The problem is that it not possible (itseems so for me) to implement update and insert in two separated links . If I use "Update existing rows only" DS givr warning if the row new and clause where of this option generate error . If I use "insert without clearing" in case of exist...

Hi !

I work with Update or Insert Option of ODBC stage. After the job finished I want know how many rows were inserted and how many updated within all number of rows are entered the stage.

if anyway to know it with help of DS metadata function ( DSStageInfo,DSLinkinfo etc.)

Thank in advance

Hi! I try to use different fromm default values of Transaction and Array size in ODBC stage and I have a problem with it : I run job with defaults (0 and 1) 20000 rows run ok. When I run 20000 rows with Transaction size 5000 and array size 100 I get Error : SQLSTATE=22005, DBMS.CODE=0 [DataStage][SQ...