I am trying to insert values into my database using the command window (im running DB2 version 8.1), but when my insert statement hits a semi colon (";") it considers that the terminating point
How can i insert data into my database when the values themselves contain semi colons?? Is there an escape code or something??
insert into "~TMPCLP361431" values ('document 1','bla bla bla; bla bla bla');
db2 insert into testchar1 values\(\'fgfg\;fdsg\'\)
Escape sequence is '\'
Thanks for your help, i tried this through the command window and it does not work, it still will not allow the ";" as part of the string. Its still interprets it as the end of the SQL insert. Im not sure what else to try . How does the escape character work?? And does it work in the command window??