We need to develop a RDBMS independent job to put data into a table, will ODBC stage serve the purose.
TIA
SAM
Datastage
Moderators: chulett, rschirm, roy
Hi,
How about the DRS (Dynamic RDBMS) stage?
IHTH,
How about the DRS (Dynamic RDBMS) stage?
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Re: Datastage
A sequential text file, probably pipe or comma delimited, is the universal format. You can write your data to a file, it then becomes an exercise in writing the appropriate connectivity job to load it.sudhirmah wrote:We need to develop a RDBMS independent job to put data into a table, will ODBC stage serve the purose.
TIA
SAM
The problem with ODBC stage is that each driver has custom information that needs to be setup for it. When you first import table definitions, you must press a get info button on the ODBC stage to talk to the driver. This returns different results depending on the driver. Failure to do this causes the job to have issues. So, you can't simply switch a job to write to Oracle when the stage was setup for SQL-Server.
The DRS has similar issues, and its one-size-fits-all solution is never going to be optimal for performance, it's only optimal for ease-in-use. But it too has issues.
To build a universal adapter approach, writing to a sequential file allows you to write a loading script appropriate to each target, and use the command line loading utility that most databases provide (isql, sqlldr, dbaccess, tmu, etc.)
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
come to think of it I never got to actually try (lets say) building an Oracle insert job with DRS and then change the RDBMS type (at run time) to something else and checked what happens when I run it against the new and valid DB type.
I guess we'll need some one to make some tests and report the results.
I guess we'll need some one to make some tests and report the results.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
It works. The DRS is designed to let you choose the RDBMS at run time. As long as you haven't put in any RDBMS specific code in your user-defined SQL or generated WHERE clause such as functions or database optimisation hints.
You can set the database type to a job parameter to change it at run time or if you have already hard coded it you can export and do a search and replace to switch your database type.
You can set the database type to a job parameter to change it at run time or if you have already hard coded it you can export and do a search and replace to switch your database type.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DRS came about largely as a result of the PeopleSoft decision to use DataStage; they needed a generic mechanism for deploying canned ETL jobs to their customers who, of course, use different databases for running the PeopleSoft applications.
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.