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--------|