Viewing Requesttext of a Trigger

Tools

Viewing Requesttext of a Trigger

hi,
i tried to select requesttext from dbc.triggers but was not able to view the entire text.
tried using .set WIDTH 60000..but yet not able to view the entire source of the trigger.
pls provide some inputs regarding the same..

Thanks
Viswanath
1 REPLY
Senior Apprentice

Re: Viewing Requesttext of a Trigger

Hi Viswanath,
the RequestText column in dbc.tvm is a VARCHAR(12500).
If the source code doesn't fit into that column then RequestTxtOverflow is set to 'R' and one or more rows are inserted into dbc.texttbl. The view dbc.TableText might be used to return those rows.

That RequestTxtOverflow column is not carried over to dbc.triggers, but you can also use dbc.tables with a search condition of TableKind = 'G' to return trigger info.

Dieter