DSXchange

Hi, First case: I have been trying to import the table definitions of a source database and I am not able to connect to the database. I use the " plug in meta - deta" option I get an error saying "unable to connect to server - XXXX" second case: I am able to connect to tthe targe...

how do I import source and target table definitions from two different servers ?

Hi Thanks for the efforts: I am sorry the status was a 'warning' As stated earlier these are my settings: I have a sequential file that needs to be loaded in to a target Database(using an ODBC stage). The sequential file contains three rows. In the second row I created an error( placed a character v...

I am setting it at the ODBC stage

ray.wurlod wrote:Where - exectly - are you setting the rows per transaction property value? ...

Thnks but when i tried with the same settings you suggested it still does not rollback the previous transactions, For eg. I have 3 rows to be loaded. In the second row I have a character value which will be loaded to a numeric column. In Principle it should abort the job and roll back the changes......

it does abort....
i am trying it with three test rows...the second row has the error.

when i run it the first row commits....the rows per transaction have been set 0.

any suggestions ? thanks for your input

chulett wrote:Your job must abort to roll back transactions - is that happening? ...

Hi ! I am loading files from sequential file to a target database. Target as DB2: If there is an error I am able to roll back the changes made by entering the Transaction Size as 0 and Array Size = number of records being loaded. Is this correct ? Target as ODBC When I use this stage I am not able t...

Hi I tried but it still commits the previous rows. I set the trasaction isolation to - uncommitted read and the array size =1 and transaction siz = 0 How do I make it to roll back ? Basically by not committing. Transaction Size is a stage property, so for example, setting it to 0 will get you an 'al...

I am loading from a sequential file to a target database. If there is an error in one of the rows how do I roll back the previous changes ?

Thanks

Is it possible to provide application defined return code in DS? If so how is it done
?

Thanks

I am creating a job sequence to execute five jobs(with Parent/child relationships)...If one of them fails I need to roll back all the changes and rerun the sequence. How is this possible ?

Is there a way to not commit the jobs until the last one is completed successfully.


Thanks