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 <[email protected]>:
> 
> 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: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
> 
> Please contact [email protected] for any subscription related questions.
> 
-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.