[DB2EUG] extracting negative values in IXF format

[Johnson, Shaunn]

Title: extracting negative values in IXF format

Gee.  I hope I didn't offend anyone with this last email.

Maybe I should ask a different question.

At the following link, I'm trying to study up on the PC version of IXF
file format.

http://www-4.ibm.com/cgi-bin/db2www/library/document.d2w/report?uid=UNKNOWN&pwd=&search_type=SIMPLE&r_host=UNKNOWN&last_page=sqln0.html&fn=sqln00109.html

Now, as noted below, the data I bring back is numerical (the actual format
is decimal).  If I run a basic sql to DB2, I receive the data exactly as
it should be.  I get all the data / values (positive or negative) I
expect.

The *new* question is: where can I get more information about the habits of
IXF file formats and how does the IXF feature drop anything when exporting
the column / value into the binary format?

Otherwise: Is there a site where I can ask some IBM techie this without
subscribing to their support center? My IS dept. could care less ... so ...

Thanks again!

-X

--Howdy:
--
--I am connecting to DB2 6.1.1 (on mainframe) and pulling data via an SQL
--script into an IXF formatted file.
--
--My question is: When I try to load the data into another database
--(for example: DB2 Universal Database 7.1) I can see that the
--numeric value of a field has returned, but there is no positive or
--negative value that should be attached to it.  For example, if
--a numeric field should be -234.59 (on DB2, it is), the IXF file will only have
--234.59 (but there is no way for me to know if it was a deficit or not).
--
--Any suggestions would be appreciated.
--
--Thanks!
--
-- -X