Shell Programming and Scripting

Hi there,

I am trying to write a shell script as root on AIX 5.3 where I change user to db2inst1, connect to our db2 database, run a sql select query and export the result of the query to a file.

The code I have so far is as follows:-

#!/usr/bin/ksh

su - db2inst1 -c "db2 connect to <db_name>; set schema APP;"
export to /home/db2inst1/esb_checks/kicker/kicker.del of del;
select * from <TABLE_NAME>;

The script connects OK, and sets the correct schema however an error is produced as follows when running and exporting the sql code:-

/home/db2inst1/esb_checks/kicker/kicker.del: This is not a
n identifier.

When I login as the db2inst1 user and run the query manually it works fine:-

connect to <database_name>;
set schema APP;
export to /home/db2inst1/esb_checks/kicker/kicker.del of del;
select * from <TABLE_NAME>;

I've scoured the UNIX forums and found nothing to resolve my problem, I have found a few threads that have pointed me in what I have thought is the right direction, but I am still at a loss.

I'm wondering if this is a permissions issue? or maybe not?

Any help or expert pointers, much appreciated

Cheers

Candlino