用shell脚本实现去sybase数据库执行查询语句，结果报以下错误，求各位大大看看怎么回事？

改为：

checkcustomer(){

isql -Uxxx -Pxxx -Sxxxx <<EOF

select customer,customer_name,short_name,local_lang_type,local_lang_cust_name,sovereign_off,address1,address2,address3,address4,city,state,postal_code,country,nearest_airport,phone,fax,email_address,www_server_addr,corp_code,customer_type,business_category,GST_reg_no,is_busi_partner,iata_code,active_flag,loc_row_crt_date,create_office_code from cust_service..n_cust where customer="$1"

go

EOF

}

一般crontab无法执行，基本跟权限、路径和profile有关。

如果执行的语句很长可以写个成脚本这样也方便管理

#!/bin/bash

source /home/git/.bash_profile#先加载你可以执行这条命令的.bash_profile，在测试一下。

dbisql -c "uid=DBApwd=sql" -host 192.168.0.34 -port 2638 /home/gjt/query.sql

Profile ydf

SQLCA.DBMS = "OLE DB"

SQLCA.LogId = "sa"

SQLCA.AutoCommit = true

SQLCA.DBParm = "PROVIDER='SQLOLEDB',DATASOURCE='192.168.31.163',PROVIDERSTRING='database=BYD2015'"

connect using sqlca

---