Re: decimal not compiling works in interactive sql in json

Hi,

try it with

DECIMAL(x, y)

instead of

DECIMAL(x,y)

At least, if the system language is set to German, you always need a "BLANK" or "SPACE" after the comma. In Germany the comma is the separator between the whole number and the fraction (I think its called decimal separator). And we use the dot (.) as the separator between thousands.

English: 1,234,567.89
German: 1.234.567,89

HTH
Daniel

Am 31.03.2026 um 13:20 schrieb cesco via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>:

hi guys,
it is just my compiler (v7r5) that chokes with DECIMAL(x,y) but compile with DECIMAL(x) while all working in interactive????
some precompile magic to set?
I have a super simple routine below (parse a json from ifs to db2 table for staging).
works with decimal(13) not decimal(13,7)!!! any clue?

BEGSR refreshStaging;
EXEC SQL DELETE FROM CAP;
EXEC SQL INSERT INTO CAP
SELECT jt.*
FROM TABLE(IFS_READ_UTF8(
PATH_NAME => :gi_comuni_cap,
END_OF_LINE => 'NONE')) src,
JSON_TABLE(src.LINE, '$[*]' COLUMNS(

LATITUDINE DECIMAL(13,7) PATH '$.lat',
LONGITUDINE DECIMAL(13,7) PATH '$.lon'

)) AS jt
WHERE jt.COD_ISTAT <> '';
ENDSR;
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.