Is WHERE not allowed with INSERT unless there's SELECT FROM ?
SEU Shows this error "Keyword WHERE not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT..."
I can Check the value in C-SPEC IF-END code, but that seems more clunky
SEU Shows this error "Keyword WHERE not expected. Valid tokens: FOR USE SKIP WAIT WITH FETCH LIMIT..."
I can Check the value in C-SPEC IF-END code, but that seems more clunky
Code:
C/EXEC SQL C+ INSERT INTO MyTable VALUES(:BPLYEAR, :BPLPERD, C+ :BPLPERN, :ATREG, :ACMSPAR, :AXSPITM, :BOFTOTA, :BOFACCA, C+ :HOFORDR, :AHDTYP, :AHTOWH, ' ', ' ', :AIWGHT) C+ [COLOR=#FF0000]WHERE :BPLYEAR >= '2020' [/COLOR]
Comment