RE: "call qcmdexc parm('CLRPFM ABC' 10.00000)" in an SQL script? -- MIDRANGE-L

Nope,

The quote was from the v5r3 manual.

I tried it with a file that had 2500 records.

100 might not be "significant".

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx 
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Monday, October 23, 2006 3:29 PM
To: Midrange Systems Technical Discussion
Subject: Re: "call qcmdexc parm('CLRPFM ABC' 10.00000)" in an 
SQL script?

On 10/23/06, Wilt, Charles <CWilt@xxxxxxxxxxxx> wrote:


Dan,

What version are you on?

A quick test on my system (v5r4) didn't leave any deleted

records in the

[file].



IIRC, v5r3 was the same.  Which makes make sense given the 
changes made

in v5r3 to which my first post talks about.



Sorry, I forgot to mention that we are on V5R3.

Also, specific to the reference you quoted earlier:

The target table is not a view, it's a plain old physical file.
A significant (???-there are only less than 100 records in

the file; what
is "significant"???) number of rows are being deleted.

No open cursors on the file
No other job has a lock on the table.
The table does not have an active delete trigger.
The table is not the parent in a referential constraint, period.
I am able to run CLRPFM on the file manually, so I presume

I have *OBJMGT
or *OBJALTER system authority on the table.

Maybe it is new to V5R4?

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