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

[Pete Hall <pbhall@xxxxxxxxxxxxx>]

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