Procedure Overview - 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

To set up the SQL examples:

1 Install the PP2 product libraries on all operating systems that will be used.

2 Run the LABS control stream to:

  • Create the new EMPLOYEE table.
  • Load the EMPLOYEE table.
  • Create the LAB6 macro.
  • Create the LAB7 macro.
  • Note: Execute the create files and load the data only once on any one platform.

    3 Grant the following access privileges for the user ID you want to use with the examples.

  • SELECT
  • UPDATE
  • INSERT
  • DELETE
  • Note: Remember to set the LOGON string variable length and modify the code to include these items for the installation:

  • TDPID
  • USERID
  • password