Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Names

Names are strings used to identify objects.

In SESAM/SQL, there are names for the following SQL objects:

  • database (catalog)

  • Schema

  • Space

  • Storage group

  • table (base table, view, correlation)

  • Column

  • Index

  • Integrity constraint

  • Authorization identifier

  • cursor

  • Routine (routine parameter, local variable, error)

  • label

  • dynamic statement:
    The name of a dynamic statement is referred to in this manual as the statement identifier to distinguish it from the actual name of the statement, such as SELECT, for example.

  • symbolic attribute name of a CALL DML column:
    The syntax for the symbolic attribute name of a column is the same as the syntax for symbolic attribute names in SESAM/SQL Version 1.x.

  • host variable:
    The name of a host variable must observe the conventions of the programming language involved. These conventions are described in the manuals for the relevant programming language and they are not explained here.