Re: copying multiple rows

[Charles Wilt <charles.wilt@xxxxxxxxx>]

I've done that plenty of times in the past...works fine

Can you show the actual statement instead of a generic version?

Charles

On Thu, Apr 19, 2012 at 10:17 AM,  <rob@xxxxxxxxx> wrote:
> I have multiple rows where Column A is the same.  I want to copy those
> while changing the value of column A to some constant.  For example
>
> Insert into mytable (ColA, ColB, ColC)
> Values(
> Select 'NewConstant', ColB, ColC
> from mytable
> where ColA='OldValue')
>
> But I am getting:
> SQL State: 42703
> Vendor Code: -206
> Message: [SQL0206] Column or global variable "ANORDER@xxxxxxxxxxxxx" not
> found. Cause . . . . . :   "ANORDER@xxxxxxxxxxxxx" was not found as a
> column of table *N in *N and was not found as a global variable in *N. If
> the table is *N, "ANORDER@xxxxxxxxxxxxx" is not a column of any table or
> view that can be referenced. Recovery  . . . :   Do one of the following
> and try the request again: -- Ensure that the column and table names are
> specified correctly in the statement. -- If this is a SELECT statement,
> ensure that all the required tables were named in the FROM clause. -- If
> the column was intended to be a correlated reference, qualify the column
> with the correct table designator. -- If the column was intended to be a
> global variable, qualify the name with the schema where the global
> variable exists or ensure the schema is in the path.
>
>
>
> Rob Berendt
> --
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>          Garrett, IN 46738
> Ship to:  Dock 108
>          6928N 400E
>          Kendallville, IN 46755
> http://www.dekko.com
>
> --
> 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.