The following tables lists the ODBC API return codes for calls that execute SQL statements performing builds of user-defined functions:
| Return Code | Description |
|---|---|
| SQL_SUCCESS_WITH_INFO | The build of the UDF was performed on the database and the UDF was created successfully. The output should be examined for possible warnings in the build of the UDF. |
| SQL_ERROR | The build of the UDF failed on the database and the UDF was not created. |
In both cases, the output from the build is available to the client as a sequence of diagnostic status records that may be retrieved using SQLGetDiagRecord() and SQLGetDiagField().
The first diagnostic record contains the status of the UDF creation from the database.
The subsequent diagnostic records contain all output from the build as message texts and repeat the SQLSTATE and native error code from the first record.