Re: SQL insert syntax

[Jim Essinger <dilbernator@xxxxxxxxx>]

Dave,

You have not supplied enough information.  Are you adding new records
(insert) or changing existing records (Update)?

Is the new field new to the file? Not sure what you need.

Jim



On Fri, Feb 17, 2012 at 8:33 AM, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

> Hi all,
>
> Having trouble with the syntax of a simple insert.
>
> I want to copy fileA to fileB after fileB has been modified so the first
> field is a new field. I want to put the same value into each row of the new
> field.
>
> Something like :
>
> Insert into fileB
> Select 'Constant', fileB.* from fileB
>
> Can someone put me right?
> Thanks
> --
> 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.