How do you LOAD TABLE in Sybase IQ from a client using Java?

Question

Is it possible to load a file from a client computer into a table in Sybase IQ, using the LOAD TABLE ... USING CLIENT FILE statement?

The data does not come from a database, but rather an external source.

Can this be done using a JDBC driver in Java, and having the file only on the client computer?

If so, how?

Answer 1

Try this : http://stackoverflow.com/questions/2112395/sybase-jconnect-enable-bulk-load-usage Also, you may want to try bcp.

Answer 2

After doing some research, and a "proof-of-concept" this is the anser I have come up with:

Use the iAnywhere JDBC Driver, which is part of the SQL Anywhere Studio suite of software from SyBase. It is not limited to the TDS protocol, which the standard jConnect JDBC driver from SyBase is.

http://www.sybase.com/detail?id=1037304

Note: This is not a Type 4 driver, and is not pure Java.