Hi,
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??
E.g.
insert into "~TMPCLP361431" values ('document 1','bla bla bla; bla bla bla');

Your help is much appreciated

What is the datatype of the field ? I tried with char and varhcar, its working fine.

Sorry, previuosly I tried using JDBC and it worked. When I tried through DB2 command rpompt, its not working.

Try this working fine :

db2 insert into testchar1 values\(\'fgfg\;fdsg\'\)

Escape sequence is '\'

Hey,

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??

Sorry, i am using the command center, so im trying to get this to work via the GUI. Cheers Please HELP!!!

Hey Everyone,
Ive finally solved my own problem. Just thought id post it to let others know. Turned out to be really simple!!

e.g.
insert into "~TMPCLP361431" values ('document 1','bla bla bla; bla bla bla');
in the command center stops at the ";"

instead use:
insert into "~TMPCLP361431" values ('document 1','bla bla bla'||CHR(59) ||'bla bla bla');

Thanks for your help Sam, its much appreciated.

You might also try changing the Termination character from a semicolon (the default) to something else (e.g.'@'). This can be done on the Tools -> Tool Settings dialog.

Andy