For those who find it tedious to manually generate the SQL table declarations, COBOL host variables, and COBOL indicator variables required to use embedded SQL for COBOL, here is a small Python script ...

The query returns information about employee number 7369. The SELECT statement uses an INTO clause to assign the retrieved values (from the empno, ename, sal and comm columns) into the :v_empno, ...