Difference between revisions of "SQLSTATE Constants"
From MidrangeWiki
| Line 1: | Line 1: | ||
Here is a work-in-progress list of constant names for the SQLSTATE codes in RPG. | Here is a work-in-progress list of constant names for the SQLSTATE codes in RPG. | ||
| − | + | <pre> | |
| − | D | + | D*? General Constants |
| − | D | + | D SQL_FALSE C 0 |
| − | D | + | D SQL_TRUE C 1 |
| + | D SQL_NTS C -3 | ||
| + | D SQL_STATE_SIZE C 5 | ||
| + | D SQL_MAX_MESSAGE_LENGTH... | ||
| + | D C 512 | ||
| + | D*? | ||
| + | D*? Return Code Values | ||
| + | D SQL_SUCCESS C 0 | ||
| + | D SQL_SUCCESS_WITH_INFO... | ||
| + | D C 1 | ||
| + | D SQL_NO_DATA_FOUND... | ||
| + | D C 100 | ||
| + | D SQL_NEED_DATA C 99 | ||
| + | D SQL_NO_DATA C 100 | ||
| + | D SQL_ERROR C -1 | ||
| + | D SQL_INVALID_HANDLE... | ||
| + | D C -2 | ||
| + | D*? | ||
| + | D*? Standard SQL data types | ||
| + | D SQL_ALL_TYPES C 0 | ||
| + | D SQL_CHAR C 1 | ||
| + | D SQL_NUMERIC C 2 | ||
| + | D SQL_DECIMAL C 3 | ||
| + | D SQL_INTEGER C 4 | ||
| + | D SQL_SMALLINT C 5 | ||
| + | D SQL_FLOAT C 6 | ||
| + | D SQL_REAL C 7 | ||
| + | D SQL_DOUBLE C 8 | ||
| + | D SQL_DATETIME C 9 | ||
| + | D SQL_VARCHAR C 12 | ||
| + | D SQL_LONGVARCHAR... | ||
| + | D C 12 | ||
| + | D SQL_BLOB C 13 | ||
| + | D SQL_CLOB C 14 | ||
| + | D SQL_DBCLOB C 15 | ||
| + | D SQL_DATALINK C 16 | ||
| + | D SQL_WCHAR C 17 | ||
| + | D SQL_WVARCHAR C 18 | ||
| + | D SQL_WLONGVARCHAR... | ||
| + | D C 18 | ||
| + | D SQL_BIGINT C 19 | ||
| + | D SQL_BLOB_LOCATOR... | ||
| + | D C 20 | ||
| + | D SQL_CLOB_LOCATOR... | ||
| + | D C 21 | ||
| + | D SQL_DBCLOB_LOCATOR... | ||
| + | D C 22 | ||
| + | D SQL_DATE C 91 | ||
| + | D SQL_TYPE_DATE C 91 | ||
| + | D SQL_CODE_DATE C 1 | ||
| + | D SQL_TIME C 92 | ||
| + | D SQL_TYPE_TIME C 92 | ||
| + | D SQL_CODE_TIME C 2 | ||
| + | D SQL_TIMESTAMP C 93 | ||
| + | D SQL_TYPE_TIMESTAMP... | ||
| + | D C 93 | ||
| + | D SQL_CODE_TIMESTAMP... | ||
| + | D C 3 | ||
| + | D SQL_GRAPHIC C 95 | ||
| + | D SQL_VARGRAPHIC C 96 | ||
| + | D SQL_LONGVARGRAPHIC... | ||
| + | D C 96 | ||
| + | D SQL_BINARY C 97 | ||
| + | D SQL_VARBINARY C 98 | ||
| + | D SQL_LONGVARBINARY... | ||
| + | D C 98 | ||
| + | D*? | ||
| + | D*? Valid values for type in GetCol and BindToCol | ||
| + | D SQL_DEFAULT C 99 | ||
| + | D SQL_ARD_TYPE C -99 | ||
| + | D*? | ||
| + | D*? Null status defines | ||
| + | D SQL_UNUSED C 0 | ||
| + | D SQL_HANDLE_ENV C 1 | ||
| + | D SQL_HANDLE_DBC C 2 | ||
| + | D SQL_HANDLE_STMT... | ||
| + | D C 3 | ||
| + | D SQL_HANDLE_DESC... | ||
| + | D C 4 | ||
| + | D SQL_NULL_HANDLE... | ||
| + | D C 0 | ||
| + | D SQL_NO_NULLS C 0 | ||
| + | D SQL_NULLABLE C 1 | ||
| + | D SQL_NULLABLE_UNKNOWN... | ||
| + | D C 2 | ||
| + | D*? | ||
| + | D*? Special length values | ||
| + | D SQL_NULL_DATA C -1 | ||
| + | D SQL_DATA_AT_EXEC... | ||
| + | D C -2 | ||
| + | D SQL_BIGINT_PREC... | ||
| + | D C 19 | ||
| + | D SQL_INTEGER_PREC... | ||
| + | D C 10 | ||
| + | D SQL_SMALLINT_PREC... | ||
| + | D C 5 | ||
| + | D*? | ||
| + | D*? Valid environment attributes | ||
| + | D SQL_ATTR_OUTPUT_NTS... | ||
| + | D C 10001 | ||
| + | D SQL_ATTR_SYS_NAMING... | ||
| + | D C 10002 | ||
| + | D SQL_ATTR_DEFAULT_LIB... | ||
| + | D C 10003 | ||
| + | D SQL_ATTR_SERVER_MODE... | ||
| + | D C 10004 | ||
| + | D SQL_ATTR_JOB_SORT_SEQUENCE... | ||
| + | D C 10005 | ||
| + | D SQL_ATTR_ENVHNDL_COUNTER... | ||
| + | D C 10009 | ||
| + | D SQL_ATTR_ESCAPE_CHAR... | ||
| + | D C 10010 | ||
| + | D*? | ||
| + | D*? Valid environment/connection attributes | ||
| + | D SQL_ATTR_DATE_FMT... | ||
| + | D C 10020 | ||
| + | D SQL_ATTR_DATE_SEP... | ||
| + | D C 10021 | ||
| + | D SQL_ATTR_TIME_FMT... | ||
| + | D C 10022 | ||
| + | D SQL_ATTR_TIME_SEP... | ||
| + | D C 10023 | ||
| + | D SQL_ATTR_DECIMAL_SEP... | ||
| + | D C 10024 | ||
| + | D*? | ||
| + | D*? Valid environment/connection attributes | ||
| + | D SQL_FMT_ISO C 1 | ||
| + | D SQL_FMT_USA C 2 | ||
| + | D SQL_FMT_EUR C 3 | ||
| + | D SQL_FMT_JIS C 4 | ||
| + | D SQL_FMT_MDY C 5 | ||
| + | D SQL_FMT_DMY C 6 | ||
| + | D SQL_FMT_YMD C 7 | ||
| + | D SQL_FMT_JUL C 8 | ||
| + | D SQL_FMT_HMS C 9 | ||
| + | D SQL_FMT_JOB C 10 | ||
| + | D SQL_SEP_SLASH C 1 | ||
| + | D SQL_SEP_DASH C 2 | ||
| + | D SQL_SEP_PERIOD C 3 | ||
| + | D SQL_SEP_COMMA C 4 | ||
| + | D SQL_SEP_BLANK C 5 | ||
| + | D SQL_SEP_COLON C 6 | ||
| + | D SQL_SEP_JOB C 7 | ||
| + | D*? | ||
| + | D*? Connection attributes | ||
| + | D SQL_ATTR_AUTO_IPD... | ||
| + | D C 10001 | ||
| + | D SQL_ATTR_ACCESS_MODE... | ||
| + | D C 10002 | ||
| + | D SQL_ACCESS_MODE... | ||
| + | D C 10002 | ||
| + | D SQL_ATTR_AUTOCOMMIT... | ||
| + | D C 10003 | ||
| + | D SQL_AUTOCOMMIT... | ||
| + | D C 10003 | ||
| + | D SQL_ATTR_DBC_SYS_NAMING... | ||
| + | D C 10004 | ||
| + | D SQL_ATTR_DBC_DEFAULT_LIBRARY... | ||
| + | D C 10005 | ||
| + | D SQL_ATTR_COMMIT... | ||
| + | D C 0 | ||
| + | D SQL_MODE_READ_ONLY... | ||
| + | D C 0 | ||
| + | D SQL_AUTOCOMMIT_OFF... | ||
| + | D C 0 | ||
| + | D SQL_TXN_ISOLATION... | ||
| + | D C 0 | ||
| + | D SQL_MODE_READ_WRITE... | ||
| + | D C 1 | ||
| + | D SQL_MODE_DEFAULT... | ||
| + | D C 1 | ||
| + | D SQL_AUTOCOMMIT_ON... | ||
| + | D C 1 | ||
| + | D SQL_COMMIT_NONE... | ||
| + | D C 1 | ||
| + | D SQL_TXN_NO_COMMIT... | ||
| + | D C 1 | ||
| + | D SQL_TXN_NOCOMMIT... | ||
| + | D C 1 | ||
| + | D SQL_COMMIT_CHG... | ||
| + | D C 2 | ||
| + | D SQL_COMMIT_UR... | ||
| + | D C 2 | ||
| + | D SQL_TXN_READ_UNCOMMITED... | ||
| + | D C 2 | ||
| + | D SQL_COMMIT_CS... | ||
| + | D C 3 | ||
| + | D SQL_TXN_READ_COMMITED... | ||
| + | D C 3 | ||
| + | D SQL_COMMIT_ALL... | ||
| + | D C 4 | ||
| + | D SQL_COMMIT_RS... | ||
| + | D C 4 | ||
| + | D SQL_TXN_REPEATABLE_READ... | ||
| + | D C 4 | ||
| + | D SQL_COMMIT_RR... | ||
| + | D C 5 | ||
| + | D SQL_TXN_SERIALIZABLE... | ||
| + | D C 5 | ||
| + | D*? | ||
| + | D*? Statement attributes | ||
| + | D SQL_ATTR_APP_ROW_DESC... | ||
| + | D C 10010 | ||
| + | D SQL_ATTR_APP_PARAM_DESC... | ||
| + | D C 10011 | ||
| + | D SQL_ATTR_IMP_ROW_DESC... | ||
| + | D C 10012 | ||
| + | D SQL_ATTR_IMP_PARAM_DESC... | ||
| + | D C 10013 | ||
| + | D SQL_ATTR_FOR_FETCH_ONLY... | ||
| + | D C 10014 | ||
| + | D SQL_ATTR_CONCURRENCY... | ||
| + | D C 10014 | ||
| + | D SQL_CONCURRENCY... | ||
| + | D C 10014 | ||
| + | D SQL_ATTR_CURSOR_SCROLLABLE... | ||
| + | D C 10015 | ||
| + | D SQL_ATTR_ROWSET_SIZE... | ||
| + | D C 10016 | ||
| + | D SQL_ROWSET_SIZE... | ||
| + | D C 10016 | ||
| + | D*? | ||
| + | D*? Null handles | ||
| + | D SQL_NULL_HENV C 0 | ||
| + | D SQL_NULL_HDBC C 0 | ||
| + | D SQL_NULL_HSTMT C 0 | ||
| + | </pre> | ||
Revision as of 22:29, 7 June 2005
Here is a work-in-progress list of constant names for the SQLSTATE codes in RPG.
D*? General Constants
D SQL_FALSE C 0
D SQL_TRUE C 1
D SQL_NTS C -3
D SQL_STATE_SIZE C 5
D SQL_MAX_MESSAGE_LENGTH...
D C 512
D*?
D*? Return Code Values
D SQL_SUCCESS C 0
D SQL_SUCCESS_WITH_INFO...
D C 1
D SQL_NO_DATA_FOUND...
D C 100
D SQL_NEED_DATA C 99
D SQL_NO_DATA C 100
D SQL_ERROR C -1
D SQL_INVALID_HANDLE...
D C -2
D*?
D*? Standard SQL data types
D SQL_ALL_TYPES C 0
D SQL_CHAR C 1
D SQL_NUMERIC C 2
D SQL_DECIMAL C 3
D SQL_INTEGER C 4
D SQL_SMALLINT C 5
D SQL_FLOAT C 6
D SQL_REAL C 7
D SQL_DOUBLE C 8
D SQL_DATETIME C 9
D SQL_VARCHAR C 12
D SQL_LONGVARCHAR...
D C 12
D SQL_BLOB C 13
D SQL_CLOB C 14
D SQL_DBCLOB C 15
D SQL_DATALINK C 16
D SQL_WCHAR C 17
D SQL_WVARCHAR C 18
D SQL_WLONGVARCHAR...
D C 18
D SQL_BIGINT C 19
D SQL_BLOB_LOCATOR...
D C 20
D SQL_CLOB_LOCATOR...
D C 21
D SQL_DBCLOB_LOCATOR...
D C 22
D SQL_DATE C 91
D SQL_TYPE_DATE C 91
D SQL_CODE_DATE C 1
D SQL_TIME C 92
D SQL_TYPE_TIME C 92
D SQL_CODE_TIME C 2
D SQL_TIMESTAMP C 93
D SQL_TYPE_TIMESTAMP...
D C 93
D SQL_CODE_TIMESTAMP...
D C 3
D SQL_GRAPHIC C 95
D SQL_VARGRAPHIC C 96
D SQL_LONGVARGRAPHIC...
D C 96
D SQL_BINARY C 97
D SQL_VARBINARY C 98
D SQL_LONGVARBINARY...
D C 98
D*?
D*? Valid values for type in GetCol and BindToCol
D SQL_DEFAULT C 99
D SQL_ARD_TYPE C -99
D*?
D*? Null status defines
D SQL_UNUSED C 0
D SQL_HANDLE_ENV C 1
D SQL_HANDLE_DBC C 2
D SQL_HANDLE_STMT...
D C 3
D SQL_HANDLE_DESC...
D C 4
D SQL_NULL_HANDLE...
D C 0
D SQL_NO_NULLS C 0
D SQL_NULLABLE C 1
D SQL_NULLABLE_UNKNOWN...
D C 2
D*?
D*? Special length values
D SQL_NULL_DATA C -1
D SQL_DATA_AT_EXEC...
D C -2
D SQL_BIGINT_PREC...
D C 19
D SQL_INTEGER_PREC...
D C 10
D SQL_SMALLINT_PREC...
D C 5
D*?
D*? Valid environment attributes
D SQL_ATTR_OUTPUT_NTS...
D C 10001
D SQL_ATTR_SYS_NAMING...
D C 10002
D SQL_ATTR_DEFAULT_LIB...
D C 10003
D SQL_ATTR_SERVER_MODE...
D C 10004
D SQL_ATTR_JOB_SORT_SEQUENCE...
D C 10005
D SQL_ATTR_ENVHNDL_COUNTER...
D C 10009
D SQL_ATTR_ESCAPE_CHAR...
D C 10010
D*?
D*? Valid environment/connection attributes
D SQL_ATTR_DATE_FMT...
D C 10020
D SQL_ATTR_DATE_SEP...
D C 10021
D SQL_ATTR_TIME_FMT...
D C 10022
D SQL_ATTR_TIME_SEP...
D C 10023
D SQL_ATTR_DECIMAL_SEP...
D C 10024
D*?
D*? Valid environment/connection attributes
D SQL_FMT_ISO C 1
D SQL_FMT_USA C 2
D SQL_FMT_EUR C 3
D SQL_FMT_JIS C 4
D SQL_FMT_MDY C 5
D SQL_FMT_DMY C 6
D SQL_FMT_YMD C 7
D SQL_FMT_JUL C 8
D SQL_FMT_HMS C 9
D SQL_FMT_JOB C 10
D SQL_SEP_SLASH C 1
D SQL_SEP_DASH C 2
D SQL_SEP_PERIOD C 3
D SQL_SEP_COMMA C 4
D SQL_SEP_BLANK C 5
D SQL_SEP_COLON C 6
D SQL_SEP_JOB C 7
D*?
D*? Connection attributes
D SQL_ATTR_AUTO_IPD...
D C 10001
D SQL_ATTR_ACCESS_MODE...
D C 10002
D SQL_ACCESS_MODE...
D C 10002
D SQL_ATTR_AUTOCOMMIT...
D C 10003
D SQL_AUTOCOMMIT...
D C 10003
D SQL_ATTR_DBC_SYS_NAMING...
D C 10004
D SQL_ATTR_DBC_DEFAULT_LIBRARY...
D C 10005
D SQL_ATTR_COMMIT...
D C 0
D SQL_MODE_READ_ONLY...
D C 0
D SQL_AUTOCOMMIT_OFF...
D C 0
D SQL_TXN_ISOLATION...
D C 0
D SQL_MODE_READ_WRITE...
D C 1
D SQL_MODE_DEFAULT...
D C 1
D SQL_AUTOCOMMIT_ON...
D C 1
D SQL_COMMIT_NONE...
D C 1
D SQL_TXN_NO_COMMIT...
D C 1
D SQL_TXN_NOCOMMIT...
D C 1
D SQL_COMMIT_CHG...
D C 2
D SQL_COMMIT_UR...
D C 2
D SQL_TXN_READ_UNCOMMITED...
D C 2
D SQL_COMMIT_CS...
D C 3
D SQL_TXN_READ_COMMITED...
D C 3
D SQL_COMMIT_ALL...
D C 4
D SQL_COMMIT_RS...
D C 4
D SQL_TXN_REPEATABLE_READ...
D C 4
D SQL_COMMIT_RR...
D C 5
D SQL_TXN_SERIALIZABLE...
D C 5
D*?
D*? Statement attributes
D SQL_ATTR_APP_ROW_DESC...
D C 10010
D SQL_ATTR_APP_PARAM_DESC...
D C 10011
D SQL_ATTR_IMP_ROW_DESC...
D C 10012
D SQL_ATTR_IMP_PARAM_DESC...
D C 10013
D SQL_ATTR_FOR_FETCH_ONLY...
D C 10014
D SQL_ATTR_CONCURRENCY...
D C 10014
D SQL_CONCURRENCY...
D C 10014
D SQL_ATTR_CURSOR_SCROLLABLE...
D C 10015
D SQL_ATTR_ROWSET_SIZE...
D C 10016
D SQL_ROWSET_SIZE...
D C 10016
D*?
D*? Null handles
D SQL_NULL_HENV C 0
D SQL_NULL_HDBC C 0
D SQL_NULL_HSTMT C 0
