SQL SELECT Statements as Virtual Tables

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce >

SQL SELECT Statements as Virtual Tables

MapForce supports the creation of SQL SELECT statements with parameters in database components. These are table-like structures that contain the fields of the result set generated by the SELECT statement. These structures can then be used as a mapping data source, like any table or view defined in the database.

 

When using Inner/Outer joins in the SELECT statement, fields of all tables are included in the component.
Expressions with correlation names (using the SQL "AS" keyword) also appear as a mappable items in the component.
Database views can also be used in the FROM clause.
SELECT statements can contain parameters which use the same syntax as the SQL WHERE/ORDER component.

 

Once the SELECT statement has been added to a database component, the fields returned by it are available for mapping, for example:

add_select_03

The number of visible lines of the SELECT statement is configurable. To define the number of lines you want to see on the component, select the menu command Tools | Options, click the General tab and enter the number of lines in the Mapping View group.


© 2019 Altova GmbH