SQL Dialog
The
SQL dialog allows you to specify a SQL query and an Oracle Database connection
to create the XML for the Template Builder. The XML is created in a canonic
flat format:
<ROWSET>
<ROW>
<COLUM_NAME>Data</COLUM_NAME>
</ROW>
</ROWSET>
On
the DATA menu select SQL… to open the Insert SQL dialog.
All fields in this dialog are mandatory.
Host
Enter
the hostname of the database server.
Port
Enter
the port for the database server.
SID
Enter
the Oracle SID (instance identifier) for the database server
User
Enter
user name for the database connection.
Password
Enter
the password for the user for the database connection.
SQL Query
Enter
a standard SQL query to retrieve the data. You may not use any specific
packages to create XML – such as XMLgen in this query.
OK Button
Click
the OK button to run the SQL query against the database and convert the
result into XML sample data for the Template Builder.
Cancel Button
Click
the Cancel button to close the SQL dialog without performing any
action.
