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