SQL Assistant Expecting Characters in Data

Tools & Utilities
Highlighted

SQL Assistant Expecting Characters in Data

CREATE SANDBOX.SC2_VDGB  (
  MAIN_ID VARCHAR(12) 
, PLAN_NBR VARCHAR(9) 
, MEMBER_NAME VARCHAR(64) 
, CASE_NBR VARCHAR(9) 
...
, X8 VARCHAR(1) 
, XB VARCHAR(1) 
, XC VARCHAR(1) 
, XD VARCHAR(1) 
, DAHS_FACILITY_PROV_NBR VARCHAR(12) 
, DAHS_FACILITY_NAME VARCHAR(64) 
, PRODUCT VARCHAR(2)
)
PRIMARY INDEX (MAIN_ID);

INSERT INTO SANDBOX.SC2_VDGB
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);

Good morning all... new to Teradata.

I am attempting to import data using Teradata SQL Assistant (TSA) and am receiving the following error:

Error executing query for record 1: [3707] Syntax error, expected something like ',' or ')' between the word 'Dave' and the word 'Borden'.

'Dave Borden' is the value of the third field or the first record. I am not understanding why TSA is expecting syntax in imported data. I need some help understanding why this might be. Any ideas?

1 REPLY

Re: SQL Assistant Expecting Characters in Data

Please disregard... I was not aware that I couldn't run an insert in the same tab as another query. I ran the insert in a different tab and viola... success.