WRITE JSON with EMBEDDED SQL in SQLRPGLE program

[giuliocarlomagno]

Can anyone help me on how to write a numerical field with decimals in cases where this value is less than 1?

DDS DEFINITION
A FIELD084 4S 3 TEXT('DensitaAmbiente')

Example:

C+ Key 'DensitaAmbiente' value P.FIELD084,

If P.Feld084 has the value 1,564, all ok:
"DensitaAmbiente": 1,564,
If P.Feld084 has the value 0.564, Json Format Is Not Correct:
"DensitaAmbiente": .564,
He expects:
"DensitaAmbiente": 0.564,

BR
Giulio Carlomagno

[brianjgarland]

Hello,

You need to add DECEDIT(0,) to your H-spec or CTL-OPT statement.

https://www.ibm.com/docs/en/i/7.3?topic ... brun-value

Brian

[giuliocarlomagno]

Hi Brian. I have already added but obtain the same result.

"DensitaAmbiente":.818

[giuliocarlomagno]

Hi all !
I solved.
I solved.
C + KEY 'DensitaAmbiente' value decfloat (P.FIELD084),