JSON to BDL type conversion rules

Specific type conversion rules apply when parsing a JSON string to fill a BDL variable.

Table 1. JSON to Genero BDL type conversion rules
JSON source string Target Genero BDL type
A JSON object in the form:
{ "record-element-name" : json-value [,...] }
RECORD ... END RECORD
A JSON array in the form:
[ json-value [,...] ]
DYNAMIC ARRAY OF ...
A JSON object in the form:
{ "dictionary-key" : json-value [,...] }
DICTIONARY OF ...

A JSON value can be null, true or false.

If the JSON value is a number or a string, the language conversion rules from number/string to BOOLEAN apply.

BOOLEAN

A JSON number.

The JSON number can be assigned to any language numeric type. The limits of the target type cause potential overflows errors. On error the target variable will be initialized to NULL, the parser continues without an error.

TINYINT, SMALLINT, INTEGER, BIGINT, SMALLFLOAT, FLOAT, DECIMAL, MONEY

A JSON string representing a date in the form "YYYY-MM-DD".

DATE

A JSON string representing a datetime or a JSON number.

If the value is a JSON string, it must be formatted as "YYYY-MM-DD hh:mm:ss.fffff", or represent as an ISO 8601 formatted date-time, in UTC (with Z indicator) or with a timezone offset (+/-hh[:mm]). For example: "2013-02-21T15:18:44.456Z", "2013-02-21T20:18:44.456+02:00".

If the value is a JSON number, it is interpreted as UNIX™ time (seconds since the Epoch 00:00:00 UTC, January 1, 1970).

Note that the YYYY-MM-DD hh:mm:ss.fffff format is used to represent the local time. When exchanging date-time values in communications across different time zones, consider converting date-time values to Coordinated Universal Time (UTC), by using the util.Datetime methods.

The util.JSON parser also supports Microsoft JSON AJAX old-style datetime values: \/Date(nnn[Z|[+|-]hhmm])\/, where nnn is a number of milliseconds since epoch, Z indicates UTC and +/-hhmm defines a timezone offset. Note that in the JSON representation of the AJAX date value, backslashes need to be escaped: "\\/Date(76523465)\\/".

DATETIME YEAR TO FRACTION(n), DATETIME YEAR TO SECOND, DATETIME YEAR TO MINUTE, DATETIME YEAR TO HOUR

A JSON string representing a year-month interval formatted as "YYYY-MM".

INTERVAL YEAR TO MONTH, INTERVAL YEAR TO YEAR
A JSON string representing a day-second interval formatted as "DD hh:mm:ss.fffff". INTERVAL DAY TO FRACTION(n), INTERVAL DAY TO SECOND, INTERVAL DAY TO MINUTE, INTERVAL DAY TO HOUR

A JSON string value encoded in Base64.

The Base64 encoding is described in [RFC4648].

BYTE (see note)

A JSON string or number.

If the JSON value is a number, the resulting BDL string value uses the locale specific decimal point.

If the JSON value is a string: Any character in the Basic Multilingual Plane (U+0000 through U+FFFF) may be escaped: \u followed by exactly 4 hexadecimal digits ([0-9a-fA-F]). The hexadecimal digits encode the code point. Characters outside the Basic Multilingual Plane may be escaped by there UTF-16 surrogate pairs. For example, the representation of the G clef character (U+1D11E) is "\uD834\uDD1E".

TEXT (see note), CHAR, VARCHAR, STRING
Note:

When parsing a JSON string to fill a TEXT or BYTE variable, if the data storage for the LOB variable has not been defined with the LOCATE instruction, the JSON methods will automatically locate the TEXT or BYTE in memory. This applies also to TEXT and BYTE elements of records, arrays and dictionaries.