RE: SQL vs V5R1 and service woes

[thomas@xxxxxxxxxxx]

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/