Measure Reference Manual

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.
MEAS_SQLNAME_RESOLVE_
In Measure H02 and later PVUs, MEAS_SQLNAME_RESOLVE_ combines ANSI SQL name parts
to create a fully qualified name in normalized external format. This routine resolves default
CATALOG and SCHEMA settings and returns the fully qualified ANSI SQL name in a normalized
external format.
error := MEAS_SQLNAME_RESOLVE_ ( result_name ! o
,result_name_max ! i
,result_name_length ! o
,name ! i
,name_length ! i
,[ def_catalog ] ! i
,[ def_catalog_length ] ! i
,[ def_schema ] ! i
,[ def_schema_length ] ) ; ! i
error
INT
is an error code indicating the outcome of the operation. Possible error codes include:
DescriptionError Code
Successful completion.0
result_name_max is too small to hold the fully qualified name in
normalized external format. If indicated, the required size will be returned
in result_name_length.
err^buftoosmall3204
One or more of the specified ANSI SQL names contained syntax errors.err^badformatsqlname3239
The ANSI SQL name specified could not be parsed.err^sql^api^internal3295
result_name
output
STRING .EXT:ref:*
is a buffer that contains the returned fully qualified name in normalized external format.
result_name_max
input
INT:value
is the size, in bytes, of the result_name buffer.
result_name_length
output
INT:ref:1
is the size, in bytes, of the fully qualified name returned in the result_name buffer. If error
3240 (ERR^BUFTOOSMALL) is returned, this displays the required size.
MEAS_SQLNAME_RESOLVE_ 439