11. Report-Writer Expressions and Formats : Format Specifications : Default Formats : Default Format for Columns
 
Share this page                  
Default Format for Columns
If you do not specify a column format with the .format statement, Report-Writer uses the default format for the column. The default format is based on the data type of the column. For more information, see Determining Default Column Formats in the chapter "Using Report-Writer."
The following table lists default formats for SQL data types:
SQL Data Type
For Reports Other Than Block Style
For Block Style Reports
c1 - c35
c1 - c35
c1 - c35
c36 - cn
where n is the lesser of the maximum configured row size and 32,000
cj0.35
cj0.35
char(1) - char(35)
c1 - c35
c1 - c35
char(36) - char(n)
where n is the lesser of the maximum configured row size and 32,000
cj0.35
cj0.35
text(1) - text(35)
c1 - c35
c1 - c35
text(36) - text(n)
where n is the lesser of the maximum configured row size and 32,000
cj0.35
cj0.35
varchar(1) - varchar(35)
c1 - c35
c1 - c35
varchar(36) - varchar(n)
where n is the lesser of the maximum configured row size and 32,000
cj0.35
cj0.35
integer1
f6
f10
smallint (integer2)
f6
f10
integer (integer4)
f13
f10
decimal (31.31 - 31.0)
Based on size. For example, decimal (5.1) defaults to f7.1, allowing additional digits for the decimal point and an optional +|- sign.
float(n
n10.3
f10.3
float4
n10.3
f10.3
float8
n10.3
f10.3
date
c25
c25
money
'$---------------.nn'
'$---------------.nn'
Note:  All character data types are fully supported in non‑Ingres databases accessed by way of an Enterprise Access product, in which case the column size limit can be greater than the lesser of the maximum configured row size and 32,000.