INSERT Statement not working

Question

Question

Lewis Houlden · Jun 20, 2022

Hi all

I'm struggling to insert into a table, and it is baffling me. The insert statement is now very simple (I was using a complex INSERT SELECT statement but I'm trying to narrow down the problem).

Insert statement:

INSERT INTO Phu_Replay_Schema.ReplayMessageModel (Completed, MessageHeaderId, NewHeaderId, NewTargetName) VALUES (true, 3616, null, 'Router_ReplayHL7')

I get a SQLCODE -12 error, and I can't understand why: A term expected, beginning with one of the following: identifier, constant, aggregate, $$, :, (, +, -, %ALPHAUP, %EXACT, %MVR, %SQLSTRING, %SQLUPPER, %STRING, %TRUNCATE, or %UPPER>]

I'm pretty sure I'm missing something blatantly obvious, but I just cant see it! I've tried a load of variations but to no avail.

Thank you!

Product version: IRIS 2021.2

Discussion (5)1

Log in or sign up to continue

Julian Matthews · Jun 20, 2022

Hey Lewis.

Could you try swapping out "true" for it's bool equivalent? So try:

INSERT INTO Phu_Replay_Schema.ReplayMessageModel (Completed, MessageHeaderId, NewHeaderId, NewTargetName) VALUES (1, 3616, null, 'Router_ReplayHL7')

0 0

Julian Matthews · Jun 20, 2022

That just means you're one step closer to solving the issue!

What are the data types for each field you're attempting to insert into?

Have you tried just inserting a row with just 1 of the fields populated? Something like:

INSERT INTO Phu_Replay_Schema.ReplayMessageModel (Completed) VALUES (1)

0 0

score 0 · Answer 1 · 2022-06-20T07:59:04-04:00

Hi Julian - thanks for replying. I have tried that, and it changes the error to -400 which is a generic fatal error.

score 0 · Answer 2 · 2022-06-20T08:10:11-04:00

Julian, thank you! In leading to the -400 error, I opened the class, compiled it, and re-ran the insert and it worked! Thanks again.,

score 0 · Answer 3 · 2022-06-20T08:12:00-04:00

Robert Cemper · Jun 20, 2022

Does NewHeaderId allow NULL or is it required ?
in addition, you could try '' instead of NULL

0 0