Re: Unloading date fields

CHANGE THE DELIMITER CHARACTER! Try using the default vertical bar '|' delimiter or commas. Art S. Kagel benlag@my-deja.com wrote: > > 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.