Re: CPF2803, CPF428A

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Rob

I don't use 1 = 1 in SELECTs but I do if I want to delete all records 
from a table - sometimes CLRPFM is not allowed - we have that in some 
circumstances on our systems - and a bare-naked DELETE FROM uses CLRPFM 
on IBM i. The WHERE 1 = 1 does not use CLRPFM. And I don't know the 
history for suppressing CLRPFM here.

Cheers
Vern

On 11/15/2021 10:10 AM, Rob Berendt wrote:
> I fail to understand why all the WHERE conditions.
> 1=1???  Is this just a thing you always do to avoid warning errors that you have no where clause?
>
> And why
> ... and     substr(table_Schema,1,1) not in ('Q', '#')
> When you have
> and     table_schema = 'DPPDATA'
> D already excludes Q and #.
> Let me guess your evolution.
> First, I was right on the evolution on the 1=1, right?
> Second, you started by specifying Q and # to only get "user" libraries?
> Third, then you added just the library you wanted?
>
>
> Rob Berendt