EasyCFM.COM ColdFusion Forums / Other / AS400 Data is truncated

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: AS400 Data is truncated

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

09-18-2008 @ 7:26 AM
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 1
Joined: Sep 2007

I am new to working with data pulled of an AS400 (iseries).  I have successfully set up the ODBC connection and have created a recordset.  But what I observe is that data from numeric fields is truncated, and all that is returned are the first two digits of the field.  The AS400 fields in this instance are unsigned packed fields.  Can anyone lend some insight as to whether this is the basis of the problem?  I should be seeing 6 digits from the field - not two.  Thanks! Smile

I had the AS400 people create a new file of the same fields but with unpacked fields.  The truncating problem persists.  So regardless of whether the data is packed or zoned it is truncated.  The common thread is that the problem involves only numeric data.  

This message was edited by movertom on 9-18-08 @ 1:20 PM

Website Designed and Developed by Pablo Varando.