Re: how to do a CPYF in SQL?

it works, but now they want to insert from 2 table to the EMODESADV3, I'll
give that a try. Yep working in IBS test.

On Wed, Jan 6, 2016 at 11:12 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

May I suggest that you actually try these things before coming to the
list? That's basic netiquette in mailing list forums and newsgroups.

Make a copy of each file from the command line and try something with
those, not the live production stuff. That's what everyone else does,
that's how we learn - you can, too!

Fortunately or not, this is generally a friendly and helpful group. Still,
we all have our own jobs to do. We're all much more willing to take time
here when a questioner shows they've done some work first.

Best of the new year to you!
Vern


On 1/6/2016 9:05 AM, Hoteltravelfundotcom wrote:

HI I would like to basically an CPYF, but in sql. This would work to
create
a copy of a file with adding all columns and data. But what I want is the
table2 already exists, can i use this below example to copy all contents
data into table2 from table1?


INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;

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