Free Form SQL - INPUT - Analysis Parameters - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Teradata Warehouse Miner
Release Number
July 2017
English (United States)
Last Update
Product Category
  1. On the Free Form SQL dialog, click on INPUT.
  2. Click on analysis parameters.
    Free Form SQL Input

    This screen contains a text window in which one or more SQL statements and optional comments can be typed and/or pasted. When satisfied that the SQL statement or statements are complete, the analysis can be executed, either in whole or in part. To execute just a selected portion of the text, simply highlight the statements to execute as shown in the example above and run the analysis.

  3. If desired, comments can be added to the Free Form SQL text in one of two ways:
    • Multiple line comments can be entered beginning with a forward slash and asterisk “/*” and terminated with an asterisk and forward slash “*/”, but not with the Execute as a single statement option. (If a comment of this type appears after all SQL statements in the text, the option to Submit SQL without comments should be used).
    • Single line comments can be entered beginning with two consecutive dash characters “--” and terminated with a carriage return.

    The text window on this screen is resizable and supports and retains formatted text, either through the use of the limited formatting options offered via right-click menu options, or through pasting formatted text from a compatible rich-text format source, such as the Teradata SQL Assistant utility.

    The following options are available as right-click menu options.
    • Standard text functions are provided, including Undo, Redo, Cut, Copy, Paste, Delete, Find, Replace and Select All.
    • The Find/Replace function provides options for Whole word, Case specific, Search from Beginning of text or Current position, as well as Replace and Replace All buttons.
    • Limited support for text formatting is also provided, including Font, Bold, Italic, Underline and Font Color (with access to a limited number of font colors).
    • An option is provided to set Parameter Color, changing the font color of all parameter tags to Black, Red, Blue or Green.
    • If an SQL DROP command fails to find the database object being dropped, the error is ignored and not reported to the user (much as this error is ignored in other types of analysis).
    The following execution options can be selected at the bottom of the screen.
    • The Continue execution on error option can be used when multiple statements are entered and it is desired to continue executing statements even if an error occurs on one of them. Note that when this option is used and one or more errors occurs, the last error encountered will be returned as the result of the analysis. Therefore it may also be necessary to select the Tools > Preferences > Execution menu option to Continue project execution on analysis error in order to continue project execution as well.
    • The option to Submit SQL without comments is provided in case it is desired to simplify viewing the SQL in Results, or in case it is suspected that submitting the comments leads to an error. For example, this option should be used if a comment beginning with “/*” and ending with “*/” follows all SQL statements in the text window.

      Note that this option is not available when the option to Execute as a single statement is also selected.

    • If multiple statements have been entered that need to be executed as a single statement (such as with REPLACE MACRO or REPLACE PROCEDURE), use the Execute as a single statement checkbox. Note that when this option is selected, comments beginning with “/*” and ending with “*/” are not allowed. Note also that when this option is used, large decimal data (i.e., more than 18 decimal digits) cannot be returned in the results. Further, with this option, the number of rows returned will not be limited according to user preference settings.
    • When the Multiple result sets per command option is selected, individual statements will be allowed to return more than one result set. This is particularly useful when a CALL statement returns more than one data set. Note that with this option, the number of rows returned will not be limited according to user preference settings, and large decimal data (more than 18 digits of precision) cannot be returned, just as with the “Execute as a single statement” option.