Rules and Guidelines for Configuring a Saved Query
Use the following rules and guidelines to configure a saved query:
- •When you edit a column datatype, precision, or scale, error rows are not written to the error rows file at runtime.
- •Specific error messages for invalid SQL statements do not display. For more information about an invalid SQL statement, test the statement on the source database.
- •In the SQL statement:
- - Use a SELECT statement.
- - Do not use an asterisk (*) to select all columns of a table. List the columns that you want to select.
- - Do not use conversion functions, such as TO_CHAR or TO_DATE.
- - Do not use the COUNT function.