Re: V4R5 and SQL

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

At 10:34 04/15/2002, Jim Rubino wrote:
>This message is in MIME format. Since your mail reader does not understand
>this format, some or all of this message may not be legible.
>--
>We recently upgraded to V4R5, we have JDEdwards world software. When a user
>tries to run a program in JDE (World Writer), this program builds an SQL
>statement over 3 files. The job seems to be getting hung up and not running.
>If we remove some of the data selection needed, it runs fine. This exact
>some program ran fine before going to V4R5.  Has anyone had similar problems
>and are using JDE or had similar problems with other packages and found a
>PTF or solution to this.

Are you up to date on Cume and DB PTFs? We had problems with QQQOPTIM when
we first went to V4R5. Something seems to get hosed whenever a new feature
is added to the DB or SQL support. It's apparently just the nature of the
beast. Got to be one bugger of a piece of code. No problems after applying
PTFs though. If you can paste the query into ISQL, you may get an
indication of the problem in the joblog, possibly something about data
exceptions or invalid pointers.


Pete Hall
pbhall@ameritech.net