SQL Text Dialog Box
Use the SQL Text dialog box (Figure 11) to create single or multiple SQL statements to schedule for execution at a later time or date.
Figure 11: SQL Text Dialog BoxThe following table describes the options and controls in this dialog box:
Option |
Description |
SQL |
Enter the text for the single or multiple SQL statements to schedule. Note: Large object (LOB) data cannot be inserted into a Teradata Database with scheduled requests to insert. However, a SQL request can be scheduled that retrieves LOB data from a table, and save those results to a table or a file. |
OK |
Click to save your SQL statement and schedule it for execution in the Teradata Query Scheduler Submit dialog box. |
Cancel |
Click to close the SQL Text dialog box without saving SQL statement. |
Paste |
Click to add the text of single or multiple SQL statements copied from another application to the SQL Text dialog box. |
To learn how to create SQL statements for scheduling using the SQL Text dialog box, see “Scheduling a SQL Request” on page 38.