I am currently trying to connect from Oracle to Sybase IQ. My requirement is to send a table data into Sybase IQ. Are there any other options other than ODBC connectivity?
I am thinking of writing a BCP script to load data in Sybase IQ. For that the Oracle server should host an IQ client as well. Has anyone done this before? Any help on this would be of great help!
Any sample Shell Script which does a BCP would be of help.