Object Considerations

ITEM	DG/400	DSS	DataGate
Field Name Length	10 Characters	31 Characters	31 Characters
Supported Types
- Char	*CHAR	char	*CHAR
- Packed	*PACKED	decimal	*PACKED
- Zoned	*ZONED	numeric	*ZONED
- Binary	*BINARY	numeric	*BINARY
- Float	*FLOAT	Float(4): float Float(8): real	*FLOAT
- Integer	*INTEGER	Integer(2): smallint Integer(4): int	*INTEGER
- Date	*DATE	ASNA_DSS.DATE datetime: 00:00:00	*DATE
- Time	*TIME	ASNA_DSS.TIME datetime: 1899/12/30	*TIME
- Timestamp	*TIMESTAMP	datetime	*TIMESTAMP
- Hex	*HEX	binary	*HEX
- DBCS	*DBCS	nchar	*DBCS
- Unicode	*DBCS	nchar	*DBCS
- Boolean	*CHAR(1)	Bit	*CHAR(1)
Allows Nulls	Yes	Yes	No
Variable length Field	Char Hex Dbcs	varchar varbinary varnchar	No
Date value range	0001-01-01 to 9999-12-31	Datetime: 1753-01-01 to 9999-12-31 (0001-01-01 maps to 1753-01-01) Smalldatetime: 1900-01-01 to 2079-06-06	00001-01-01 to 9999-12-31
Decimal number storage	Packed: 1 nibble per digit Zoned: 1 byte per digit Binary 1 - 4 digits: 2 bytes Binary 5 - 9 digits: 4 bytes	Decimal / Numeric 1 - 9 digits: 4 + 1 bytes 10 - 19 digits: 8 + 1 bytes 20 - 29 digits: 12 + 1 bytes 30 - 38 digits: 16 +1 bytes	Packed: 1 nibble per digit Zoned: 1 byte per digit Binary 1 - 4 digits: 2 bytes Binary 5 - 9 digits: 4 bytes
Date storage	1 byte per digit / character	Datetime: 8 bytes ASNA_DSS_DATE: 8 bytes SmallDatetime: 4 bytes	1 byte per digit / character
Fields per file		1,024	32,000
Re-typing logical fields	Unrestricted	Logical fields whose type differs from that of the corresponding physical field cannot be updated	Unrestricted
Column Heading Definitions	Up to 3 31 characters	The 3 headings are concatenated into the MS Access CAPTION field	Up to 3 31 characters
Text Description	Up to 49 characters	Up to 49 characters	Up to 49 characters