SQL Anywhere for Linux - dbisqlc unload table error

Author

dbisqlc unload table error

LHradowy

2005-04-05, 8:02 pm

I am current running ASA 7.0.4.3366 on a Red Hat 7.2 server
My main plan it to switch it over to ASE linux express.

Very simple database with 8 tables.
I am having trouble trying to unload the tables thru dbisqlc

My command is...
unload table action
to 'action1.dat'
delimited by ','
quotes off

I get an error when I try to run it...
can not access file action1.dat --permission denied

I have tried putting in the full path and still same error.I
have tried
touching the file first, and chmod 777 still nothing.

I connected to the database as dba, so I should be able to
unload the database. What do I need to do?

Greg Fenton

2005-04-05, 8:02 pm

LHradowy wrote:
>
> I have tried putting in the full path and still same error.I
> have tried
> touching the file first, and chmod 777 still nothing.
>

If the directory in which that file exists is not executable by the user
account under which the database server is running, then it won't be
able to write to that file.

Can you execute the following and post the output:

# ps -ef | grep dbsrv7 | grep -v grep | head

and

# ls -ld < full_path_to_action1
.dat> < full_path_to_action1
.dat>/..

> I connected to the database as dba, so I should be able to
> unload the database. What do I need to do?

The error is not an internal-database permissions problem. It is that
the engine is not able to create the file in the OS'es filesystem.
Being logged in as DBA gives you permissions to execute the SQL, but the
OS operation still must be valid within the permissions of the user
account under which the engine is running.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links