Re: Another SQL Question

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.