LAB6 and LAB7 Macros Source Code |Teradata Preprocessor2 for Embedded SQL (PP2) - LAB6 and LAB7 Macros Source Code - Teradata Preprocessor2

Two macros are required for the embedded SQL examples LAB6 and LAB7. Sample source code for creating the two macros is shown here. This code resides in the LABSBTEQ file.

DROP MACRO LAB6;
CREATE MACRO LAB6 AS
   (INSERT EMPLOYEE
         VALUES ( 2001,
                  1003,
                  2215,
                  9567,
                  ’TIME’,
                  ’SUMMER’,
                  ’74/12/02’,
                  ’55/06/06’,
                  62000););
DROP MACRO LAB7;
CREATE MACRO LAB7 AS
   (SELECT  EMPLOYEE_NUMBER,
            MANAGER_EMPLOYEE_NUMBER,
            DEPARTMENT_NUMBER,
            JOB_CODE,
            LAST_NAME,
            FIRST_NAME,
            HIRE_DATE,
            BIRTHDATE,
            SALARY_AMOUNT
   FROM EMPLOYEE
   ORDER BY 1;
SELECT EMPLOYEE_NUMBER,
      MANAGER_EMPLOYEE_NUMBER,
      DEPARTMENT_NUMBER,
      JOB_CODE,
      LAST_NAME,
      FIRST_NAME,
      HIRE_DATE,
      BIRTHDATE,
      SALARY_AMOUNT
   FROM EMPLOYEE
   ORDER BY 1 DESC;);
.quit