Re: Migrated From v7 => v9 ... and Now Can't Use Semi-Colons inStrings?

Originally Posted by

Just to clarify (for anyone else as clueless as me), the hexcode
character entity stuff isn't actually necessary at all. In fact, the
actual solution to this problem is so mind-numbingly simple I feel
idiotic for not realizing it sooner; just replace:
';\n'
with:
';' || '\n'
>
And now that I have a solution, I can summarize this entire issue (for
anyone who later reads this thread) as ...
>
*** Problem ***
INSERT INTO fakeTable (fakeColumn) VALUES (';
');
>
results in the following (incorrect) error:
>
db2 =INSERT INTO fakeTable (fakeColumn) VALUES (';
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0010N The string constant beginning with "'" does not have an
ending
string delimiter. SQLSTATE=42603
db2 =')
>
>
*** SOLUTION ***
INSERT INTO faketable(fakecolumn) VALUES (';' || '
');
>
results in the following (correct) error (unless you really do have a
table called "fakeTable"):
>
db2 =insert into faketable(fakecolumn) values (';' || '
db2 (cont.) =');
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0204N "DB2INST1.FAKETABLE" is an undefined name. SQLSTATE=42704
>
>
>
WOO HOO!