Unanswered: How to use Load Table command for SybaseIQ with binary file on client machine
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 '18.104.22.168\\D:\\ABC\\DEF\\myFile.bin'
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.