Trigger schema

Use this box to specify the schema of the trigger that you're creating. The initial value in this box is the user ID under which you connected to the database. To specify a schema with a name that's different than this ID, use one of these methods:

• Click on the down arrow to display a list of existing schemas and select one.

• Type the name of the schema that you want. The schema can be an existing one or, if you have IMPLICIT_SCHEMA authority, it can be a new one. If it's new, its name:

  • Can contain up to 8 characters, including letters, numbers, at signs, pound signs, dollar signs, and underscores

  • Must start with a letter

  • Cannot begin with SYS

  • Cannot be one of the following reserved schema names:

    • SYSCAT

    • SYSFUN

    • SYSIBM

    • SYSSTAT

  • Can be an ordinary or delimited identifier

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]