Re: CPYF FROMKEY/TOKEY using packed key field

[Dan <dan27649@xxxxxxxxx>]

On 10/31/05, Douglas Handy <dhandy@xxxxxxxxx> wrote:
>
> Then why not use a SQL statement instead and do an INSERT INTO? The query
> optimizer is smart enough to use existing indexes for record selections.


THWACK!

(The sound of right hand slapping head.)

True 'nuff. Seemed even a tad faster than the CPYF FROMKEY/TOKEY. Didn't
measure, but...

INSERT INTO TESTLIB/CUSMAS
select * from PRODLIB/CUSMASL00
where CSC# >= 61200000000 and CSC# <= 61299999999

When I first prompted on INSERT, it didn't bring up any options to SELECT
from another file. Is this what I think I've heard before referred to as a
sub-select?

Also, is there an equivalent of CPYF's MBROPT(*REPLACE) in SQL? Or a CLRPFM
equivalent statement that can be run before the INSERT INTO?

- Dan