Validating SQL Statements on an SQL Editor

About this task

The IBM Data Virtualization Manager for z/OS allows you to validate the following SQL queries that can be run against Virtual Tables and Virtual Views.
  • Select
  • Insert/Update/Delete
  • Queries with parameter markers
  • Queries with unnamed column

To validate the SQL queries:

Procedure

  1. Select the query to be validated and right click on it.
  2. Select Validate SQL.
    Validate SQL

    The system performs the following while validating SQL queries:

    • Checks the syntax accuracy.
    • Checks if the table name is valid. If it is not valid, it displays the error message Error: Unable to process map table_name.
    • Checks if the column name is valid. If it is not valid, it displays the error message Error: Invalid column reference column_name in SQL.

    If the validation is successful, Validation Succeeded message is displayed.