You can only create a query by using a detailed specification file.
Use the syntax shown in Specification-File Conventions to create a query.
Use the following syntax to create a specification file for a query:
BEGIN OBJECT QUERY queryname # Compulsory Attributes PROJECT projectname DATABASE targetdatabasename SELECTSTATEMENT sql_statement END OBJECT
The following table lists the attributes and their values.
| Attribute | Attribute Value |
|---|---|
| queryname | Query name |
| projectname | Name of an existing project |
| sql_statement | SQL SELECT statement, in quotation marks, that contains unload criteria |
| targetdatabasename | Name of the database that the records will be loaded or unloaded to |