Hello,

How do I continue a query statement? The content of COMMENT5 is too long for the screen. Therefore I have to write the statement on two different lines. Will this example work?

UPDATE ADUADS01.ADVTB939
SET COMMENT5 =
' WHEN SHE IS READY TO MOVE ON THIS. MAY BE A YEAR OR TWO BEF'
WHERE EID = '0000323006';



Thank you for any input!

I am assuming you are using the CLP. If you have to goto another line you can use the backslash as a continuation character.

Andy

Thank you, Andy

Alternatively, you already use a statement terminator (';'). If you run the CLP in this mode (i.e. with the -t option), DB2 will parse all lines up to that statement terminator.

p.s: The statement terminator is not part of the SQL statement - it just separates multiple SQL statements.

the easiest way would be
create a file keeping the statements terminated with any character (default
and execute with
db2 -tvf filename
or db2 -stvf filename
see info center for detail of options specified...