|
midrange.com
Here's what I use:
/Frank
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
rob@xxxxxxxxx
Sent by:
wdsci-l-bounces@m To
idrange.com wdsci-l@xxxxxxxxxxxx
cc
2005-06-03 23:38 Subject
[WDSCI-L] Fw: SQLSTATE constant
list wanted
Please respond to
Websphere
Development
Studio Client for
iSeries
<wdsci-l@midrange
.com>
Are there wizards that will create members like this requested? This
might go a long way towards "standardizing" constants among disparate
shops.
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
----- Forwarded by Rob Berendt/DEKKO on 06/03/2005 04:36 PM -----
"M. Lazarus" <mlazarus@xxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
06/03/2005 04:16 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
To
RPG400-L@xxxxxxxxxxxx
cc
Subject
SQLSTATE constant list wanted
Does anyone have a source member that contains a list of the SQLSTATE
error code constants that I can use to /COPY into an RPGLE program? TIA.
-mark
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
--
This is the Websphere Development Studio Client for iSeries (WDSCI-L)
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
