Table of Contents

Search

  1. Preface
  2. Configuring PowerExchange for PeopleSoft
  3. Understanding PowerExchange for PeopleSoft
  4. Working with PeopleSoft Sources
  5. Application Source Qualifier for PeopleSoft Sources
  6. Accessing XLATTABLE Data
  7. Creating PeopleSoft Sessions and Workflows
  8. Datatype Reference
  9. PeopleSoft Language Codes
  10. Glossary

PowerExchange for PeopleSoft User Guide for PowerCenter

PowerExchange for PeopleSoft User Guide for PowerCenter

Validating Lookup SQL Override Syntax

Validating Lookup SQL Override Syntax

After you enter the lookup SQL override, you can validate the syntax of the statement.
To validate lookup SQL override syntax:
  1. In the SQL Editor, select the ODBC data source to connect to the XLATTABLE table.
    This data source connects to the PeopleSoft underlying database.
  2. Enter a database username and password to connect to the database and click Validate.

0 COMMENTS

We’d like to hear from you!