Managed File Transfer User Guide

10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Step 9: Test and Generate the SQL statement

When you are done specifying the criteria for the SELECT statement, you can perform one of the following functions:

Click the

Test

button to test the SELECT statement. This will run the statement against the database and will either return any errors (if the syntax is invalid) OR it will show the results of the SELECT statement (displaying the first few selected rows). This feature will help you verify that the SELECT statement is generating the results that you expected.

If the SQL Wizard was launched from a Project, then click the

Done

button to embed the generated SELECT statement into the Project's SQL Task.

Using the SQL Wizard

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal