Re: Perfromance of SQL DELETE vs clrpfm

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Richard,

Startint at V5R3 (IIRC) a SQL DELETE without a WHERE clause is the
equivalent of a CLRPFM, as long as nobody else is using the table.

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Thu, Oct 14, 2010 at 10:56 AM, Needles,Stephen J
<SNEEDLES@xxxxxxxxxxxxx>wrote:

> Go ahead and test it...I will be interested in your results.
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
> midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Reeve
> Sent: Thursday, October 14, 2010 10:10 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Perfromance of SQL DELETE vs clrpfm
>
> I just came across a program(CL) that uses the delete function within SQL
> to
> clear a file and that made me wonder if it is more efficient to do a CLRPFM
> or
> if the SQL delete would be as efficient.
>
> Any thoughts/experiences?
>
>
> Warmest Regards,
>
> Richard Reeve
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
>
> ==============================================================================
> This communication, including attachments, is confidential, may be subject
> to legal privileges, and is intended for the sole use of the addressee. Any
> use, duplication, disclosure or dissemination of this communication, other
> than by the addressee, is prohibited. If you have received this
> communication in error, please notify the sender immediately and delete or
> destroy this communication and all copies.
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.