JDE and Business Objects


Hello everyone

Has anyone created a universe for Business Objects to use with JDE A7.3 on
the AS400. We have set up the ODBC connection and can see the field
definitions but when we run reports with a data selection, the report
columns have the error 'this is a BLOB'. We are querying over the F0006 file
and the only field with meaningful data returned is MCDL01. I would be
grateful for any help on the subject.

Deirdre Howes
Business Analyst
* +44 (0)1252 832146
F: +44 (0)87 0243 9850
* [email protected]

This e-mail transmission is intended only for the use of the person(s) to whom it was intended to be sent and may be privileged, confidential and exempt from disclosure under applicable law. If you are not the intended recipient please do not copy or convey this message to any other Person but delete this message and notify us via e-mail to [email protected]

It shall be understood by the recipient(s) that conclusions, opinions and other information contained in the above e-mail not relating to the official scope of business of SAUR UK Ltd. shall be deemed not to have been given or endorsed by SAUR UK Ltd.

SAUR UK Ltd. , 22/30 Sturt Road, Frimley Green, Surrey GU16 6HZ, UK


Active Member
If you are in Windows trying to use the Client Access ODBC driver for your
DSN data source, the problem may be due to the translation radio button not
being clicked (for some reason the default setting is set to "not translate"
and I've always needed to have it set "to translate"). From the Control
Panel, click on ODBC Data Sources, select the correct User/System/File DSN.
Click on Configure, click on the Translation Tab and be sure the radio
button for "Translate CCSID 65535" is selected. Click on Apply and then
click on OK. DSN data sources and the Client Access ODBC drivers have
caused us lots of confusion, but when it's work it's damn near like magic.

A7.3, Cum 10
Moving to XE, AS/400, Coexistence, HTML clients


Do you have a universe for Business Objects designed by BO or JDE
Thanks in advance

At 25-09-01, you wrote: