Chapter 10 Building Data Transformation Diagrams
This tab is only available for database inputs. It allows you to specify a SQL query to help you create your data structure columns.
The following tools are available on the SQL Query tab:
| Tool | Description |
|---|---|
|
Retrieve Columns by Preparing Query Against Database – Lets you connect to the database and check if the objects of the query you have specified in the textbox are valid. If they do, the columns of the query are automatically created in the Data Structure Columns tab of the database input. If the connection to the database is not valid, the Connect to a Data Source dialog box opens to lets you correct the database parameters. |
|
Retrieve Columns by Parsing Query — Lets you parse the query you have specified in the textbox using the SQL Editor. The columns of the query are automatically created in the Data Structure Columns tab of the database input and their parent tables or views are displayed in the Data Structure Source Objects tab. |
|
Edit SQL Query — Lets you edit the query with an editor that helps you select PDM objects to build the SQL query script. |
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |