SQL$HELP72.HLB  —  Routines  sql_get_message_vector, Description
    Use the sql_get_message_vector routine to retrieve information
    from the RDB$MESSAGE_VECTOR array. The array provides information
    about the execution status of SQL statements. Index 2 of the sql_
    get_message_vector routine returns the primary status code of
    the last SQL statement. This index is comparable to the SQLCODE
    status parameter.

    The ANSI/ISO SQL standard does not include the sql_get_message_
    vector routine or the RDB$MESSAGE_VECTOR array. For application
    programs that comply with the standard, use the SQLCODE or
    SQLSTATE status parameters. Furthermore, the status values
    returned for a particular condition may change in future versions
    of Oracle Rdb.

    The status values that are stored in the message vector are
    intended to be supplementary information to the status parameters
    SQLCODE and SQLSTATE. Use the sql_get_message_vector routine if
    the information provided by SQLCODE or SQLSTATE is ambiguous and
    your application needs a more specific error code to handle the
    error condition.

    Relationship Between sql_message_vector and RDB$MESSAGE_VECTOR
    shows the relationship between the indexes returned by sql_
    message_vector and the fields in RDB$MESSAGE_VECTOR.

    Table 1-1 Relationship Between sql_message_vector and
              RDB$MESSAGE_VECTOR

    sql_message_vector
    Indexes                     RDB$MESSAGE_VECTOR Fields

    Index 1                     RDB$LU_NUM_ARGUMENTS
    Index 2                     RDB$LU_STATUS
    Index 3                     RDB$LU_ARGUMENTS
    Index 4-20                  Return status for follow-on messages,
                                if any
Close Help