Previous Next

How to create a SQL query to retrieve data from a JDBC data source

This procedure assumes you have already created the JDBC data source that this data set uses.

1  
2  
1  
2  
3  
4  
Query displays the information to help you create a SQL query. Available Items lists the items in the data source.
3  

Figure 2-19 Viewing a schema

Figure 2-19  Viewing a schema
You can use the following filter options to display specific schemas or objects. Choose Apply Filter after specifying the filters.
*
*
*
4  
5  
For some databases, if a table or column name contains spaces or SQL reserved words, you must enclose the name in quotation marks (" "). If you drag and drop tables and columns, and those items need to be enclosed in double quotation marks, select the Use identifier quoting option. When this option is selected, the data set editor inserts the quotation marks around a table or column name when you drop it in the text area.

Figure 2-20 Adding a table to a SQL query

Figure 2-20  Adding a table to a SQL query
6  

(c) Copyright Actuate Corporation 2013