Page 1 of 1
SBCS , DBCS and MIXED Data
Posted:
Fri Sep 13, 2013 9:25 pm
by fornanthakumar
Hi,
Could you please assist me to get an clarification on SBCS,DBCS and MIXED data ?
with example.
Regards,
Nantha.Y
Re: SBCS , DBCS and MIXED Data
Posted:
Fri Sep 13, 2013 9:29 pm
by Robert Sample
SBCS and DBCS are not terms specific to DB2 -- they are used across the mainframe. And Google is your friend -- Googling sbcs dbcs returned about 45,800 hits and the first three returned hits all explain the terms and their use quite well.
Re: SBCS , DBCS and MIXED Data
Posted:
Thu Sep 19, 2013 4:51 pm
by fornanthakumar
Hi Robert,
Thanks indeed.
What i bothered here is,
For a Unicode tablespace , The SYSIBM.SYSTABLESPACE catalog table's column values are ,
ENCODING_SCHEME . . . . . . . U
SBCS_CCSID . . . . . . . . . . 367
DBCS_CCSID . . . . . . . . . . 1200
MIXED_CCSID . . . . . . . . . 1208
For an ASCII Tablespace ,
ENCODING_SCHEME . . . . . . . A
SBCS_CCSID . . . . . . . . . . 858
DBCS_CCSID . . . . . . . . . . 0
MIXED_CCSID . . . . . . . . . 0
if i want unicode data from an ASCII table or ASCII data from EBCDIC table, then how do i play with these data conversion for the above numbers mentioned. ?
Note : Mostly with BMC tool