DSXchange

Hi, This may have been a close thread, but, found this as a related thread and hence would like to get some advise further on my question. Just wondering if is it possible to commit by a single row in parallel job using Oracle OCI or ODBC enterprise stages. I have a situation where in I have to read...

Hi, I am trying to figure out the proper way to configure the ODBC EE stage in parallel job to Upsert records into DB2 table. I noticed that when I select "Delete Then Insert option" in upsert mode, when the table is not empty, it is not inserting anything, but deleting all records. I am w...

I have found a possible solution, by running the following awk script on the filter option of the sequential file stage :- awk 'BEGIN{FS=",";OFS=","}{gsub("""","",$2)}1' This script basically strips out the quotes within column 2. Though this has fo...