Re: Perfromance of SQL DELETE vs clrpfm

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Oops, I meant "Starting". Sorry.

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



On Thu, Oct 14, 2010 at 11:05 AM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

> 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.