Setting Data Format Options - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Teradata SQL Assistant
Release Number
October 2018
English (United States)
Last Update
Product Category
Teradata Tools and Utilities
Control the format of data values that are both displayed the Answerset window and Written to an Export file by setting options on the Data Format tab of the Options dialog.
  1. Select Tools > Options.
  2. Click the Data Format tab and complete the fields.
    Option Description
    Display dashes between bytes for binary data values

    When selected, a dash appears between each byte of the value for ease of reading, for example, ‘63-B1-A3-62’.

    The default is selected.

    Write Byte Order Mark [BOM] to CLOB output files

    Select this option to add a Byte Order Mark at the start of each CLOB file.

    The default is cleared.

    Display BigInt and Decimal(16)+ values as strings

    When checked, large numeric values are stored as strings for Excel compatibility.

    When cleared, values with more than 15 digits are rounded when saved to Excel.

    The default is cleared.

    Display this string for Null data values

    Enter the string to be displayed in place of Null data fields in the reports and imported/exported files.

    The default is “?”.

    Display dates in this format The drop-down list contains predefined options to select. The characters d, m, and y to signify the day, month and year components can be added to the list. It also accepts /, -, ',' and space characters can be added as delimiters.
    Day formats are specified by repeating characters as follows:
    • d – Day number without leading zero
    • dd – Day number with leading zero
    • ddd – Day name abbreviated
    • dddd – Day name in full
    Month formats are specified by repeating characters as follows:
    • m – Month number without leading zero
    • mm – Month number with leading zero
    • mmm – Month name abbreviated
    • mmmm – Month name in full
    Year formats are specified by repeating characters as follows:
    • yy – Year, represented with 2 digits
    • yyyy – Year, represented with 4 digits

    Insertion Characters:

    The dash, slash, comma, period and space characters are insertion characters.

    For example:

    dddd, dd mmm yyyy displays Monday, 07 Mar 2008

    Whereas d-mm displays 7-03

    Lowercase 'm' is automatically changed to uppercase 'M.'
    Number of decimal places to display for Float columns

    Entering a value between 0 and 9 allows you to specify the number of decimal places initially displayed for all data that originated from a FLOAT column. The default value for this option is 2.

    You can change the setting for selected columns. From the shortcut menu, select Decimal Places.

    Handle Binary/Byte columns as BLOBs if size > Enter a number between 0 and 64000. The default value for this option is 30.
    • 0 – All Binary/Byte columns are treated as BLOBs
    • 64000 – Binary/Byte columns are never treated as BLOBs
    • Other – Binary/Byte columns larger than this value are treated as BLOBs

    Each BLOB is returned to a separate file on your PC. Regular Binary/Byte data appears in the grid as a hex string.

    Handle Varchar columns as CLOBs if size > Set a size limit after which a Varchar column is handled as a CLOB. The default is 16384.