Re: REXX SQL usage -- Fit it? -- MIDRANGE-NONTECH

Subject: Re: REXX SQL usage -- Fit it?
From: Tom Liotta <qsrvbas@xxxxxxxxxxxx>
Date: Thu, 05 Nov 2009 18:56:19 -0800
List-archive: <http://archive.midrange.com/midrange-nontech>
List-help: <mailto:midrange-nontech-request@midrange.com?subject=help>
List-id: Non-Technical Discussion about the AS400 / iSeries <midrange-nontech.midrange.com>
List-post: <mailto:midrange-nontech@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-nontech>, <mailto:midrange-nontech-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-nontech>, <mailto:midrange-nontech-request@midrange.com?subject=unsubscribe>

Buck wrote:

As an administrative note, if anyone wants to run Tom's code snippet,
either use STRREXPRC ... CMDENV(*EXECSQL) or add this line:
address '*EXECSQL'
before this line:
PRVDATE = '0001-01-01'

Leave it to you, Buck... Fine, fine...

http://code.midrange.com/6016605251.html

I uploaded the CL that I sent along with the REXX to IBM. It wasn't intended for anything but reference in the code repository(, though I wouldn't have minded if anyone pointed out something that made it work).

Sheesh... You HAD to try to run it!

Tom Liotta

p.s. It took them a full extra day to let me know that they couldn't make STRREXPRC work. I pointed out that I had included a sample STRREXPRC in the code and that CMDENV(*EXECSQL) really was important.

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.