Re: Embedded SQL update question

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