Use this window to provide information for the SQL or
XQuery script and to specify how you want to build the script.
- Project
- Select the data project in which to save
the SQL or XQuery script. If you want to save the script in a new
data project click New to create the project.
This
field is not shown when you create a script from within a data project.
- Name
- Type the name to assign to the SQL or
XQuery script that you are creating. The name can contain
any combination of alphanumeric characters and the number sign ( #
).
- Edit using
- Select the tool that you want to use to
create the script.
- SQL and XQuery editor
- Select this option to type one or more
SQL or XQuery statements
in the SQL and XQuery editor.
- SQL Query Builder
- Select this option to use the fields in
the SQL Query Builder to help you build an SQL statement.
- Statement type
- Select the type of SQL statement to create. Template
text for the selected SQL statement type is provided for you in the
SQL Query Builder.