Online Documentation for SQL Manager for DB2

Adjusting data formats


This step allows you to customize formats applied to exported data.

 

Data formats

Edit the format masks to adjust the result format in the way you need: Integer, Float, Date, Time, DateTime, Currency, Boolean True, Boolean False, NULL string, Decimal separator, Thousand separator, Date separator, Time separator.

 

Export Data - Adjusting data formats

 

 

Hint: The formats used by default are specified in the Data Export section of the Environment Options dialog.

 

For more details refer to Format specifiers.

 

 

Click the Next button to proceed to the Setting header and footer step of the wizard.