Re: Another SQL Question

There's no easy way I'm afraid...you have to explicitly list the remaining
fields...but with copy & paste from a select it's not to bad.

insert into myfile
select 2, fld2, fld3, fld4, <...>
from myfile

You could also build a temporary table

declare global temporary table mytmp
as (select * from myfile)
with data

update mytmp
set company = 2

insert into myfile
select * from mytmp

hth,
Charles




On Wed, Dec 5, 2012 at 1:25 PM, JackTucky <jacktucky@xxxxxxxxx> wrote:

I have several different files that all contain a company#. I want to use
SQL to write a new record for every record in the file but change the
company number to 2. All of the other fields remain the same.



I know it's possible but I'm having a hard time googling. I'm guessing I
need an insert into with another select?



Thanks, Jack.





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