Skip to main content
N
NVL-Tom
Inspiring
September 17, 2008
Question

Pulling data off AS400

  • September 17, 2008
  • 3 replies
  • 1416 views
I have successfully connected to our AS400 at work. After creating a recordset and downloading data I found that all of the numeric fields brought results with just two digits, although I know the data contained on the AS400 consists of 5 or more integers. In review of the fields descriptions on the AS400 I see that the numeric fields are all packed fields. Can anyone advise where I may receive further information on how to display these packed fields as they should appear?
This topic has been closed for replies.

3 replies

N
NVL-TomAuthor
Inspiring
January 21, 2011

Update:

Using StarSQL from StarQquest resolved the issues.  The data pulls down beautifully.

D
djkhalif
Inspiring
July 30, 2009

Please walk me through how you got your AS400 data to Coldfusion.

N
NVL-TomAuthor
Inspiring
September 18, 2008
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices