DSXchange

I do understand why cyclic dependency is, and now i am trying to look up the records that matches with my input to Db stage. From transformer1 i am getting 20 fields and 5 of them were passed to Db stage from trsformer2 and i am getting all the records back from db with out matching the criteria. DB...

Hi I am trying to pull the record from DB2 based on the key input from a transformer and my out put from DB stage is seq number for that key. I am getting this key into another tranformer and all the values have been passed to the second transformer from first one and trying to insert the records wi...

Thanks for the explanation. I google little bit about the function.

Now my question is is it possible to pass the key values to Database from Transformer and get the row from table and in another transformer can i compare the rows with the function or can compare each field?

Can you please explain little in detail please? I am fairly new to DS.

Ok, Finally i should be able solve the Db2 rejects capture issue.
The Arraysize should be 1, it has 50 before and now works fine.

Thanks all for taking time to respond to questions.

Hi

I am getting data in flat file and reading the data and loading the data to DB2 databse. My requiremnt is insert new o rupdate the existing data in db2, but at the same time write the updating record data to a file.

Can some please give idea, how i can achive this?

I Tried this and still gets the NULL.

Oconv(Iconv(Input.LCL_DPTR_DTE, "DMDY[2,2,4]"), "D/MDY[2,2,4]")

My input date is 11302009
and tried your suggestion above and getting NULL as return

Hi I am using DB2 API Stage and 'insert rows without clearing' action. Just wanted to make sure i am briefing the procedure what i have done. Ihave sequencial file,transformer, Db2 API and Reject file from tranformer stage.Read records from File(separated by pipe) and in the transformer i don't have...

Yes, it does.

HI All, Scenario: Source is a txt file, and needs to load the data into Db2 database. If the same row exists in database, increment the sequence number and insert the row, if not sequence number will be defaulted to 1. Eg: AAA,BBB,CCC,DDD (will be having seq number 1 while db insert) AAA,BBB,CCC,EEE...

Nope, Databse loading is first and then rejected link(order 2).

It does make no difference...job is executing okay, but the no rejected records were in rejected file.The log shows that the records were rejected due to duplicate keys.

Hi

Close the sequencer job in designer view and now on your left hand side where you have job tree structure, right click on the job and you will see the properties .

Hi how can we insert data into 2 different tables from transformer in a single transaction? Scenario : Think of Master table and child table. From seq file i am getting data to both Master and child in a single row, i am separating the data and would liek to insert master data first and up on succes...