Direct loading of data from clients

Sybase IQ now supports bulk loading of remote data via the LOAD TABLE USING CLIENT FILE statement. LOAD TABLE USING FILE loads data on the local server, as does the LOAD TABLE FROM syntax, which is deprecated in this release. LOAD TABLE USING FILE also replaces the deprecated utility iq_bcp.

Both server and client need to be at Sybase IQ 15.0 level. A combination of 15.0 server and 12.7 client returns a File I/O Error.

For syntax, see LOAD TABLE statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.