16.20 - Defining the Null Value for an Import Operation - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty

The default value for this option is ?. This means a question mark character is used to represent a null value resulting from a SELECT statement. This string is also used in an import file to indicate that the corresponding column should be assigned a null value.

Many spreadsheet and database applications can save data in tab-delimited format. In most cases, they do not allow you to specify a null character, but simply write nothing to the file. If you want to import data from a file like this, set this field to a zero length string by deleting the contents of the field.

  1. Select Tools > Options.
  2. Click the Data Format tab.
  3. In Display this string for Null data fields, fill in the string desired.
    Use the string you have defined for the display of NULL values. The default is a question mark (?). This string, possibly quoted, should be the only thing between the surrounding delimiter characters.