Re: SQL duplicate a set of records within same file

Okay Jeff let me give this a stab

INSERT into YOURLIB/YOURFILE A
SELECT B.* from YOURLIB/YOURFILE B
WHERE
then type your selection criteria

Now my question to you is:-
How many sets of duplicates can you have within a file?
The reason why I'm asking this
1). I'm trying to see why duplicates are wanted in this situation.
2). If you are trying to insert a set of records back into the file and
that set has already been duplicated, you will end up with 4 sets of
records etc. etc.



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 07/31/2007 02:27:21 PM:

I don't know if this is possible, but I gotta ask.

I'm changing a formerly multimember DDS defined file into a single member
DDL defined table by adding fields that keep batches separate. On

occasion,

we have the need to duplicate a batch. We were able to do this before

via

CPYF because we copied to a different member, so there was no need to

change

any field values.

What I essentially want to do is duplicate all records with KEY1, KEY2,
fld1, fld2, fld3, ... fldn to NEWKEY1, NEWKEY2, fld1, fld2, fld3, ...

fldn

within the same file. Since I'm handling a _set_ of records, it seemed
logical to try SQL for this. I know it takes an INSERT, but the examples
I'm finding online seem to be specific to a particular database, or so it
seems. It would also be nice to not have to name all the columns . . .

--
Jeff Crosby
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531

The opinions expressed are my own and not necessarily the opinion of my
company. Unless I say so.


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