Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Trouble retrieving data from AS400 files

Posted on 2004-10-28
Medium Priority
Last Modified: 2008-03-06
I am currently trying to retrieve data from an AS400 table, i have succeeded with this many times before, however the only difference now is that i am trying to access JDEdwards files (and some of these to work), however for some files i have been able to retrieve some data (from the number fields) but other fields (string fields) in the files are being retrieve as jargon.
Data should be as follows:
However what is being retrieved is

Also the field types are not being retrieved correctly, all number fields seem to work fine in the files however the string fields are having problems, the actual field types are being change for example the following is a list of what is being converted.

10   Alpha      ->  String 20
5, 0 Packed    -> Number
10   Alpha     ->  String 20
1     Alpha     ->  String 2
10   Alpha     ->  String 20
1     Alpha     ->  String 2

where as the files that are working correctly seemd to have the same field types, what would be causing this to happen.

Question by:jdwan
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 101

Expert Comment

ID: 12441301
This may be helpful

What is the underlying database?

LVL 42

Accepted Solution

frodoman earned 2000 total points
ID: 12442412
I notice that what you listed as being retrieved is a 20 character field, hence the conversion to string(20).  Sounds like a driver issue to me.  My guess is that you're connecting to DB2 on the AS/400 and your driver isn't translating the binary alpha characters from their raw form into ascii text.

If you're using an ODBC connection with Client Access then edit the ODBC connection and check the "Translation" tab - I believe there's an option to "convert binary CCSID 65535 to text".  Check this option and see if that solves the problem.  If you're using another driver look for a similar option.


Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question