Measure Reference Manual

name
input
STRING .EXT:ref:*
is a buffer that contains the input name in external format to be expanded to a fully qualified
name. If name does not contain the catalog and/or schema name, the default catalog
(def_catalog) and/or default schema (def_schema) name is used. In that case, if the
necessary def_catalog and/or def_schema name is missing, an error is returned. Wildcards
are permitted. A name space keyword is required.
name_length
input
INT:value
is the size in bytes of the input name.
def_catalog
input
STRING .EXT:ref:*
is a buffer that contains the default catalog name that is used if the input name omits the catalog
field, in which case it must be specified.
def_catalog_length
input
INT:value
is the size, in bytes, of the default catalog name passed by the def_catalog parameter.
def_schema
input
STRING .EXT:ref:*
is a buffer that contains the default schema name that is used if the input name omits the schema
field, in which case it must be specified.
def_schema_length
input
INT:value
is the size, in bytes, of the default schema name passed by the def_schema parameter.
Usage Notes
• ANSI SQL objects have independent name spaces and, if identical names exist in different
name spaces, each instance of the name refers to a different object.
• The name spaces used by Measure are TABLE, INDEX and MODULE. TABLE is implied by
using the keywords CATALOG, SCHEMA and TABLE. INDEX is implied by using the keyword
INDEX. MODULE is implied for SQLSTMT (in MEASCOM there is no MODULE keyword).
• When calling the MEASSQLNAME_* APIs, the input ANSI SQL names must be preceded by
a name space keyword.
440 Measure Callable Procedures