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:[email protected]] Sent: Thursday, December 21, 2017 5:26 PM To: [email protected]; [email protected] 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:[email protected]] Sent: Thursday, December 21, 2017 11:49 AM To: [email protected]<mailto:[email protected]> 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> [email protected]<mailto:[email protected]>
