Re: iSeries Navigator, Run Sql scripts, getting hex data

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I found what you are talking about.  Thank you.  However turning that on
didn't seem to make the difference.

Wait, now I found something else.  In V5R2 of iSeries Access, Run Sql
Scripts, Connection, JDBC setup, Translation, "Translate CCSID 65535".
That did it.  Thanks, you did, kind of, point me.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




Pete Hall <pbhall@ameritech.net>
Sent by: midrange-l-admin@midrange.com
09/13/2002 08:46 PM
Please respond to midrange-l


        To:     midrange-l@midrange.com
        cc:
        Fax to:
        Subject:        Re: iSeries Navigator, Run Sql scripts, getting hex data


At 09:10 09/13/2002, Rob Berendt wrote:
>I ran the following script in iSeries Navigator:
>
>Select cmpsts
>from qusrsys.qafqsnd
>group by cmpsts;
>
>And I ended up getting four rows, all look like hex.
>Is this one of those CCSID things?  If so, then how do I correct that
from
>within an iSeries SQL script?

Rob,

I'm not positive, but I'm pretty sure. Look for a system ODBC datasource
named QDSN_machine-name (where, of course, machine name is the system name
of your AS400). Edit it (configure button). Go to the translation tab and
check the "convert binary (CCSID 65535) to text" checkbox.

hth


Pete Hall
pbhall@ameritech.net
http://www.ameritech.net/users/pbhall/index.html

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