Read input file in order to load to a db2 table. DB2 table has a field at the end and the input file doesn't have the field. Another word the file length is shorter than the table length for the size of the missing field. Need to know how to describe in load deck to set default for this field. This field will be default to current time stamp.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Load Utlity-DB2 Mainframe
- Thread starter djraji
- Start date
gregsimpson
Programmer
- Apr 18, 2002
- 521
djraji,
define the field as a timestamp field with "NOT NULL WITH DEFAULT". Then you shouldn't have to supply a value.
Cheers
Greg
define the field as a timestamp field with "NOT NULL WITH DEFAULT". Then you shouldn't have to supply a value.
Cheers
Greg
- Status
Similar threads
- Locked
- Question