CCSID

Hi all,

I am trying to retrieve a field from a file that has been defined as
'Open' to accommodate different CCSIDs.  These have some DBCS entries
and when I do a STRSQL, I get junk value but the DSPPFM shows the data
as fine.  I understand there is a way to cast the field and I don't seem
to know the syntax.  I tried :

select pimage ccsid 935 from sudcnm  - token 935 not valid.
select ccsid(pimage 935) from sudcnm - token 935 not valid.

The job has 935 ccsid as default char iden. (the other one is 65535.
should I change this to 935 maybe?)

I need help to get this to work.
TIA,
Sudha

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax