Setting Data Format Options

Setting Data Format Options - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product

SQL Assistant

Release Number

15.00

Language

English (United States)

Last Update

2018-09-27

dita:id

B035-2430

lifecycle

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.

To set Data Format options

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
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 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: 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 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, choose 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 >	This options allows you to set a size limit after which a Varchar column is handled as a CLOB. The default is 16384.