Folgende Syntax wird für das JSON GENERATE Statement erkannt:
>>-JSON GENERATE--identifer-1--FROM--identifier-2--+------------------------------+--><
|--COUNT--+----+-identifier-3--|
|-IN-|
>-+------------------------------------------------------------------------------+-->
| .------------------------------------. |
| V | |
|--NAME--+-------+-identifier-4--+----+--+-literal-1--+-----------------------|
|-OF-| |-IS-| |-OMITTED---|
>-+------------------------------------------------------------------------------+-->
| .----------------------------------------. |
| V | |
|--SUPPRESS----+--+-identifier-5--+-------------+----+--+---------------------|
| |-when-phrase-| |
|-------generic-suppression-phrase-|
>-+------------------------------------------------------------------------------+-->
| .-------------------. |
| V | |
|--CONVERTING--phrase-1--+-------------------+--------------------------------|
|-ALSO---phrase-1-|
>-+------------------------------------------------------------------------------+-->
|--+----+-----EXCEPTION---imperative-statement-1------------------------------|
|-ON-|
>--+-------------------------------------------------+--+----------+-----------------><
|--NOT--+----+-EXCEPTION--imperative-statement-2--| |-END-JSON-|
.---------------------------------.
| |
V |
>>--WHEN--+--ZERO---------+--+------------------------------+--+--><
|--ZEROES-------| |--+----+--+--ZERO---------+--|
|--ZEROS--------| |-OR-| |--ZEROES-------|
|--SPACE--------| |--ZEROS--------|
|--SPACES-------| |--SPACE--------|
|--LOW-VALUE----| |--SPACES-------|
|--LOW-VALUES---| |--LOW-VALUE----|
|--HIGH-VALUE---| |--LOW-VALUES---|
|--HIGH-VALUES--| |--HIGH-VALUE---|
|--HIGH-VALUES--|
>>--+--------------------------+--when-phrase--><
|--EVERY--+-NUMERIC-----+--|
|--NONUMERIC--|
>>--identifer-6--+----+-+------+-+-BOOLEAN-+--+-------+--+--condition-name-1-+---------------><
|-TO-| |-JSON-| |-BOOL----| |-USING-| |--literal-2--------|