Download Informix CLI Programmer`s Manual, Version 2.5

Transcript
SQLTables
Type
Argument
Use
Description
SWORD
cbTableName
Input
Length of szTableName.
UCHAR FAR *
szTableType
Input
List of table types to match.
SWORD
cbTableType
Input
Length of szTableType.
(2 of 2)
Return Codes
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING,
SQL_ERROR or SQL_INVALID_HANDLE
Diagnostics
When SQLTables returns SQL_SUCCESS_WITH_INFO or SQL_ERROR, an
associated SQLSTATE value can be obtained by calling SQLError. The
following table lists the SQLSTATE values commonly returned by SQLTables
and explains each value in the context of this function; the notation “(DM)”
precedes the description of each SQLSTATE returned by the driver manager.
The return code associated with each SQLSTATE value is SQL_ERROR unless
noted otherwise.
SQLSTATE
Error
Description
01000
General warning
INFORMIX-CLI informational message
(Function returns SQL_SUCCESS_WITH_INFO.)
08S01
Communicationlink failure
The communication link between the driver
and the data source failed before the function
completed.
24000
Invalid cursor state
A cursor was already opened on the statement
handle.
S1000
General error
An error occurred for which no specific
SQLSTATE existed and for which no
implementation-specific SQLSTATE was
defined. The error message returned by
SQLError in the argument szErrorMsg
describes the error and its cause.
(1 of 2)
INFORMIX-CLI Function Reference 13-319