Hi there,
My client is wanting to create jobs that source data from a Sybase ASE database (version 12.5) and load it into a Sybase IQ database (version 12.6).
We were planning to use the SYBASE OC plug-in stage to access the databases.
The problem appears to be that the SYBASE environment settings in dsenv, can only point to one environment at a time (so, currently we can log onto the ASE database but NOT the IQ database).
Anyone have any suggestions as to how we can achieve this?
How to access Sybase ASE and IQ databases in one job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Tue Apr 27, 2004 5:13 pm
- Location: Sydney
Hi,
you could configure your OC to the source DB and use the command line bulk loader from command line to load the data you prepared using the bulk loader stage with manual option.
IHTH,
you could configure your OC to the source DB and use the command line bulk loader from command line to load the data you prepared using the bulk loader stage with manual option.
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)