Setting Data Format Options - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Setting Data Format Options

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 box.

1 Select Tools > Options.

2 Click the Data Format tab.

Table 21 explains each option.


Table 21: Data Format Tab in the Options Dialog Box 



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 for this setting is “?”.

Display dates in this format

The drop-down list contains pre-defined 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:

  • dDay number without leading zero
  • ddDay number with leading zero
  • dddDay name abbreviated
  • ddddDay name in full
  • Month formats are specified by repeating characters as follows:

  • mMonth number without leading zero
  • mmMonth number with leading zero
  • mmmMonth name abbreviated
  • mmmmMonth name in full
  • Year formats are specified by repeating characters as follows:

  • yyYear, represented with 2 digits
  • yyyyYear, 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

    Wheras d-mm displays 7-03

    Note: 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.

  • 0All Binary/Byte columns are treated as BLOBs
  • 64000Binary/Byte columns are never treated as BLOBs
  • OtherBinary/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 >

    This options allows you to set a size limit after which a Varchar column is handled as a CLOB. The default is 16384.