Can anyone tell me where to locate a list of valid return codes that may be returned by &RETCODE?

Please give more detail of what you are trying to do. PS What product version is always helpful in requests.

I'm trying to find a list of all possible return codes within WebFOCUS 5.2.5 so I can code for all eventualities....

What brought this on was that I am trying to capture all possible return codes related to authenticating to the server. I know -17 is invalid user id or password, -20 is expired password and I think -13 is no access to required resources. However I would like to know everything related to security and everything else for that matter. TIA for you help....

Here you go

INVALID_EID -1 /* Invalid context */
TOO_MANY_CONTEXTS -2 /* Too many iWay contexts */
INVALID_SID -3 /* Invalid sid */
TOO_MANY_SCBS -4 /* Too many scbs allocated */
SCB_NOT_INIT -5 /* The scb is not initialized */
SCB_INIT -6 /* The scb is initialized */
INIT_EDANET_ERROR -7 /* Cannot initialize EDALINK */
CLOSE_EDANET_ERROR -8 /* Cannot close down EDALINK */
CONNECT_ERROR -9 /* Error connecting to server */
DISCONNECT_ERROR -10 /* Error disconnecting from server */
DATA_SEND_ERROR -11 /* Error sending data to server */
DATA_RECEIVE_ERROR -12 /* Error receiving data */
INVALID_OPERATION -13 /* Operation not permitted */
MEMORY_OVERFLOW -14 /* Insufficient memory available */
BAD_PARM_VAL -15 /* Invalid parameter value */
TUPLE_MISALIGNED -16 /* Tuple alignment error */
ACCESS_DENIED -17 /* Userid/Password invalid */
INTERNAL_API_ERROR -18 /* Unexplained internal error */
UNAVAILABLE_FUNCTION -19 /* Not supported at this API level */
PASSWORD_EXPIRED -20
INVALID_NEW_PASSWORD -21
ENCRYPTION_VERSION_MISMATCH -22
CONNECTION_NO_LONGER_VALID -23
INVALID_CODE_PAGE -24
EXECUTE_NOT_PREPARED -25
INVALID_SERVER -26/* EDACONNECT to unknown server */
INVALID_STATEMENT -27 /* SERVER rejected statement */
INVALID_MSG_UOW -28
INVALID_MSG_ATT -29
INVALID_PROTOCOL -30
INVALID_MSG_COMMITERR -31
USERID_IN_USE -32
RESOURCE_LIMIT -33
COMM_TIMEOUT -34 /* communications timed out */
BAD_USERID -35 /* security violation */
REVOKED_USERID -36 /* security violation */
SRV_COMM_FAIL -37 /* server reports comm error */
INVALID_LICENSE -38 /* server reports invl. license */


This may not be all

Thanks...

and the ever popular &RETCODE = 0
which means its perfect.

There are also positive values for &RETCODE.

In the online help it says if the procedure results in normal output or no records are retrieved, the value of &RETCODE is 1. If an error occurs while parsing the procedure, the value of &RETCODE is 8.