Restriction: Date fields in transaction files
Dates fields must be in system-readable date format even if you want those dates to be empty. In other words, dates cannot be NULL. Null dates must be represented as either very old dated or very future dates.
Here is an example of a transaction file:
ID |NAME |CALLED_NUMBER|CALL_LENGTH|TRAN_DATE_TIME
001234|David |732-123-4567 |15 |2003-02-10 09:12:33
001234|David |732-111-5555 |48 |2003-02-10 10:11:50
002941|Jeremiah|732-777-8888 |40 |2003-02-10 11:22:44
005555|Anthony |732-333-4444 |27 |2003-02-10 03:01:02
005555|Anthony |732-32-8945 |121 |2003-02-10 10:12:30
005555|Anthony |973-597-0022 |2 |2003-02-10 19:00:21
006789|Tom |732-111-2222 |4 |2003-02-10 06:54:01
Copyright IBM Corporation 2012. All Rights Reserved.