isql output file not created while running it through cron

Shell Programming and Scripting
1

#!/bin/ksh
file="/pkgs/roots/scripts/ISQL_op.txt"
isql -H 11.11.11.111:1111 -U myUser -P myPwd -o $file << eof
go
select * from Table1
go
eof

my cron entry
00 08 03 11 * /pkgs/roots/scripts/testc.ksh

file permission of the script is correct, i have used absolute path everywhere.

The script runs fine, in standalone mode.

but while executing through cron the isql output file is not getting generated.

Please help me find the issue and its resolution.

2

i have used absolute path everywhere.

but for isql command you have not specified absolute path.

In debian kind of system, you are likely to see what is the error in syslog.

3

Thanks,

How can i find the absolute path of isql command. ?
what command will get the default absolute path of isql command.