Inhaltsverzeichnis

JSON GENERATE

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

when-phrase Format

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

generic-suppression-phrase Format

>>--+--------------------------+--when-phrase--><
    |--EVERY--+-NUMERIC-----+--|
              |--NONUMERIC--|

phrase-1 Format

>>--identifer-6--+----+-+------+-+-BOOLEAN-+--+-------+--+--condition-name-1-+---------------><
                |-TO-| |-JSON-| |-BOOL----|  |-USING-|  |--literal-2--------|