Re: SQL DELETE

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

David

I would not use a DELETE - instead, use a QMQRY SELECT that gives you 
what you want and have it output to an outfile, that outfile being your 
original file. Very cool and very risky!!

So your SELECT would be, if the table is clientdata

SELECT Code, Client, MAX(SeqNo) FROM ClientData GROUP BY Code, Client

If you put that into a QMQRY object called ShrinkCD and run it, that 
would be like this -

STRQMQRY ShrinkCD OUTPUT(*OUTFILE) OUTFILE(ClientData) OUTMBR(*FIRST 
*REPLACE)

Badaboom! Hope not too much of a BOOM!

HTH
Vern

David FOXWELL wrote:
> Hi
>  
> I have this table :
>  
> Code  Client    SeqNo
> A     123       10
> A     123       20
> A     123       30
> B     123       40
> B     123       50
> A     456       35 
> A     456       30 etc
>
> I want to delete lines so I keep only one line for each pairing of Code and Client. The SeqNo must be the highest number for the pair.
>  
> So my table after delete should be :
> Code  Client    SeqNo
> A     123       30
> B     123       50
> A     456       35 
>
>
> Thanks for any help. 
>
> PS what's happened to Elvis Budimlic?
>