A host program INSERT does not require cursor control and functions the same as a stand-alone SQL INSERT. Here is an example of a host program CREATE TABLE and INSERT examples:

     EXEC SQL
       CREATE TABLE PILOT_TBL
        (PILOT_ID CHAR(5) PRIMARY KEY,
         FIRST_NAME CHAR(20) NOT NULL,
         LAST_NAME CHAR(20) NOT NULL,
         LICENSE_NO CHAR(10),
         PHONE_NO INTEGER NOT NULL DEFAULT)
     END-EXEC

     EXEC SQL
       INSERT INTO PILOT_TBL
       VALUES (:WS-PILOT, :WS-FIRST, :WS-LAST, :WS-LICENSE, WS-PHONE)
     END-EXEC

     EXEC SQL
       INSERT INTO PILOT_TBL
              (PILOT_ID, FIRST_NAME, LAST_NAME, LICENSE_NO, PHONE_NO)
       VALUES (:WS-PILOT, :WS-FIRST, :WS-LAST, :WS-LICENSE, WS-PHONE)
     END-EXEC