Re: SQL MERGE

Yeah, we've done similar things from C#.

But we haven't needed to do so from RPG.

As I think about it, I suppose even RPG might need it if it's a dynamic
statement rather than static.

Charles

On Sun, Aug 6, 2023 at 12:44 PM David Gibbs via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

On Jul 30, 2023, at 12:21 AM, x y <xy6581@xxxxxxxxx> wrote:

Message: [SQL0584] NULL, UNKNOWN, or parameter marker in VALUES not
allowed. Cause . . . . . : Each column in a VALUES clause must have a
data type. All rows for a column cannot contain NULL, UNKNOWN, a

parameter

marker, or the RAISE_ERROR scalar function. Recovery . . . : Ensure
every column has at least one value with a defined type. A CAST
specification can be used to assign a type. Try the request again.

I got a the same error a few weeks ago when using merge from a java
program.

I ended up having to explicitly cast the parameter’s in the values clause
in order for DB2 to accept them.

david

—
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding a in the American Diabetes Association's Tour de Cure to raise
money for diabetes research, education, advocacy, and awareness. You can
make a tax deductible donation to my ride by visiting
https://mideml.diabetessucks.net. My goal is $7000 but any amount is
appreciated.

You can see where my donations come from by visiting my interactive
donation map ... https://mideml.diabetessucks.net/map (it's a geeky
thing).

I may have diabetes, but diabetes doesn't have me!

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.