Online Documentation for SQL Manager for DB2

Adjusting data formats


This step of the wizard provides a number of options for setting common formats for all imported data:

 

Date & Time formats: Short date, Long date, Short time, Long time;

Separators: Decimal, Thousand, Date, Time;

Boolean True (specify the text that will be displayed for the boolean TRUE values);

Boolean False (specify the text that will be displayed for the boolean FALSE values);

NULL values (specify the text that will be displayed for the NULL values).

 

For more information refer to the Format specifiers page.

 

Import Data - Adjusting data formats

 

 

Click the Next button to proceed to the Setting advanced field formats step of the wizard.