Validating SQL statements

Edit online

Data Virtualization Manager studio allows you to validate SQL queries before you execute them. You can select one or more SQL queries for validation.

About this task

You can validate the following types of SQL queries:
  • SELECT queries
  • INSERT, UPDATE, and DELETE queries
  • Queries with parameter markers
  • Queries with unnamed column
Data Virtualization Manager studio performs the following when validating the SQL queries:
  • Checks syntax accuracy.
  • Checks if the table name is valid. If invalid, the error message Error: Unable to process map table_name is displayed.
  • Checks if the column name is valid. If invalid, the error message Error: Invalid column reference column_name in SQL is displayed.

You can select one or more SQL queries for validation. To validate the SQL queries, perform the following steps in the SQL editor of the studio.

Note: Parameterized INSERT and UPDATE to a Db2 table's Graphic column on the Z system with UTF8 (IBM1208) is not supported.

Procedure

  1. Select the SQL query or SQL queries that you wish to validate.
  2. Right-click the selection and select Validate SQL from the context menu that appears.

Results

If the validation is successful, Validation Succeeded message is displayed. Else, appropriate error messages are displayed.