MIDRANGE-L » February 2013

Re: RUNSQL joblog or stats to report on the number of records deleted

Subject: Re: RUNSQL joblog or stats to report on the number of records deleted
From: rob@xxxxxxxxx
Date: Wed, 6 Feb 2013 13:07:38 -0500
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Before you run the statement you could try
STRDBG UPDPROD(*YES)

STRDBG UPDPROD(*YES)
RUNSQL SQL('delete from rob/fb where column1=''C''') COMMIT(*NONE)
...
1 rows deleted from FB in ROB.
Message ID . . . . . . : SQL7955
Message type . . . . . : Completion
...
ENDDBG

I believe there are sql variables in embedded sql which will tell you
this.

Rob Berendt

This thread ...

RUNSQL joblog or stats to report on the number of records deleted , fbocch2595

Re: RUNSQL joblog or stats to report on the number of records deleted, rob <=

<Possible follow-ups>
Re: RUNSQL joblog or stats to report on the number of records deleted , CRPence

Re: RUNSQL joblog or stats to report on the number of records deleted , Jack Kingsley

Re: RUNSQL joblog or stats to report on the number of records deleted , Gqcy

RE: RUNSQL joblog or stats to report on the number of records deleted , Roger Harman

References:
- RUNSQL joblog or stats to report on the number of records deleted , fbocch2595

Prev by Author: RE: Hardware Management Console - Too many open files in process SRC-E212E161
Next by Author: Shouldn't that be TR6?
Previous by thread: RUNSQL joblog or stats to report on the number of records deleted
Next by thread: Re: RUNSQL joblog or stats to report on the number of records deleted
Index(es):

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact