Re: SQL MERGE

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!