SQL Data Source

 Top Previous Topic Next Topic  Print this topic

Overview: SQL data sources describe the structure of a SQL query result.

 

The following sample illustrates a SQL query that selects records from the table emp with the specified employee id:

 

queryds1

 

The query is defined as follows:

 

queryds2

 

Notice:

•The ${parameter} characters declares theID as a query parameter.
•Also, a Query Name can be specified.