×
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.
Charles I typed in your Function, I should be testing it soon Thanks for
the time it took to paste it in I really appreciate that.
Rob, thanks for your explanation of values.
Eric I did download the iDate utility, thanks for the tip. I'll for sure
be looking into that.
Vern, Thanks for the response, I'm just getting into SQL SP's, I've done a
few External Stored procedures that are working, but have never gone deep
into sql itsself.
Charles, I just took a look, I don't recognize another midrange forum that
references iSeries DB2 SQL. Can you suggest one?
Weird, I just inserted the call to the date conversion function, and now I
get the following error: 34 Position 9 Token C1 was not valid. Valid
tokens: GLOBAL. where I wasn't getting this before.
33 SET WRKDAT = DRLTONUMSP(CURRENT_DATE); This is the function
call
34 DECLARE C1 CURSOR FOR
35
36 SELECT PCCOCD , PCAGNT , PCPOLM ,PCCOVC, PCEFDT ,PCEXDT
37 ,INLNAM , INFNAM , AGNAME
38
39 FROM SPFILES/COVMST
........
Thanks again to all
Darrell Lee
Information Technology
Extension 17127
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
