|
Well, this isn't quite 100, but...D @Values40 S 150A INZ(' VALUES+ D (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?+ D ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?+ D ,?,?,?,?,?,?)')
Then use that to build your string... ArString = 'INSERT Into MYLIB/ARMIMG' + @Values40; Then that goes... PREPARE arSQL from :ArStringThere are probably other ways to do it. Tommy Holden, in fact, showed me another method; this is just the one I decided to use.
midrange.com
* Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>
Marco Facchinetti wrote:
Just to know, but how to handle many parameters (i.e > 100) ? Marco --- rob@xxxxxxxxx wrote:Standard answer. Been quite repeated on this list lately. Stop trying to embed the actual value into :w_string. Imbed "parameter markers" instead. w_string = 'select colA from fileA where PriKey=?'; /end-free C/exec sql C+ PREPARE S1 FROM :W_STRING C/end-exec C/exec sql C+ DECLARE CURS1 CURSOR FOR S1 C/end-exec C/exec sql C+ OPEN CURS1 using :MyVal C/end-exec Will place MyVal into the question mark of PriKey. Yet another reason why SQL kicks butt on OPNQRYF. Rob Berendt__________________________________________________ Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
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.
