Re: [WDSCI-L] Data perspective & SQL

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

This sounds like your iSeries has a CCSID of 66535, which means don't 
translate data. I don't know where this would be set, unless it is in some 
kind of JDBC settings. In OpsNav and iSeries Access data transfer there is 
a setting for converting the 66535 CCSID.

HTH - just a wild guess
Vern

At 03:39 PM 10/13/2004, you wrote:
> I have attempted few SQL statements by using Data perspective and running
> like interactive SQL It works great, but all the character data are
> displayed in Hex,  the packed/zoned decimal look OK. I tried looking into
> the settings, I could not find one. Any Help is highly appreciated
>
> -=- A. Schulman Inc. Email Disclaimer -=-
>
> The content(s) of this e-mail and attachment(s) are confidential, may be
> legally privileged and is for the use of the intended recipient only.
> Access, disclosure, copying, distribution or reliance on any of it by
> anyone else is prohibited.  If received in error, please delete and e-mail
> confirmation to the sender.
>
> A. Schulman Inc. does not guarantee that the information sent and/or
> received by or with this e-mail is correct and does not accept any
> liability for damages related thereto.
>
> _______________________________________________
> This is the Websphere Development Studio Client for iSeries  (WDSCI-L) 
> mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.