467,209 Members | 1,352 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

setting the termination character in CLP

Hi,

In CLP I want to change the statement termination character from
default to ;(semi colon). I
tried update command options- but didn't work. how to do it????

regards,
Baski.

Aug 10 '07 #1
  • viewed: 7583
Share:
2 Replies
On Aug 10, 4:02 pm, Baski <mailtoba...@gmail.comwrote:
Hi,

In CLP I want to change the statement termination character from
default to ;(semi colon). I
tried update command options- but didn't work. how to do it????

regards,
Baski.
I found the answer, it is db2 -t. Thanks.

Aug 10 '07 #2
Baski wrote:
On Aug 10, 4:02 pm, Baski <mailtoba...@gmail.comwrote:
>Hi,

In CLP I want to change the statement termination character from
default to ;(semi colon). I
tried update command options- but didn't work. how to do it????

regards,
Baski.

I found the answer, it is db2 -t. Thanks.
If you need to change the option from within the CLP, e.g. to create
triggers or procedures use:
--#SET TERMINATOR <character>
e.g.
CREATE TABLE t(c1 int);

--#SET TERMINATOR %
CREATE TRIGGER trg BEFORE INSERT ON t
FOR EACH ROW
BEGIN ATOMIC
VALUES 1;
END
%
--SET TERMINATOR ;

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Aug 10 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Mahmood Ahmad | last post: by
4 posts views Thread by James Aguilar | last post: by
3 posts views Thread by Madhusudan Singh | last post: by
8 posts views Thread by Henning M | last post: by
1 post views Thread by laredotornado@zipmail.com | last post: by
reply views Thread by Xh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.