Validating SQL statements in the connector at design time
After you generate or write a SQL statement, you can validate the statement during job design.
About this task
Note: Under some circumstances, the connector requires
a connection to validate SQL statements. When a user name and password
are not supplied and a connection is required, a connection is made
by using the user who is running the ASB Agent service.
Procedure
- Save the job.
- Click the Build button that is associated with the statement property, and select Validate SQL. The Validate SQL option is enabled only if the statement property contains a value and this option will only be available for statements which the target RDBMS supports validating.