You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by "Huang, Jack" <Ja...@dell.com> on 2017/12/21 03:48:52 UTC
1 characters from start of SQL statement
Hi,
I try to use trafci.sh to run some sql command, but got the error. Could some help on it?
[trafodion@trafodion ~]$ trafci.sh -h trafodion:23400 -p Password123! -q /home/trafodion_delete_schema.sql
Welcome to Apache Trafodion Command Interface
Copyright (c) 2015-2017 Apache Software Foundation
Host Name/IP Address: trafodion:23400
User Name: trafodion
*** ERROR[15001] A syntax error occurred at or before:
/home/trafodion_delete_schema.sql;
^ (1 characters from start of SQL statement) [2017-12-20 22:47:00]
[trafodion@trafodion ~]$ cat /home/trafodion_delete_schema.sql
get schemas;
Jack Huang
Dell EMC | CTD MRES Cyclone Group
mobile +86-13880577652<tel:+86-13880577652>
jack.huang@dell.com<ma...@dell.com>
RE: 1 characters from start of SQL statement
Posted by Venkat Muthuswamy <ve...@esgyn.com>.
If you want to specify an input script file use the -s parameter. The -q is to specify a sql statement.
Venkat
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, December 21, 2017 5:26 PM
To: user@trafodion.apache.org; user@trafodion.incubator.apache.org
Subject: RE: 1 characters from start of SQL statement
Hi,
Please add -u user_name
trafci.sh -h trafodion:23400 -u username -p Password123! -q /home/trafodion_delete_schema.sql
Best regards,
Yuan
From: Huang, Jack [mailto:Jack.Huang@dell.com]
Sent: Thursday, December 21, 2017 11:49 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: 1 characters from start of SQL statement
Hi,
I try to use trafci.sh to run some sql command, but got the error. Could some help on it?
[trafodion@trafodion ~]$ trafci.sh -h trafodion:23400 -p Password123! -q /home/trafodion_delete_schema.sql
Welcome to Apache Trafodion Command Interface
Copyright (c) 2015-2017 Apache Software Foundation
Host Name/IP Address: trafodion:23400
User Name: trafodion
*** ERROR[15001] A syntax error occurred at or before:
/home/trafodion_delete_schema.sql;
^ (1 characters from start of SQL statement) [2017-12-20 22:47:00]
[trafodion@trafodion ~]$ cat /home/trafodion_delete_schema.sql
get schemas;
Jack Huang
Dell EMC | CTD MRES Cyclone Group
mobile +86-13880577652<tel:+86-13880577652>
jack.huang@dell.com<ma...@dell.com>
RE: 1 characters from start of SQL statement
Posted by Anuradha Hegde <an...@esgyn.com>.
It should be -s <script file> or -q <query>
You can see the usage, trafci.sh -help
Anuradha
From: Liu, Yuan (Yuan) [mailto:yuan.liu@esgyn.cn]
Sent: Thursday, December 21, 2017 5:26 PM
To: user@trafodion.apache.org; user@trafodion.incubator.apache.org
Subject: RE: 1 characters from start of SQL statement
Hi,
Please add -u user_name
trafci.sh -h trafodion:23400 -u username -p Password123! -q /home/trafodion_delete_schema.sql
Best regards,
Yuan
From: Huang, Jack [mailto:Jack.Huang@dell.com]
Sent: Thursday, December 21, 2017 11:49 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: 1 characters from start of SQL statement
Hi,
I try to use trafci.sh to run some sql command, but got the error. Could some help on it?
[trafodion@trafodion ~]$ trafci.sh -h trafodion:23400 -p Password123! -q /home/trafodion_delete_schema.sql
Welcome to Apache Trafodion Command Interface
Copyright (c) 2015-2017 Apache Software Foundation
Host Name/IP Address: trafodion:23400
User Name: trafodion
*** ERROR[15001] A syntax error occurred at or before:
/home/trafodion_delete_schema.sql;
^ (1 characters from start of SQL statement) [2017-12-20 22:47:00]
[trafodion@trafodion ~]$ cat /home/trafodion_delete_schema.sql
get schemas;
Jack Huang
Dell EMC | CTD MRES Cyclone Group
mobile +86-13880577652<tel:+86-13880577652>
jack.huang@dell.com<ma...@dell.com>
RE: 1 characters from start of SQL statement
Posted by "Liu, Yuan (Yuan)" <yu...@esgyn.cn>.
Hi,
Please add -u user_name
trafci.sh -h trafodion:23400 -u username -p Password123! -q /home/trafodion_delete_schema.sql
Best regards,
Yuan
From: Huang, Jack [mailto:Jack.Huang@dell.com]
Sent: Thursday, December 21, 2017 11:49 AM
To: user@trafodion.incubator.apache.org
Subject: 1 characters from start of SQL statement
Hi,
I try to use trafci.sh to run some sql command, but got the error. Could some help on it?
[trafodion@trafodion ~]$ trafci.sh -h trafodion:23400 -p Password123! -q /home/trafodion_delete_schema.sql
Welcome to Apache Trafodion Command Interface
Copyright (c) 2015-2017 Apache Software Foundation
Host Name/IP Address: trafodion:23400
User Name: trafodion
*** ERROR[15001] A syntax error occurred at or before:
/home/trafodion_delete_schema.sql;
^ (1 characters from start of SQL statement) [2017-12-20 22:47:00]
[trafodion@trafodion ~]$ cat /home/trafodion_delete_schema.sql
get schemas;
Jack Huang
Dell EMC | CTD MRES Cyclone Group
mobile +86-13880577652<tel:+86-13880577652>
jack.huang@dell.com<ma...@dell.com>