LAB6 and LAB7 Macros Source Code - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Two macros are required for the embedded SQL examples LAB6 and LAB7. Sample source code for creating the two macros is shown below. 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