Start a new topic

Error while Using LOAD table in SYABSE IQ 15.2

[This topic is migrated from our old forums. The original author name has been removed]

Hi All, New to DBVis. I was trying to load a file from client to a Sybase IQ table using the following syntax: load table DBA.TestLoad (c1, c2, c3, c4 '\x0a' ) USING CLIENT FILE 'C:\TestData\loadtest.txt' QUOTES OFF ESCAPES OFF FORMAT ascii DELIMITED BY ',' This SQL statement works fine when used in DBISQL client. However when I run the same command in DBVis SQL Commander, It gives me an error that input file 'C:\TestData\loadtest.txt' does not exist. Any ideas why? The file is physically there in the directiory and I can use the file in DBISQL. Any helpis appreciated.
1 Comment

[This reply is migrated from our old forums.]

Re: Error while Using LOAD table in SYABSE IQ 15.2
Hi Tario, Which JDBC driver do you use? According to the Sybase IQ documentation, the USING CLIENT FILE clause is only supported by some JDBC drivers, notably *not* by the jTDS driver. An alternative you may try is the Table Data Import feature: http://confluence.dbvis.com/display/UG91/Importing+Table+Data Best Regards, Hans