suse系统 懂shell 与sybase 进来，帮忙看一个语法

deelaaay

脚本如下
#!/bin/bash
DIR=`pwd`
logfile=$DIR/logfile
local_database_setup_dir=`cat $DIR/config.txt|grep local_database_setup_dir|awk -F"=" '{print $2}'`
local_loginname=`cat $DIR/config.txt|grep local_loginname|awk -F"=" '{print $2}'`
local_password=`cat $DIR/config.txt|grep local_password|awk -F"=" '{print $2}'`
local_servername=`cat $DIR/config.txt|grep local_servername|awk -F"=" '{print $2}'`
remote_servername=`cat $DIR/config.txt|grep remote_servername|awk -F"=" '{print $2}'`
database_name=`cat $DIR/config.txt|grep database_name|awk -F"=" '{print $2}'`
remote_database_port=`cat $DIR/config.txt|grep remote_database_port|awk -F"=" '{print $2}'`
remote_server_ip=`cat $DIR/config.txt|grep remote_server_ip|awk -F"=" '{print $2}'`
device_name=`cat $DIR/config.txt|grep device_name|awk -F"=" '{print $2}'`
logdevice_name=`cat $DIR/config.txt|grep logdevice_name|awk -F"=" '{print $2}'`
proxy_localtion=$remote_servername\.$database_name\.dbo.
grep $remote_servername $local_database_setup_dir/interfaces >>/dev/null
if [ $? != 0 ];then
  echo "
$remote_servername
        master tcp ether $remote_server_ip $remote_database_port
        query tcp ether $remote_server_ip $remote_database_port
   ">>$local_database_setup_dir/interfaces  
fi
#. $local_database_setup_dir/ASE150.sh
#export LANG=C
su - sybase -c"
isql -U$local_loginname -P$local_password -S$local_servername <<EOF
--创建代理数据库
USE master
go
IF EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE name='$database_name')
DROP DATABASE $database_name
go
--create database $database_name  on $device_name = 250 log on $logdevice_name = 50 with default_location='$remote_servername\.$database_name\.dbo.'  for proxy_update
create database $database_name  on $device_name = 250 log on $logdevice_name = 50 with default_location='$proxy_localtion'  for proxy_update
go
EOF">>$logfile


执行如下
suse130:~/master_slave # cat logfile
Msg 102, Level 15, State 1:
Line 2:
Incorrect syntax near '='.
Msg 102, Level 15, State 1:
Line 4:
Incorrect syntax near '='.
suse130:~/master_slave #



好几个小时了。。帮我看看= 号那里该怎么修改

ceozenliu

--创建代理数据库
USE master
go
IF EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE name='$database_name')
DROP DATABASE $database_name
go
--create database $database_name  on $device_name = 250 log on $logdevice_name = 50 with default_location='$remote_servername\.$database_name\.dbo.'  for proxy_update
create database $database_name  on $device_name = 250 log on $logdevice_name = 50 with default_location='$proxy_localtion'  for proxy_update
go
EOF">>$logfile
======================================================

紅字的那一行，應該也是註解吧！在前面加個註解符號試試

Anxiang1129

Msg 102, Level 15, State 1:
Line 2:
Incorrect syntax near '='.

你的=号附近有语法错误

device_name = 250

把250换成英文字符试试，其他同理

wfcjz

1、把device_name = 250,把250换成英文字符试试，其他同理。

2、改动的部份如下：
--create database $database_name  on $device_name = 250 log on $logdevice_name = 50 with --default_location='$remote_servername\.$database_name\.dbo.'  for proxy_update

deelaaay

红色那行不是注释。整句是创建代理数据库语法。create database name with default_location ='path ' for proxy_update回复 2# ceozenliu


   

deelaaay

红色那行不是注释。整句是创建代理数据库语法。create database name with default_location ='path ' for proxy_update


其次 换成英文字符如下：
su - sybase -c"
isql -U$local_loginname -P$local_password -S$local_servername <<EOF
--创建代理数据库
USE master
go
IF EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE name='$database_name')
DROP DATABASE $database_name
go
create database $database_name  on $device_name = convert(varchar(10),250) log on $logdevice_name = convert(varchar(10),50) with default_location='$remote_servername\.$database_name\.dbo.'  for proxy_update
go
EOF">>$logfile
还是一样的语法错误
回复 4# wfcjz


   

deelaaay

另外，单独测试
IF EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE name='$database_name')
DROP DATABASE $database_name
go
这一句的语法没有问题。

deelaaay

这次换成字符char
create database $database_name  on $device_name =convert(char,250) log on $logdevice_name =convert(char,50) with default_location='$remote_servername.$database_name.dbo.'  for proxy_update
go

一样的报错
另外，
create database $database_name  with default_location='$remote_servername.$database_name.dbo.'  for proxy_update
不加指定的数据设备，语法上没有错误，只是提示必须添加指定数据设备而已。所以估计  on $device_name =convert(char,250) log on $logdevice_name =convert(char,50) 这里的语法有问题
回复 4# wfcjz


   

deelaaay

问题解决了，是我自己大意粗心了。
device_name=`cat $DIR/config.txt|grep device_name|awk -F"=" '{print $2}'`
logdevice_name=`cat $DIR/config.txt|grep logdevice_name|awk -F"=" '{print $2}'`
其中device_name  取值grep 参数 不是唯一。在Logdevice_name中也包含有grep 参数 。。导致$device_name的值有问题。