Page 1 of 1

WRITE JSON with EMBEDDED SQL in SQLRPGLE program

Posted: Fri Sep 23, 2022 7:17 am
by 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

Re: WRITE JSON with EMBEDDED SQL in SQLRPGLE program

Posted: Fri Sep 23, 2022 10:30 am
by 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

Re: WRITE JSON with EMBEDDED SQL in SQLRPGLE program

Posted: Fri Sep 23, 2022 11:40 am
by giuliocarlomagno
Hi Brian. I have already added but obtain the same result.

"DensitaAmbiente":.818

Re: WRITE JSON with EMBEDDED SQL in SQLRPGLE program

Posted: Fri Sep 23, 2022 6:06 pm
by giuliocarlomagno
Hi all !
I solved.
I solved.
C + KEY 'DensitaAmbiente' value decfloat (P.FIELD084),