SBCS , DBCS and MIXED Data



IBM's flagship relational database management system

SBCS , DBCS and MIXED Data

Postby fornanthakumar » Fri Sep 13, 2013 9:25 pm

Hi,

Could you please assist me to get an clarification on SBCS,DBCS and MIXED data ?

with example.

Regards,
Nantha.Y
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 69
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SBCS , DBCS and MIXED Data

Postby Robert Sample » Fri Sep 13, 2013 9:29 pm

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: SBCS , DBCS and MIXED Data

Postby fornanthakumar » Thu Sep 19, 2013 4:51 pm

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
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 69
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post