× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.