For the sake of conversation, assume the record is an integer, timestamp, and a char:
12345||"Joe Smith"
So, the timestamp field we recieve from our source is either the full tiemstamp (19 bytes) or an empty set. I tried setting the null_value to '', but got the error message (warning msg, then fatal msg):
I am sure this is a very rudimentary question, but we do so little with normal pipe delimited ASCII data from our sources. About 90% of our 100+ sources are EBCDIC from the mainframe, so I'm rusty on your average Unix data file...W - besttransaction: At field "NULL_TMSP_FLD": "null_field" length (0) must match field's fixed width (19) [impexp/group_comp.C:4453]
F - besttransaction: At field "NULL_TMSP_FLD": A fixed length field cannot have a "null_field" of length 0 on import [impexp/group_comp.C:4469]
Thanks!
Brad.