Home

	Expand Search

Open ClientConnect and Open ServerConnect Messages and Codes

Appendix A: Return Codes

Appendix A

This appendix describes the return codes that Gateway-Library returns to functions, indicating the result of the function's execution. These values are returned to the argument, RETCODE, which is the second argument of most Gateway-Library functions.

Some return codes are informational, such as TDS-RESULTS-COMPLETE. Others are warning or error codes, such as TDS-INVALID-PARAMETER. When the function executes as expected, the return code is TDS-OK.

Many return codes are function-specific and are returned to only one function. Others, such as TDS-OK, can be returned to many Gateway-Library functions.

Gateway-Library return codes all begin with TDS. Client-Library return codes begin with CS. However, on the mainframe, a few TDS return codes are returned to Client-Library functions. Some are returned to both Gateway-Library and Client-Library functions.

A list of all return codes, with their definition statements, is in the data set SYGWCOB or SYGWPLI, which is provided with the Open ServerConnect API tape.

The first set of lists¾one for informational messages, one for error and warning messages¾is in numeric order. An alphabetical list follows, with brief descriptions for each code.

Note: For PL/1, the return codes use underscores (_) instead of hyphens (-).

Numerical List of Return Codes

The following codes are informational and have positive values.

Table A-1: List of informational return codes in numerical order

0	TDS-OK
100	TDS-NO-ROW-PRESENT
101	TDS-NO-SQL-PRESENT
102	TDS-NO-MSG-PRESENT
103	TDS-NO-PARM-PRESENT
104	TDS-NO-ROWS-RETURNED
200	TDS-ROW-PRESENT
201	TDS-SQL-CMD-PRESENT
202	TDS-INFOMSG-PRESENT
203	TDS-PARM-PRESENT
204	TDS-STATUS-PRESENT
205	TDS-CURSOR-PRESENT
206	TDS-DYNAMIC-PRESENT
207	TDS-MSGID-PRESENT
208	TDS-COMPUTE-PRESENT
401	TDS-TAKE-SYNCPT
405	TDS-BACKED-OUT
500	TDS-RESULTS-COMPLETE

The following codes represent errors and have negative values.

Table A-2: List of error return codes in numeric order

-4	TDS-INVALID-PARAMETER
-5	TDS-ILLEGAL-REQUEST
-6	TDS-WRONG-STATE
-7	TDS-COMMAND-ACTIVE
-8	TDS-ENTRY-NOT-FOUND
-9	TDS-DUPLICATE-ENTRY
-10	TDS-INVALID-ID-VALUE
-11	TDS-STATUS-NOT-RECEIVED
-12	TDS-CANCEL-RECEIVED
-13	TDS-TRUNCATION-OCCURRED
-14	TDS-GWLIB-INTERNAL-ERROR
-15	TDS-GWLIB-UNAVAILABLE
-16	TDS-GWLIB-BAD-VERSION
-17	TDS-GWLIB-NO-STORAGE
-18	TDS-INVALID-TDPROC
-19	TDS-INVALID-IHANDLE
-20	TDS-TRUNCATION-ERROR
-21	TDS-FLOAT-CONVERSION-ERROR
-22	TDS-MONEY-CONVERSION-ERROR
-23	TDS-DATE-CONVERSION-ERROR
-24	TDS-DECIMAL-CONVERSION-ERROR
-25	TDS-GWLIB-FUNCTION-NOT-AVAILABLE
-26	TDS-OVERFLOW
-27	TDS-TRANSLATION-ERROR
-28	TDS-STRING-TOO-SMALL
-30	TDS-SERVER-NOT-FOUND
-31	TDS-CRTABLE-UNAVAILABLE
-32	TDS-NOT-INITIALIZED
-33	TDS-ROUTE-NOT-FOUND
-34	TDS-ROUTE-NOT-AVAILABLE
-39	TDS-EXCEED-MAX-CONN
-40	TDS-INVALID-CONHANDLE
-41	TDS-ADDR-CANNOT-BE-NULL
-42	TDS-BUF-TOO-SMALL
-43	TDS-CANNOT-SET-VALUE
-44	TDS-INVALID-ACTION
-45	TDS-INVALID-TERMINATOR
-49	TDS-RESULTS-CANCELED
-50	TDS-RESULTS-STILL-ACTIVE
-51	TDS-NO-BIND-ISSUED
-52	TDS-NO-NULLINDI-TRUNC
-53	TDS-NO-NULLINDI-NULLRCVD
-60	TDS-NO-COMPUTES-ALLOWED
-70	TDS-NOT-DECLARED
-71	TDS-CURSOR-ALREADY-DECLARED
-72	TDS-CURSOR-NOT-OPEN
-74	TDS-CURSOR-ALREADY-OPEN
-75	TDS-CURSOR-ALREADY-CLOSED
-76	TDS-CURSOR-ALREADY-DEALLOCATED
-77	TDS-CURSOR-NOT-FOUND
-78	TDS-INVALID-CURSOR-FSM
-79	TDS-INVALID-DYNSQL-FSM
-80	TDS-DYNSQL-NOT-PREPARED
-81	TDS-DYNSQL-ALREADY-PREPARED
-82	TDS-DYNSQL-PARMS-ALREADY-DEFINED
-83	TDS-DYNSQL-OUTPUT-DEFINED
-84	TDS-DYNSQL-ALREADY-DEALLOCATED
-85	TDS-DYNSQL-ID-NOT-FOUND
-86	TDS-DYNSQL-NO-STMT-GIVEN
-87	TDS-DYNSQL-IDLEN-TOO-LONG
-89	TDS-DYNSQL-STMT-NOT-FOUND
-171	TDS-INVALID-DATA-TYPE
-172	TDS-INVALID-DATA-CONVERSION
-173	TDS-INVALID-LENGTH
-174	TDS-INVALID-STATUS
-175	TDS-INVALID-VAR-ADDRESS
-176	TDS-INVALID-FLAGS
-177	TDS-INVALID-PRECISION
-178	TDS-INVALID-SCALE
-179	TDS-INVALID-NAMELENGTH
-180	TDS-INVALID-BOOLEAN
-181	TDS-INVALID-DATAFMT-VALUE
-182	TDS-INVALID-CURCLOSOPTION
-183	TDS-INVALID-CURDECLOPTION
-184	TDS-INVALID-CURDECLSTAT
-185	TDS-INVLID-CURINFSTAT
-186	TDS-INVALID-CURUPDSTAT
-187	TDS-INVALID-CUROPENSTAT
-188	TDS-INVALID-DYNSTAT
-189	TDS-INVALID-DYNTYPE
-190	TDS-CMD-NOT-GET-SET
-191	TDS-BUFFLEN-GREATER-TYPE
-192	TDS-BUFFLEN-LESS-TYPE
-193	TDS-INVALID-OP-TYPE
-194	TDS-INVALID-CURSOR-COMMAND
-195	TDS-INVALID-CURINFCMD
-196	TDS-INVALID-DYNSQL-COMMAND
-200	TDS-NO-CURRENT-CURSOR
-201	TDS-NO-CURRENT-DYNSQL
-256	TDS-MSG-SOS
-257	TDS-SOS
-258	TDS-LOG-ERROR
-259	TDS-INVALID-CONTEXT
-260	TDS-CONTROL-NOTLOADED
-261	TDS-CHARSET-NOTLOADED
-262	TDS-DEFAULT-CHARSET-NOTFOUND
-263	TDS-DBCS-CHARSET-NOTFOUND
-264	TDS-CHARSETSRV-NOT-SBCS
-265	TDS-SPA-NOT-SPECIFIED
-4990	TDS-INVALID-PROTOCOL
-4991	TDS-INVALID-STRMLENGTH
-4992	TDS-INVALID-NET-PROTOCOL
-4993	TDS-DRIVER-NOT-SET
-4995	TDS-LOGIN-FAILED
-4996	TDS-SERVER-RETURNED-ERROR
-4997	TDS-CONNECTION-TERMINATED
-4998	TDS-CONNECTION-FAILED

Alphabetical List of Return Codes

Note: Codes returned to Client-Library functions are marked with an asterisk.

TDS-ADDR-CANNOT-BE-NULL (-41)

One or more parameters passed on an API call are null and should not be.

TDS-BACKED-OUT (405)

Rollback successfully performed.

TDS-BUFFLEN-GREATER-TYPE (-191)

TDYNAMIC: The size of the buffer is greater than the dynamic SQL-type field being retrieved.

TDS-BUFFLEN-LESS-TYPE (-192)

TDYNAMIC: The size of the buffer is too small to return a Dynamic SQL-type field.

TDS-BUF-TOO-SMALL (-42)

Buffer too small. The information being retrieved cannot fit in the buffer.

*TDS-CANCEL-RECEIVED (-12)

Operation canceled. The remote partner issued a cancel. The current operation failed.

This code is also returned to the Client-Library function CTBDESCRIBE.

*TDS-CANNOT-SET-VALUE (-43)

The transaction can only retrieve this value; it cannot set the value of this property.

This code is also returned to the Client-Library functions CTBCMDPROPS and CTBCONPROPS.

TDS-CHARSET-NOTLOADED (-261)

Gateway-Library found the double-byte character set specified by the client, but the corresponding double-byte module was not loaded at the mainframe.

This code is returned to TDACCEPT when a client specifies a double-byte character set (for example, Shift-JIS) for which the associated translate module was not loaded or defined to the mainframe system.

If the TP system is CICS, this can mean that the translate module was not defined in RDO (or to the PPT table), or that it is not present in the LOADLIB.

TDS-CHARSETSRV-NOT-SBCS (-264)

Client's character set was not found; double-byte character set specified as default.

This code represents two problems:

• The character set named in the client's login packet was not found in the table of character set names.

  This may indicate that the client did not specify the character set correctly (for example, the -J option in isql or the dbsetlcharset value in a DB-Library program is invalid).

• Open ServerConnect was customized to process single-byte character sets, but the default character set is double-byte.

  This usually indicates that the customization settings are incorrect for kanji support.

TDS-CMD-NOT-GET-SET (-190)

The value of the ACTION parameter is invalid. It should be either TDS-GET or TDS-SET.

*TDS-COMMAND-ACTIVE (-7)

A command is in progress. The current function cannot be called after a command is sent to a server.

This function is returned to the Client-Library functions CTBCLOSE and CTBCMDDROP.

TDS-COMPUTE-PRESENT (-208)

There are computes present for this transaction.

TDS-CONNECTION-FAILED (-4998)

Connection abended. The client/server connection abnormally ended (for example, the LU6.2 session crashed or the remote transaction abended).

This code can also be returned to the Client-Library function CTBRESULTS.

*TDS-CONNECTION-TERMINATED (-4997)

Connection closed. The remote partner closed (deallocated) the client/server connection.

This code can be returned to many Client-Library functions.

TDS-CONTROL-NOTLOADED (-260)

Cannot load the customization module. This module is necessary for Gateway-Library operation.

*TDS-CRTABLE-UNAVAILABLE (-31)

The Connection Router table cannot be loaded.

This function is returned to the Client-Library function CTBCONNECT.

TDS-CURSOR-ALREADY-CLOSED (-75)

Cursor is closed. You cannot fetch, update, or delete when the cursor is closed.

TDS-CURSOR-ALREADY-DEALLOCATED (-76)

Cursor is deallocated. You cannot deallocate the same cursor more than once.

TDS-CURSOR-ALREADY-DECLARED (-71)

Cursor is declared. You cannot declare the same cursor more than once.

TDS-CURSOR-ALREADY-OPEN (-74)

Cursor already open. You cannot open the same cursor more than once.

TDS-CURSOR-NOT-DECLARED (-70)

A cursor must be declared before it can be opened.

TDS-CURSOR-NOT-FOUND (-77)

Cursor not found.

TDS-CURSOR-NOT-OPEN (-72)

Cursor not open. A cursor must be open before a fetch, close, delete, or update.

TDS-CURSOR-PRESENT (205)

There are cursors present for this transaction.

TDS-DATE-CONVERSION-ERROR (-23)

Error in conversion of datetime data.

This may be a result of trying to convert to short datetime (TDSDATETIME4) for a client using an early TDS version. TDS versions earlier than 4.2 do not support the short datetime datatype.

TDS-DBCS-CHARSET-NOTFOUND (-263)

Gateway-Library could not find the double-byte character set specified in the client login packet.

This usually indicates that the client request specified an invalid character set in, for example, the -J option in isql or the dbsetlcharset value in a DB-Library program.

TDS-DECIMAL-CONVERSION-ERROR (-24)

Error in conversion of packed decimal data.

TDS-DEFAULT-CHARSET-NOTFOUND (-262)

The client login packet did not specify a character set or the specified client character set could not be found, and Gateway-Library did not find the default. (This code is returned for single-byte character sets only.)

TDS-DRIVER-NOT-SET (-4993)

Invalid network driver.

TDS-DUPLICATE-ENTRY (-9)

Duplicate column description. You attempted to describe the same column twice with a TDESCRIB statement. The operation failed.

TDS-DYNAMIC-PRESENT (206)

There are dynamic SQL requests present for this transaction.

TDS-DYNSQL-ALREADY-DEALLOCATED (-84)

dynamic SQL request that is already allocated.

TDS-DYNSQL-ALREADY-PREPARED (-81)

Dynamic SQL request already prepared. You cannot prepare a dynamic SQL request that is already deallocated.

TDS-DYNSQL-ID-NOT-FOUND (-85)

Dynamic SQL request not found.

TDS-DYNSQL-IDLEN-TOO-LONG (-87)

Dynamic SQL request ID length is greater than 255.

TDS-DYNSQL-NO-STMT-GIVEN (-86)

There is not a SQL statement associated with the dynamic SQL request.

TDS-DYNSQL-NOT-PREPARED (-80)

A dynamic SQL request is not prepared.

TDS-DYNSQL-OUTPUT-ALREADY-DEFINED (-83)

Dynamic SQL output already defined. You cannot define Dynamic SQL output more than once.

TDS-DYNSQL-PARMS-ALREADY-DEFINED (-82)

Dynamic SQL parameters already defined. You cannot define dynamic SQL parameters more than once.

TDS-DYNSQL-STMT-NOT-FOUND (-89)

There is no SQL statement associated with the dynamic SQL request.

TDS-ENTRY-NOT-FOUND (-8)

The specified column number, transaction number, or parameter does not exist.

TDS-EXCEED-MAX-CON (-39)

The maximum number of connections are already open.

TDS-FLOAT-CONVERSION-ERROR (-21)

Error in conversion of float values.

TDS-GWLIB-BAD-VERSION (-16)

The program version you are using is newer than the version of the Gateway-Library phase in use.

*TDS-GWLIB-FUNCTION-NOT-AVAILABLE (-25)

The application calls a Client-Library function that is not supported by Open ClientConnect. Check the code to be sure all functions called are included in the Open ServerConnect Programmer's Reference.

TDS-GWLIB-INTERNAL-ERROR (-14)

Gateway-Library crashed.

*TDS-GWLIB-NO-STORAGE (-17)

Could not get DSA for Gateway-Library.

This function is returned to the Client-Library functions CTBCONALLOC and CSBCTXALLOC.

TDS-GWLIB-UNAVAILABLE (-15)

Could not load SYGWCICS (the Gateway-Library phase).

TDS-ILLEGAL-REQUEST (-5)

Illegal function. The operation failed.

This code can indicate that a client application is trying to use a Gateway-Library function that is not supported for clients (for example, TDSNDROW).

TDS-INFOMSG-PRESENT (202)

There is a server or client message associated with the results of the last request.

TDS-INVALID-ACTION (-44)

The action was not CS-GET or CS-SET.

TDS-INVALID-BOOLEAN (-180)

Invalid Boolean value. Boolean values must be set to either CS-TRUE or CS-FALSE.

TDS-INVALID-CONHANDLE (-40)

Invalid connection handle address specified.

TDS-INVALID-CONTEXT (-259)

Invalid context handle address specified.

TDS-INVALID-CURCLOSOPTION (-182)

A "closed" cursor command specified an invalid option.

The Gateway-Library transaction received a "closed" cursor command, but the value of the OPTION field of the TDS-CURDESC structure is invalid. Valid options are TDS-CUR-UNUSED and TDS-CUR-DEALLOC.

TDS-INVALID-CURDECLOPTION (-183)

A declare cursor command has an invalid option specified.

The Gateway-Library transaction received a declare cursor command, but the value of the OPTION field of the TDS-CURDESC structure is invalid. Valid options are TDS-CUR-UNUSED and TDS-CUR-DEALLOC.

TDS-INVALID-CURDECLSTAT (-184)

Illegal cursor declare option.

TDS-INVALID-CURINFCMD (-195)

Illegal cursor information command.

TDS-INVALID-CURINSTAT (-185)

Illegal cursor information status.

TDS-INVALID-CUROPENSTAT (-187)

Illegal cursor open status.

TDS-INVALID-CURSOR-COMMAND (-194)

The cursor command is not declare, open, fetch, delete, update, or close.

TDS-INVALID-CURSOR-FSM (-78)

Invalid cursor state.

TDS-INVALID-CURUPDSTAT (-186)

Illegal cursor update status.

TDS-INVALID-DATA-CONVERSION (-172)

Incompatible datatypes. The source datatype cannot be converted into the requested result datatype.

TDS-INVALID-DATA-TYPE (-171)

Illegal datatype. A Sybase datatype supplied in the call is not supported, and the conversion cannot be done. The operation failed.

TDS-INVALID-DATAFMT-VALUE (-181)

One or more values specified for fields in the DATAFMT structure are illegal.

This code is returned to Client-Library functions that use the Open Client DATAFMT structure: CTBBIND, CTBDESCRIBE, CTBPARARM, and CSBCONVERT.

TDS-INVALID-DYNSQL-COMMAND (-196)

Invalid dynamic SQL command. The dynamic SQL command must be prepare, exec, deallocate, descin, descount, or ack.

TDS-INVALID-DYNSQL-FSM (-79)

Dynamic SQL request in invalid state.

TDS-INVALID-DYNSTAT (-188)

Invalid status for dynamic SQL request.

TDS-INVALID-DYNTYPE (-189)

Invalid type for dynamic SQL request.

TDS-INVALID-FLAGS (-176)

Invalid padding option for a field.

TDS-INVALID-ID-VALUE (-10)

The specified column or parameter number is greater than the system maximum. You can have as many columns per table result and parameters per RPC as Open Server allows.

TDS-INVALID-IHANDLE (-19)

Invalid IHANDLE specification. Error in specifying a value for the IHANDLE argument.

TDS-INVALID-LENGTH (-173)

Wrong length. The length specified in the xxx-LENGTH argument is too long.

*TDS-INVALID-NAMELENGTH (-179)

Invalid name length. The length specified for the column, parameter, message, or server name is invalid.

This code is also returned to the Client-Library function CTBCONNECT (length of specified server name is invalid).

TDS-INVALID-NET-PROTOCOL (-4992)

Invalid network protocol.

TDS-INVALID-OP-TYPE (-193)

Invalid Dynamic SQL operation.

*TDS-INVALID-PARAMETER (-4)

Invalid parameter value. The value assigned to one or more of the arguments supplied in the call is not valid. The operation failed.

This code is also returned to many Client-Library functions.

TDS-INVALID-PRECISION (-177)

Invalid precision value. The precision value specified during conversion of TDS-PACKED-DECIMAL data is invalid.

TDS-INVALID-PROTOCOL (-4990)

Invalid TDS protocol received.

TDS-INVALID-SCALE (-178)

Invalid scale value. The scale value specified during conversion of TDS-PACKED-DECIMAL data is invalid.

TDS-INVALID-STATUS (-174)

Invalid status value. The value entered in the STATUS field is invalid.

TDS-INVALID-STRMLENGTH (-4991)

Invalid TDS data stream length received, or invalid TDS data stream length specified.

*TDS-INVALID-TDPROC (-18)

Error in specifying a value for the TDPROC argument.

This code can also be returned to the Client-Library function CTBCANCEL.

TDS-INVALID-TERMINATOR (-45)

Invalid terminator. The Terminator assigned to one or more parameters is not valid.

*TDS-INVALID-VAR-ADDRESS (-175)

Specified variable address is invalid. No variable with the specified name exists. A NULL value was specified. The operation failed.

This code can also be returned to the Client-Library functions CTBBIND and CTBCONVERT.

TDS-LOG-ERROR (-258)

Attempt to write to the log file failed.

TDS-LOGIN-FAILED (-4995)

Gateway-less login was rejected, check validity of userid/password.

TDS-MONEY-CONVERSION-ERROR (-22)

Error in conversion of TDSMONEY-type data.

This might be a result of trying to convert to short money (TDSMONEY4) for a client using an early TDS version. TDS versions earlier than 4.2 do not support the short money datatype.

*TDS-MSG-SOS (-256)

Memory shortage. Not enough memory is available to save messages. All messages stored previously were cleared.

This code can also be returned to the Client-Library function CTBDIAG.

TDS-MSGID-PRESENT (207)

The transaction has an outstanding server or client message.

TDS-NO-BIND-ISSUED (-51)

No bind issued. A bind is missing for the specified column.

*TDS-NO-COMPUTES-ALLOWED (-60)

Compute results are not supported by Open ClientConnect.

This code is returned to the Client-Library functions CTBBIND and CTBDESCRIBE.

TDS-NO-CURRENT-CURSOR (-200)

There is no cursor associated with the current transaction.

TDS-NO-CURRENT-DYNSQL (-201)

There is no dynamic SQL request associated with the current transaction.

TDS-NO-MSG-PRESENT (102)

There are no messages associated with the current transaction.

TDS-NO-NULLINDI-TRUNC (-52)

No null indicator. The data for the column is truncated, but no indicator is available.

TDS-NO-NULLINDI-NULLRCVD (-53)

No null indicator. The data for the column is NULL, but no indicator is available.

TDS-NO-PARM-PRESENT (103)

No incoming parameters present. TDRCVPRM cannot retrieve a parameter because no additional parameters were received. The operation failed.

TDS-NO-ROW-PRESENT (100)

There are no more rows in the current result set.

TDS-NO-ROWS-RETURNED (104)

There are no rows returned in the current result set. No rows were affected.

TDS-NO-SQL-PRESENT (101)

No incoming language string present. TDRCVSQL cannot retrieve more text because no more text was accepted. The operation failed.

*TDS-NOT-INITIALIZED (-32)

The Connection Router is not initialized.

This code is returned to the Client-Library function CTBCONNECT.

TDS-OK (0)

Function completed successfully.

TDS-OVERFLOW (-26)

Numeric/decimal conversion failed.

TDS-PARM-PRESENT (203)

Parameter value received. A parameter was received from the remote client. This value is returned to TDRESULT when a parameter is accepted by a server program and is ready to be retrieved.

*TDS-RESULTS-CANCELED (-49)

The result set was purged. The transaction may have called a routine that expects the wrong communication state.

This code is returned to the Client-Library functions CTBBIND and CTBDESCRIBE.

TDS-RESULTS-COMPLETE (500)

TDRESULT indicated no more results. No more language text, RPC parameters, cancel requests, or messages were retrieved.

*TDS-RESULTS-STILL-ACTIVE (-50)

Results in progress. More results pending.

This code can be returned to CTBCMDDROP (cannot drop until all results process) and CTBEXIT (cannot close connection until all results process, unless OPTION is CS_FORCE_EXIT).

This code is returned to the Client-Library functions CTBCLOSE, CTBCONDROP, CTBCMDDROP and CTBEXIT.

*TDS-ROUTE-NOT-AVAILABLE (-34)

Request route is not available. All paths are in use.

This code is returned to the Client-Library function CTBCONNECT.

*TDS-ROUTE-NOT-FOUND (-33)

The requested route is not defined to the Connection Router.

This code is returned to the Client-Library function CTBCONNECT.

TDS-ROW-PRESENT (200)

Rows were returned in the current result set.

*TDS-SERVER-NOT-FOUND (-30)

The requested server is not defined to the Connection Router.

This code is returned to the Client-Library function CTBCONNECT.

TDS-SERVER-RETURNED-ERROR (-4996)

There is an error in the results sent by the server.

*TDS-SOS (-257)

Memory shortage. The host subsystem was unable to allocate enough memory for the control block that Gateway-Library was trying to create. The operation failed.

This code is returned to both Client-Library functions and Gateway-Library functions.

TDS-SPA-NOT-SPECIFIED (-265)

There is no scratch pad area designated for the IMS Conv Program.

TDS-SQL-CMD-PRESENT (201)

Language string received. A language request was received from a remote client. This value is returned to TDRESULT when a language string is accepted by a server program and is ready for retrieval.

TDS-STRING-TOO-SMALL (-28)

Numeric or decimal to character conversion failed. Output length of character string too small.

TDS-STATUS-NOT-RECEIVED (-11)

No status returned from client. No RETURN-STATUS-NUMBER is available because the server did not yet send the status back to the client.

TDS-STATUS-PRESENT (204)

A status was returned from the client.

TDS-TAKE-SYNCPT (401)

Sync point was successfully performed.

*TDS-TRANSLATION-ERROR (-27)

Application could not translate a character code or user-defined character.

This code is returned to the Client-Library function CTBFETCH.

TDS-TRUNCATION-ERROR (-20)

Error occurred in truncation of data value.

TDS-TRUNCATION-OCCURRED (-13)

Data was truncated. The actual data length was longer than the maximum data length allotted for this data.

TDS-WRONG-STATE (-6)

The function cannot be used in the current communication state. For example, your program tried to send a reply before it read in all of the client's parameters. The application was still in RECEIVE state and could not send. The operation failed.

This code can be returned to both Gateway-Library and Client-Library functions.