|
On 8/4/05, anand.praj@xxxxxxxxx <anand.praj@xxxxxxxxx> wrote: > > Move the WITH NC command after WHERE clause i.e. eh... fudge. <g> I think I picked that placement up by looking at a VERY simple UPDATE example. And, being the good RTFM-kinda guy I try to be, I tried looking up "NC" and "WITH NC" in the SQL Reference and the SQL Programming with Host Languages, but didn't find any reference to required placement of this "isolation-clause". The generic nature of SQL0199 makes it a virtually useless error message. Interesting, I think, that interactive SQL defaults to Commitment Control = *NONE and embedded SQL in RPG is, what?, = *CHG? Thanks again for everyone's help. - Dan
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.