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?
After doing some research, and a "proof-of-concept" this is the answer 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.