DB2_NULL_FLDS (SQL Table)	Index Back
DB2 Null Fields Record contains one record which has null values for Date and DateTime - used in AE insert sql statements where a null date or datetime is needed to get around DB2 constraints.

DB2_NULL_FLDS

(SQL Table)

DB2 Null Fields

Record contains one record which has null values for Date and DateTime - used in AE insert sql statements where a null date or datetime is needed to get around DB2 constraints.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DB2_NULL_ID Number(1,0) SMALLINT NOT NULL ID number for the DB2 Null Date and DateTime fields - always = 1
Default Value: 1

2 DB2_NULL_DT Date(10) DATE Null Date for DB2 AE inserts

3 DB2_NULL_DTTM DateTime(26) TIMESTAMP Null DateTime field for DB2 inserts

4 DB2_NULL_LONG Long Character CLOB field to hold a NULL value that can be used in Insert from Select statements in DB2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DB2_NULL_ID	Number(1,0)	SMALLINT NOT NULL	ID number for the DB2 Null Date and DateTime fields - always = 1 Default Value: 1
2	DB2_NULL_DT	Date(10)	DATE	Null Date for DB2 AE inserts
3	DB2_NULL_DTTM	DateTime(26)	TIMESTAMP	Null DateTime field for DB2 inserts
4	DB2_NULL_LONG	Long Character	CLOB	field to hold a NULL value that can be used in Insert from Select statements in DB2