Home | Previous Page | Next Page   Error Messages > Mapping Informix Error Messages to SQLSTATE Values >

SQLNativeSql (Level Two Only)

SQLNativeSql returns the SQL string that the driver translates.

The following table describes the SQLSTATE and error values for SQLNativeSql.

SQLSTATE Error Value Error Message
01000 -11001 General warning
01004 -11003 Data truncated
08003 -11017 Connection not open
37000 -11035 Syntax error or access violation
S1000 -11060 General error
S1001 -11061 Memory-allocation failure
S1009 -11066 Invalid argument value
S1090 -11071 Invalid string or buffer length
S1000 -11320 Syntax error
S1000 -11323 The statement contains an escape clause not supported by this database driver

Usage

The following example shows what SQLNativeSql might return for an input SQL string that contains the scalar function LENGTH:

SELECT {fn LENGTH(NAME)} FROM EMPLOYEE 
Dynamic Server

Dynamic Server might return the following translated SQL string:

SELECT length(NAME) FROM EMPLOYEE 
End of Dynamic Server
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]