Re: Embedded SQL update question

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Charles

If I remember from the compile listing, there might need to be a 1 to 1 
matching of things - all those SQ* variables that the preprocessor puts in.

Just a thought from recovery land - post cataracts surgery - my point of 
view is changing all the time!

Vern

On 12/20/2019 12:00 PM, Charles Wilt wrote:
> This works just fine at 7.2
>
> update mytable
> set row = :myDs;
>
> So why doesn't this?
> update mytable
> set (col1, col2, col3) = (:myDs);
>
> I get a
> SQL0312  30
> Variable MYDS not defined or not usable. Reason: No declaration for the
> variable exists, the declaration is not within the current scope, or the
> variable does not have an equivalent SQL data type.
>
> The SQL Reference manual shows the same diagram for the right hand side of
> the equal sign for both ROW = and ( column list ) =
>
> Note that it also seems to indicate parentheses are required around the
> right regardless.  Though ROW = above compiles and works.
>
> Without parentheses on the second form I get
> SQL0104 Position 26 Token : was not valid. Valid tokens: ( NULL DEFAULT.
>
> I'd swear I've used a DS with a column list before...but maybe not...
>
> I can switch to
>
> update mytable
> set (col1, col2, col3)
>    = (:myDs.col1, :myDs.col2, :myDs.col3);
>
> If I must...but of course there's more than just 3 columns...
>
>
> Thanks