Sybase IQ download table using client file fails

Question

I am using Sybase IQ 15 database database.

trying to load an IQ table from a restricted flat file

Load Table test (a,b)
using client file '/xyz/test.dat'
ESCAPES OFF
FORMAT BCP
DELIMITED BY '|';

this is an error with the error below

Msg 21, Level 14, State 0:SQL Anywhere Error -1006140: I/O Error on file/xyz/test.dat - (hos_clientfileio.cxx 142)

set lower at IQ server level, still getting the same error

set option allow_read_client_file='on' ;
grant READCLIENTFILE to finsrv ;

the data file is on the unix client machine and the contents of the file below

1 | 01

2 | 02

Can anybody help / consult?

Answer 1

This is probably a problem with user rights settings.

Try changing all the directories /xyz/test.dat to 755 (drwxr-xr-x):

shell command on the client computer:

1 - sudo chmod 755 -R /xyz/

or

2 - find /xyz/ -type d -exec chmod 755 {} \;

. SO Ubuntu.