By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,717 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

What is the max length of a trigger name?

P: n/a
It isn't in the places I looked in the SQL Reference, but examination of
syscat.triggers yields 18, if I read it correctly. Is 18 correct?
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Bob Stearns" <rs**********@charter.net> wrote in message
news:lL******************@fe05.lga...
It isn't in the places I looked in the SQL Reference, but examination of
syscat.triggers yields 18, if I read it correctly. Is 18 correct?


According to Appendix A of SQL Reference Vol I:

Longest unqualified user-defined type, user-defined function, user-defined
method, buffer pool, table space, database partition group, trigger, index,
or index specification name = 18.
Nov 12 '05 #2

P: n/a
Bob Stearns wrote:
It isn't in the places I looked in the SQL Reference, but examination of
syscat.triggers yields 18, if I read it correctly. Is 18 correct?

Yes

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.