Question about running multiple sql scripts
Disclaimer: I'm new to Vertica.
I have a shell script that runs a SQL script with vsql
vsql -f FILELIST.sql
FILENAME contains a list of other SQL scripts to run.
This works fine when the SQL scripts it's running contains DDL to create schema objects i.e. CREATE table .....
but when I try to run DML
INSERT INTO SomeTable (something1,something2) VALUES ( somevalue1,somevalue2 );
vsql fails complaining about syntax.... Syntax error at or near "INSERT" at character 1
I'm sure it's something silly, but what am I missing? Am I going about this all wrong?
Any input would be great.