Hi All,
Can any one help me how DB2 or Oracle Connector stages work on Backend? Manual is saying it is using APIs but not mentioned what APIs it is really calling for DB2?
I see on DB side, it is triggering some packages/procedures when I run the job but any one having the list of all procedures it calls when we try to Insert/Update/Delete on DB from DB2 connector?
Thanks..
DB2 Connector Internals
Moderators: chulett, rschirm, roy
DB2 Connector Internals
--
Swathi Ch
Swathi Ch
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You will get some idea by downloading some of the other Connector stage types from developerWorks - some of them even include source code.
From memory, the DB2 API is very similar to the ODBC API.
From memory, the DB2 API is very similar to the ODBC API.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 7
- Joined: Thu Nov 12, 2009 4:44 am
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't believe there is any way to change default property settings in out-of-the-box stages (in general - though the Sequential File stage does allow default format to be selected).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thank you Ray for the Information.
I verified the ODBC API's code. It looks like we are calling Java classes on backend from connector stages.
So If I have 4 node configuration file, then each session will create a separate java class instance and that java instance process the data row by row it receives from ETL job?? Or is there any buffer collector which collect all data from ETL job by session and invoke java class to process all data at once?
I verified the ODBC API's code. It looks like we are calling Java classes on backend from connector stages.
So If I have 4 node configuration file, then each session will create a separate java class instance and that java instance process the data row by row it receives from ETL job?? Or is there any buffer collector which collect all data from ETL job by session and invoke java class to process all data at once?
--
Swathi Ch
Swathi Ch