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.

On Aug 10, 4:02 pm, Baski <mailtoba...@gmail.com> wrote:
> 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.

Baski wrote:
> On Aug 10, 4:02 pm, Baski <mailtoba...@gmail.com> wrote:
>> 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