|
I am hoping someone can help me understand why my code isn't working. On my file, there is some SQL date data types defined. For example: D gResultDs E DS EXTNAME(DBAPAPI) 75=D DAPICMPNY 4B 0 76=D DAPIVENDOR 9A 77=D DAPIINVC 22A 78=D DAPISUFFIX 4B 0 79=D DAPICNCLSQ 4B 0 80=D DAPICNCLDT 10D DATFMT (*ISO-) 81=D DAPIBTCHNM 9B 0 82=D DAPIBTCHDT 10D DATFMT (*ISO-) 83=D DAPIVCHNBR 10A 84=D DAPIATHCD 3A 85=D DAPIPRCLVL 5A 86=D DAPIACCRCD 4A 87=D DAPIINVOTY 1A 88=D DAPIINVCRR 5A 89=D DAPIPYCRRN 5A 90=D DAPIINSTIN 10D DATFMT (*ISO-) 91=D DAPIPRFRLC 4A 92=D DAPIPNMBR 14A I am doing a "select *" and putting the results in gResultDs. I am getting a SQLSTT of 22008 and SQLCOD of -183. The text for the error is: Datetime field overflow occured; for example an arithmetic operation on a date or timestamp has a result that is not within the valid range of dates. Using UPDDTA, I don't see any invalid dates. There are a couple that are "0" (0001-01-01), all of the rest are within this last year or so. Any ideas for me? -- Mike Wills Midrange Programmer/Lawson Administrator koldark@xxxxxxxxx http://www.mikewills.name Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
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.