|
So it's wrkmbrpdm qsysinc/h and position to sql -- happy digging!
At 02:59 AM 6/7/2005, you wrote:
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.
--
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-2024 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.
midrange.com
