When using jconn3.jar to connect to Sybase IQ database, and execute LOAD TABLE ...CLIENT FILE statement in Statement.execute(...) method.
Got error: SQL Anywhere Error -1006140: I/O Error on file c:/aa
But in Sybase's Interactive SQL client, this command run correctly and table data can loaded from c:/aa file successfully.
What's the reason? how to fix this?
Thank you.
Finally came to the solution: use the iAnywhere JDBC driver (but it is not a Type 4 "Pure Java" driver ).