|
Rob: Since I didn't see it mentioned, might as well ask about DB2 group PTF levels on your V5R1 machine and at least one of your working V4R5 machines? This is where PTF issues would most likely get tangled for embedded SQL. Tom Liotta On Thu, 06 September 2001, rob@dekko.com wrote: > So far I've done the following: > 1) Rewritten the entire program into free format SQLRPGLE. > 2) Tried the following SQL statements: > C*EXEC SQL > C* insert into plline2 > C* (select * from vdline2 > C* where (vdlpo concat h2item) > C* in (select (pdlpo concat plitem) from plline)) > C*END-EXEC > > C*EXEC SQL > C* insert into plline2 > C* (select * from vdline2 a > C* where exists (select * from plline b > C* where a.vdlpo Ðb.pdlpo and a.h2item Ðb.plitem)) > C*END-EXEC > > C/EXEC SQL > C+ insert into plline2 > C+ (select * from vdline2 > C+ where (vdlpo concat h2item) > C+ in (SELECT a.vdlpo concat a.h2item > C+ FROM vdline2 a INNER JOIN plline b > C+ ON a.vdlpo concat a.h2item Ð b.pdlpo concat b.plitem)) > C/END-EXEC > > And still, I can restore this to our V4R5 machine and it will work > flawlessly. -- Tom Liotta The PowerTech Group, Inc. 19426 68th Avenue South Kent, WA 98032 Phone 253-872-7788 Fax 253-872-7904 http://www.400Security.com ___________________________________________________ The ALL NEW CS2000 from CompuServe Better! Faster! More Powerful! 250 FREE hours! Sign-on Now! http://www.compuserve.com/trycsrv/cs2000/webmail/
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.