× 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.



I'd prefer the dynamic SQL, since it's an all SQL solution.

Chuck, any reason behind your preference for OVRDBF?

My initial thought was perhaps immunity to SQL injection...but then I
got to wondering if the use of QCMDEXC would be open to any attack...I
can't think of a way...but...

Charles

On Thu, Mar 17, 2011 at 3:37 AM, CRPence <CRPbottle@xxxxxxxxx> wrote:

  I would use OVRDBF the literal PRCSHT [or any literal named on the
FROM clause] to the variable named library/file on the TOFILE()
parameter, along with appropriate override scope.  Issue an SQL CALL
QCMDEXC with a variable as the constructed command string, passed as the
first parameter and the trimmed length as the second parameter
[DECIMAL(15,5)].  That CALL would be used to effect the override before
the SQL INSERT is performed.  Another option [though not preferable IMO
due to its creating an object] is to CREATE ALIAS to the variable named
file, and use the ALIAS name instead of the file name in the FROM
statement; probably simpler to perform that statement versus building a
command string and length for the OVRDBF command string however.

  Otherwise PREPARE and execute a dynamically constructed SQL statement
with the names concatenated into the FROM clause.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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.