RE: Changing CCSID

If you're using the Client Access ODBC drivers, there is a
"Translation" tab that allows 65535 to be converted.

Terry

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Cyndi Bradberry
Sent: Thursday, May 03, 2012 1:01 PM
To: 'Midrange Systems Technical Discussion'
Subject: Changing CCSID

Everyone,

We have JDE World, 7.3 running on a 520 at V6R1. We are
trying to use a PC based sql tool to extract some records
from the F0911 file but we get the Hex version on the PC.
The system CCSID is set to 65535, LangID=ENU. I have tried
to change the PF to CCSID = 037. I have recompiled the file,
using a new source file that has a CCSID = 037.

No matter what I have tried, I can't get this to change. Any
suggestions ? I would eventually like to make this system
wide.....as it is silly to stay with the 65535.

At the very least, is there something I can tell my PC guy to
put into his SQL statement to translate ?

Thanks,
Cyndi B.
Boise, ID


--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Confidentiality Notice:

The preceding e-mail message (including any attachments) contains information that may be confidential, protected by applicable legal privileges, or constitute non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution or reproduction of this message by unintended recipients is
not authorized and may be unlawful.