Error with data unload

Re-sending as it didn't appear to make it to the list.
---

Hello,

System is an AIX 5.1 box with Oracle 9.2 and Genero BDL 1.33.1g.  We also
have a RedHat box with Informix and BDL 1.33.1g for comparison.

On the Linux/Informix box, UNLOADing records to a file works very nicely...
records are dumped to disk and more importantly, field space is optimized
correctly, ie: a field whose DB size is 30 chars, but only has 20 chars
entered, has the remaining 10 chars of whitespace/nulls trimmed in the
unloaded result set.

On the AIX/Oracle box, the unload occurs, but fields with unused space (ie:
that 30 char field above with 20 chars entered) have the full field size
dumped to the file - the unused characters are not trimmed.

This does not occur if using BDL 1.32.1d - the fields are trimmed correctly.

Another way to view this... we want this result:

First Name,Last Name,Address,etc.

but end up with this instead:

First Name              ,Last Name               , Address             ,etc.

This causes problems for clients who use the resulting file as a input data
source for other applications.  We've worked around the problem by running
the file through a perl script to clean it up before sending it to the
client's desktop but in view of the fact that there is a difference in the
way 1.32 and 1.33 work on AIX/Oracle, we do not consider this to be a
permanent solution.

We are curious if someone from FourJs could confirm if this is a bug or a
feature.

Cheers!
Jon