The following example shows how to use the NewEmp macro to insert data into the Employee and Department tables.
The information to be inserted is the name, employee number, and department number for employee H. Goldsmith. The EXECUTE macro statement looks like this:
EXECUTE NewEmp (‘Goldsmith H’, 10015, 600);