Problem: Insert string parses without error but does not insert values due to incorrect syntax. Statement failed, SQLCODE = -104 Dynamic SQL Error -SQL error code = -104 -Token unknown - line 1, char 29 -select Solution: Example: Metadata used: CREATE DATABASE test.gdb; CREATE TABLE t1 ( f1 varchar(10), f2 varchar(10)); CREATE TABLE t2 ( f1 varchar(10), f2 varchar(10)); Populate TABLE t1: INSERT INTO t1(f1,f2) VALUES ("test", "data"); Offending: (INSERT/SELECT Syntax:) INSERT INTO t2(f1,f1) VALUES SELECT f1,f2 FROM t1; Correct: (INSERT/SELECT Syntax:) INSERT INTO t2 SELECT f1,f2 FROM t1; (or) INSERT INTO t2(f1,f2) SELECT f1,f2 FROM t1 (or) INSERT INTO t2 SELECT * FROM t1 (or) INSERT INTO t2 SELECT f1,f2 FROM t1 WHERE f1 = "blah"; (or)
Last Modified: 29-SEP-00