RE: CCSID

I got this. We need to typecast it as vargraphic.
Thanks, -s

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

-----Original Message-----
From: Ramanujan, Sudha 
Sent: Friday, April 01, 2005 2:10 PM
To: midrange-l@xxxxxxxxxxxx
Subject: 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



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