Unloading date fields
Posted in 1999
Hello all, I have an Informix 7.3 UC8 database running on a HP-UX10.20 system and am encountering a strange problem. I am trying to unload data from a table that contains all character fields. The data in one of the fields is a date inserted from a field of type date from another table. Whenever I unload this table the date field exports 2 delimiters (tabs) instead of just one. This makes the user think there is an extra field in the table even though there isn't.I have tried "TRIMING" the field before inserting it, using different dates, and even specifying a substring of the field (date_field[1,10]) but nothing works. I can resolve this problem in one of two ways: 1)Figure out how to export field names when unloading data. 2)firgure out how to prevent the double delimiter from happening. Any help or suggestions would be greatly appreciated, Benny benlag@aent.com Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.