SQL Statements › EXECUTE IMMEDIATE › Rules for Statement Strings › Example

Example

          01  S1.
              49  S1LEN                 PIC S9999 COMP VALUE +80.
              49  S1HV                  PIC X(8).
          MOVE 'INSERT INTO T1 VALUES (1, 2)' TO S1HV.
          EXEC SQL
              EXECUTE IMMEDIATE S1
          END-EXEC