Re: 7.1 gets stricter on SQL

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

On 1/31/2011 1:53 PM, Joe Pluta wrote:
> That may well be what I need, Luis.  Thanks for that.  However, I've 
> been VERY unsuccessful setting QAQQINI options.  In fact, the last 
> time I did it my queries stopped working at all.
>
> I tried this:
>
> update qusrsys/qaqqini set qqparm = '*YES' where
>  qqparm = 'COLLATE_ERRORS'
>
> and I got a trigger error CPF433B, code 3, with text "Parameter *YES 
> was not valid".
>
> Not enough hours available today to chase that one down.
>
> Joe

Ah pfui.  That was dumb.  Should have been set QQVAL = '*YES', not 
QQPARM.  Duh.  Anyway, I did that and it didn't fix the problem.  Not 
sure why or why not, and as I said, I don't have enough hours today to 
chase it down.

Joe