Hi,

I am trying to bulk upload data into SybaseIQ server from a binary file on my machine.

But I am getting syntax error near USING.

Below is my code -

LOAD INTO TABLE MyTable(Id, Source, Sender, Comment, InTime, Identifier, AuditTime)
USING CLIENT FILE '111.111.111.111\\D:\\ABC\\DEF\\myFile.bin'
ESCAPES OFF
FORMAT binary
DELIMITED BY '#'
WITH CHECKPOINT ON

I have following doubts:
1) Is the syntax correct
2) Can I do it this way. The sybase documentation says that for using CLIENT FILE, both the server and client shall be SYBASE IQ machines.
SyBooks Online
3) Do I need to share any directory on my machine. How can I make the Sybase IQ database read from that directory.

Thanks for your help.