Re: TAATOOL Pricing and PRTLIBANL -- MIDRANGE-L

Subject: Re: TAATOOL Pricing and PRTLIBANL
From: Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
Date: Wed, 27 Aug 2008 08:13:11 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

rob@xxxxxxxxx wrote:

Yeah. Just pop this into iNav's Run SQL Scripts.

This is cool, and this allows you to do it from iNav. I'm just not a fan of trying to format QCMDEXC statements on the fly. If the command is at all complex, I'd suggest REXX as an alternative.

The downside is that you have to execute the SQL using a cursor, while the upside is that you can easily execute conditional logic on a row by row basis and you can prompt for your commands. And you don't have to worry about quoted strings, either.

Joe

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

QCMDEXC in a sql SELECT was: TAATOOL Pricing and PRTLIBANL , rob

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.