Saturday, March 22, 2014

DRDA DDM Term Codepoint Mapping

DRDA DDM Term Codepoint Mapping

1. PDF format of Standard can be found in Open Group website at:
    https://collaboration.opengroup.org/dbiop/

2. For DDM Codepoint and Term Mapping, extracted from PDF file provided by Open Group:

TERM NAME, Codepoint(Hex), TEXT
=========================================
ABNUOWRM, 220D, ABNUOWRM
ACCDMG, 003E, ACCDMG
ACCRDB, 2001, ACCRDB
ACCRDBRM, 2201, ACCRDBRM
ACCSEC, 106D, ACCSEC
ACCSECRD, 14AC, ACCSECRD
AGENT, 1403, AGENT
AGNPRMRM, 1232, AGNPRMRM
ARMCORR, 2161, ARMCORR
ARRAY, 004B, ARRAY
ASSOCIATION, 0001, ASSOCIATION
ATMIND, 2159, ATMIND
ATTLST, 0046, ATTLST
BGNATMCHN, 1803, BGNATMCHN
BGNBND, 2002, BGNBND
BGNBNDRM, 2208, BGNBNDRM
BIN, 0003, BIN
BINDR, 0042, BINDR
BITDR, 0004, BITDR
BITSTRDR, 0005, BITSTRDR
BNDCHKEXS, 211B, BNDCHKEXS
BNDCHKONL, 2421, BNDCHKONL
BNDCPY, 2011, BNDCPY
BNDCRTCTL, 211D, BNDCRTCTL
BNDDPLY, 2016, BNDDPLY
BNDERRALW, 2423, BNDERRALW
BNDEXPOPT, 2130, BNDEXPOPT
BNDEXSOPT, 241D, BNDEXSOPT
BNDEXSRQR, 241C, BNDEXSRQR
BNDNERALW, 2422, BNDNERALW
BNDOPT, 2405, BNDOPT
BNDOPTNM, 2144, BNDOPTNM
BNDOPTVL, 2145, BNDOPTVL
BNDSQLSTT, 2004, BNDSQLSTT
BNDSTTASM, 2126, BNDSTTASM
BOOLEAN, 0006, BOOLEAN
BUFINSIND, 215C, BUFINSIND
BYTDR, 0043, BYTDR
BYTSTRDR, 0044, BYTSTRDR
CCSIDDBC, 119D, CCSIDDBC
CCSIDMBC, 119E, CCSIDMBC
CCSIDMGR, 14CC, CCSIDMGR
CCSIDSBC, 119C, CCSIDSBC
CCSIDXML, 1913, CCSIDXML
CHRDR, 0008, CHRDR
CHRSTRDR, 0009, CHRSTRDR
CLASS, 000A, CLASS
CLSQRY, 2005, CLSQRY
CMDATHRM, 121C, CMDATHRM
CMDCHKRM, 1254, CMDCHKRM
CMDCMPRM, 124B, CMDCMPRM
CMDNSPRM, 1250, CMDNSPRM
CMDSRCID, 2107, CMDSRCID
CMDTRG, 0041, CMDTRG
CMDVLTRM, 221D, CMDVLTRM
CMMRQSRM, 2225, CMMRQSRM
CMMTYP, 2143, CMMTYP
CMNAPPC, 1444, CMNAPPC
CMNMGR, 1408, CMNMGR
CMNSYNCPT, 147C, CMNSYNCPT
CMNTCPIP, 1474, CMNTCPIP
CNNTKN, 1070, CNNTKN
CNSVAL, 000B, CNSVAL
CNTQRY, 2006, CNTQRY
CODPNT, 000C, CODPNT
CODPNTDR, 0064, CODPNTDR
COLLECTION, 000D, COLLECTION
COMMAND, 000E, COMMAND
CONSTANT, 0050, CONSTANT
CRRTKN, 2135, CRRTKN
CSTBITS, 2433, CSTBITS
CSTMBCS, 2435, CSTMBCS
CSTSBCS, 2434, CSTSBCS
CSTSYSDFT, 2432, CSTSYSDFT
DATA, 003C, DATA
DCTIND, 1450, DCTIND
DCTINDEN, 1451, DCTINDEN
DECDELCMA, 243D, DECDELCMA
DECDELPRD, 243C, DECDELPRD
DECPRC, 2106, DECPRC
DEFINITION, 0048, DEFINITION
DEFLST, 0047, DEFLST
DEPERRCD, 119B, DEPERRCD
DFTDATFMT, 2400, DFTDATFMT
DFTPKG, 241E, DFTPKG
DFTRDBCOL, 2128, DFTRDBCOL
DFTTIMFMT, 2401, DFTTIMFMT
DFTVAL, 0011, DFTVAL
DGRIOPRL, 212F, DGRIOPRL
DIAGLVL, 2160, DIAGLVL
DICTIONARY, 1458, DICTIONARY
DMYBLKDATFMT, 2402, DMYBLKDATFMT
DMYCMADATFMT, 2403, DMYCMADATFMT
DMYHPNDATFMT, 2404, DMYHPNDATFMT
DMYPRDDATFMT, 2406, DMYPRDDATFMT
DMYSLHDATFMT, 2409, DMYSLHDATFMT
DRPPKG, 2007, DRPPKG
DSCERRCD, 2101, DSCERRCD
DSCINVRM, 220A, DSCINVRM
DSCRDBTBL, 2012, DSCRDBTBL
DSCSQLSTT, 2008, DSCSQLSTT
DSSFMT, 140D, DSSFMT
DTAMCHRM, 220E, DTAMCHRM
DUPQRYOK, 210B, DUPQRYOK
DYNDTAFMT, 214B, DYNDTAFMT
ELMCLS, 004D, ELMCLS
ENCALG, 1909, ENCALG
ENCKEYLEN, 190A, ENCKEYLEN
ENDATMCHN, 1804, ENDATMCHN
ENDBND, 2009, ENDBND
ENDCHNTYP, 1902, ENDCHNTYP
ENDDTARM, 2214, ENDDTARM
ENDQRYRM, 220B, ENDQRYRM
ENDREF, 2163, ENDREF
ENDUOWRM, 220C, ENDUOWRM
ENUCLS, 0040, ENUCLS
ENULEN, 0015, ENULEN
ENUVAL, 0016, ENUVAL
ERROR, 0017, ERROR
ETIME, 1901, ETIME
EURDATFMT, 242B, EURDATFMT
EURTIMFMT, 2430, EURTIMFMT
EXCSAT, 1041, EXCSAT
EXCSATRD, 1443, EXCSATRD
EXCSQLIMM, 200A, EXCSQLIMM
EXCSQLSET, 2014, EXCSQLSET
EXCSQLSTT, 200B, EXCSQLSTT
EXPALL, 243B, EXPALL
EXPNON, 243A, EXPNON
EXPREOPT, 2459, EXPREOPT
EXPYES, 240A, EXPYES
EXTDTA, 146C, EXTDTA
EXTNAM, 115E, EXTNAM
FALSE, 0018, FALSE
FDODSC, 0010, FDODSC
FDODSCOFF, 2118, FDODSCOFF
FDODTA, 147A, FDODTA
FDODTAOFF, 2119, FDODTAOFF
FDOEXT, 147B, FDOEXT
FDOOBJ, 1480, FDOOBJ
FDOOFF, 147D, FDOOFF
FDOPRMOFF, 212B, FDOPRMOFF
FDOTRPOFF, 212A, FDOTRPOFF
FIELD, 006A, FIELD
FIXROWPRC, 2418, FIXROWPRC
FORGET, 1186, FORGET
FRCFIXROW, 2410, FRCFIXROW
FREPRVREF, 214C, FREPRVREF
FREREFOPT, 214D, FREREFOPT
GETNXTCHK, 2015, GETNXTCHK
GETNXTLEN, 214E, GETNXTLEN
GETNXTREF, 214F, GETNXTREF
HELP, 0019, HELP
HEXDR, 001A, HEXDR
HEXSTRDR, 001B, HEXSTRDR
HMSBLKTIMFMT, 240C, HMSBLKTIMFMT
HMSCLNTIMFMT, 240D, HMSCLNTIMFMT
HMSCMATIMFMT, 2416, HMSCMATIMFMT
HMSPRDTIMFMT, 2428, HMSPRDTIMFMT
IGNORABLE, 001C, IGNORABLE
INFO, 001E, INFO
INHERITED, 0049, INHERITED
INSTANCE_OF, 005D, INSTANCE_OF
INTRDBRQS, 2003, INTRDBRQS
INTTKNRM, 2210, INTTKNRM
IPADDR, 11E8, IPADDR
ISODATFMT, 2429, ISODATFMT
ISOLVLALL, 2443, ISOLVLALL
ISOLVLCHG, 2441, ISOLVLCHG
ISOLVLCS, 2442, ISOLVLCS
ISOLVLNC, 2445, ISOLVLNC
ISOLVLRR, 2444, ISOLVLRR
ISOTIMFMT, 242E, ISOTIMFMT
JISDATFMT, 242C, JISDATFMT
JISTIMFMT, 2431, JISTIMFMT
JULBLKDATFMT, 242D, JULBLKDATFMT
JULCMADATFMT, 243F, JULCMADATFMT
JULHPNDATFMT, 2440, JULHPNDATFMT
JULPRDDATFMT, 2446, JULPRDDATFMT
JULSLHDATFMT, 2447, JULSLHDATFMT
KERSECPPL, 1C02, KERSECPPL
LENGTH, 001F, LENGTH
LMTBLKPRC, 2417, LMTBLKPRC
LOCDATFMT, 2448, LOCDATFMT
LOCTIMFMT, 2449, LOCTIMFMT
LOGNAME, 1184, LOGNAME
LOGTSTMP, 1185, LOGTSTMP
LSTCHK, 2164, LSTCHK
MANAGER, 1456, MANAGER
MAXBLKEXT, 2141, MAXBLKEXT
MAXLEN, 0021, MAXLEN
MAXRSLCNT, 2140, MAXRSLCNT
MAXSCTNBR, 2127, MAXSCTNBR
MAXVAL, 0022, MAXVAL
MDYBLKDATFMT, 244A, MDYBLKDATFMT
MDYCMADATFMT, 244B, MDYCMADATFMT
MDYHPNDATFMT, 2451, MDYHPNDATFMT
MDYPRDDATFMT, 2452, MDYPRDDATFMT
MDYSLHDATFMT, 2453, MDYSLHDATFMT
MEDDTASZ, 2137, MEDDTASZ
MGRDEPRM, 1218, MGRDEPRM
MGRLVL, 1442, MGRLVL
MGRLVLLS, 1404, MGRLVLLS
MGRLVLN, 1473, MGRLVLN
MGRLVLOVR, 1C03, MGRLVLOVR
MGRLVLRM, 1210, MGRLVLRM
MGRNAM, 1452, MGRNAM
MINLEN, 0025, MINLEN
MINLVL, 0002, MINLVL
MINVAL, 0026, MINVAL
MONITOR, 1900, MONITOR
MONITORRD, 1C00, MONITORRD
MTLEXC, 0067, MTLEXC
MTLINC, 00A7, MTLINC
NAMDR, 0066, NAMDR
NAME, 0027, NAME
NAMSYMDR, 0061, NAMSYMDR
NBRROW, 213A, NBRROW
NCHARDR, 0068, NCHARDR
NCHRSTRDR, 0069, NCHRSTRDR
NEWPASSWORD, 11DE, NEWPASSWORD
NIL, 002A, NIL
NOTE, 0014, NOTE
NUMBER, 002B, NUMBER
OBJDSS, 1429, OBJDSS
OBJECT, 002C, OBJECT
OBJNSPRM, 1253, OBJNSPRM
OPNQFLRM, 2212, OPNQFLRM
OPNQRY, 200C, OPNQRY
OPNQRYRM, 2205, OPNQRYRM
OPTIONAL, 002D, OPTIONAL
ORDCOL, 004C, ORDCOL
OUTEXP, 2111, OUTEXP
OUTOVR, 2415, OUTOVR
OUTOVROPT, 2147, OUTOVROPT
PASSWORD, 11A1, PASSWORD
PKGATHKP, 2425, PKGATHKP
PKGATHOPT, 211E, PKGATHOPT
PKGATHRUL, 213F, PKGATHRUL
PKGATHRVK, 2424, PKGATHRVK
PKGBNARM, 2206, PKGBNARM
PKGBPARM, 2209, PKGBPARM
PKGCNSTKN, 210D, PKGCNSTKN
PKGDFTCC, 119A, PKGDFTCC
PKGDFTCST, 2125, PKGDFTCST
PKGID, 2109, PKGID
PKGIDANY, 216A, PKGIDANY
PKGISOLVL, 2124, PKGISOLVL
PKGNAM, 210A, PKGNAM
PKGNAMCSN, 2113, PKGNAMCSN
PKGNAMCT, 2112, PKGNAMCT
PKGOWNID, 2131, PKGOWNID
PKGRPLALW, 241F, PKGRPLALW
PKGRPLNA, 2420, PKGRPLNA
PKGRPLOPT, 211C, PKGRPLOPT
PKGRPLVRS, 212D, PKGRPLVRS
PKGSN, 210C, PKGSN
PKGSNLST, 2139, PKGSNLST
PKTOBJ, 1C04, PKTOBJ
PLGINCNT, 190F, PLGINCNT
PLGINID, 190D, PLGINID
PLGINLSE, 1910, PLGINLSE
PLGINLST, 190E, PLGINLST
PLGINNM, 190C, PLGINNM
PLGINPPL, 1911, PLGINPPL
PRCCNVCD, 113F, PRCCNVCD
PRCCNVRM, 1245, PRCCNVRM
PRCNAM, 2138, PRCNAM
PRDDTA, 2104, PRDDTA
PRDID, 112E, PRDID
PRMDMG, 002E, PRMDMG
PRMNSPRM, 1251, PRMNSPRM
PRPHRCLST, 1905, PRPHRCLST
PRPSQLSTT, 200D, PRPSQLSTT
PRPSTTKP, 2167, PRPSTTKP
QLFATT, 0007, QLFATT
QRYATTSCR, 2149, QRYATTSCR
QRYATTSET, 214A, QRYATTSET
QRYATTSNS, 2157, QRYATTSNS
QRYATTUPD, 2150, QRYATTUPD
QRYBLKCTL, 2132, QRYBLKCTL
QRYBLKFCT, 215F, QRYBLKFCT
QRYBLKRST, 2154, QRYBLKRST
QRYBLKSZ, 2114, QRYBLKSZ
QRYBLKTYP, 2133, QRYBLKTYP
QRYCLSIMP, 215D, QRYCLSIMP
QRYCLSRLS, 215E, QRYCLSRLS
QRYDSC, 241A, QRYDSC
QRYDTA, 241B, QRYDTA
QRYEXTDTASZ, 2134, QRYEXTDTASZ
QRYINSID, 215B, QRYINSID
QRYNOPRM, 2202, QRYNOPRM
QRYPOPRM, 220F, QRYPOPRM
QRYPRCTYP, 2102, QRYPRCTYP
QRYROWNBR, 213D, QRYROWNBR
QRYROWSET, 2156, QRYROWSET
QRYROWSNS, 2153, QRYROWSNS
QRYRTNDTA, 2155, QRYRTNDTA
QRYSCRORN, 2152, QRYSCRORN
RDB, 240F, RDB
RDBACCCL, 210F, RDBACCCL
RDBACCRM, 2207, RDBACCRM
RDBAFLRM, 221A, RDBAFLRM
RDBALWUPD, 211A, RDBALWUPD
RDBATHRM, 2203, RDBATHRM
RDBCMM, 200E, RDBCMM
RDBCMTOK, 2105, RDBCMTOK
RDBCOLID, 2108, RDBCOLID
RDBCOLIDANY, 2169, RDBCOLIDANY
RDBINTTKN, 2103, RDBINTTKN
RDBNACRM, 2204, RDBNACRM
RDBNAM, 2110, RDBNAM
RDBNFNRM, 2211, RDBNFNRM
RDBRLLBCK, 200F, RDBRLLBCK
RDBRLSCMM, 2438, RDBRLSCMM
RDBRLSCNV, 2439, RDBRLSCNV
RDBRLSOPT, 2129, RDBRLSOPT
RDBSRCCOLID, 2168, RDBSRCCOLID
RDBUPDRM, 2218, RDBUPDRM
REBIND, 2010, REBIND
REFRST, 2162, REFRST
REPEATABLE, 0031, REPEATABLE
REQUIRED, 0032, REQUIRED
RESERVED, 0033, RESERVED
RESPKTSZ, 1908, RESPKTSZ
RLSCONV, 119F, RLSCONV
RPYDSS, 1436, RPYDSS
RPYMSG, 1437, RPYMSG
RQSCRR, 1438, RQSCRR
RQSDSS, 1439, RQSDSS
RSCLMTRM, 1233, RSCLMTRM
RSCNAM, 112D, RSCNAM
RSCTYP, 111F, RSCTYP
RSLSETFLG, 2142, RSLSETFLG
RSLSETRM, 2219, RSLSETRM
RSNCOD, 1127, RSNCOD
RSYNCMGR, 14C1, RSYNCMGR
RSYNCTYP, 11EA, RSYNCTYP
RTNEXTDTA, 2148, RTNEXTDTA
RTNSETSTT, 210E, RTNSETSTT
RTNSQLDA, 2116, RTNSQLDA
SCALAR, 0034, SCALAR
SCLDTALEN, 0100, SCLDTALEN
SECCHK, 106E, SECCHK
SECCHKCD, 11A4, SECCHKCD
SECCHKRM, 1219, SECCHKRM
SECMEC, 11A2, SECMEC
SECMGR, 1440, SECMGR
SECMGRNM, 1196, SECMGRNM
SECTKN, 11DC, SECTKN
SECTKNOVR, 190B, SECTKNOVR
SERVER, 1448, SERVER
SESDMG, 003F, SESDMG
SEVERE, 003A, SEVERE
SMLDTASZ, 2136, SMLDTASZ
SNAADDR, 11E9, SNAADDR
SNDPKT, 1805, SNDPKT
SPCVAL, 0036, SPCVAL
SPRCLS, 0037, SPRCLS
SPVNAM, 115D, SPVNAM
SQLAM, 2407, SQLAM
SQLATTR, 2450, SQLATTR
SQLCARD, 2408, SQLCARD
SQLCINRD, 240B, SQLCINRD
SQLCSRHLD, 211F, SQLCSRHLD
SQLDARD, 2411, SQLDARD
SQLDTA, 2412, SQLDTA
SQLDTARD, 2413, SQLDTARD
SQLERRRM, 2213, SQLERRRM
SQLOBJNAM, 243E, SQLOBJNAM
SQLRSLRD, 240E, SQLRSLRD
SQLSTT, 2414, SQLSTT
SQLSTTNBR, 2117, SQLSTTNBR
SQLSTTVRB, 2419, SQLSTTVRB
SRVCLSNM, 1147, SRVCLSNM
SRVDGN, 1153, SRVDGN
SRVLCNT, 244C, SRVLCNT
SRVLSRV, 244D, SRVLSRV
SRVLST, 244E, SRVLST
SRVNAM, 116D, SRVNAM
SRVPRTY, 244F, SRVPRTY
SRVRLSLV, 115A, SRVRLSLV
STGLMT, 1409, STGLMT
STRDELAP, 2426, STRDELAP
STRDELDQ, 2427, STRDELDQ
STRING, 0038, STRING
STTASMEUI, 2437, STTASMEUI
STTDATFMT, 2122, STTDATFMT
STTDECDEL, 2121, STTDECDEL
STTSCCCLS, 2436, STTSCCCLS
STTSTRDEL, 2120, STTSTRDEL
STTTIMFMT, 2123, STTTIMFMT
SUPERVISOR, 143C, SUPERVISOR
SVCERRNO, 11B4, SVCERRNO
SVRCOD, 1149, SVRCOD
SYNCCRD, 1248, SYNCCRD
SYNCCTL, 1055, SYNCCTL
SYNCLOG, 106F, SYNCLOG
SYNCPTMGR, 14C0, SYNCPTMGR
SYNCRRD, 126D, SYNCRRD
SYNCRSY, 1069, SYNCRSY
SYNCTYPE, 1187, SYNCTYPE
SYNERRCD, 114A, SYNERRCD
SYNTAXRM, 124C, SYNTAXRM
TCPHOST, 11DD, TCPHOST
TCPPORTHOST, 1912, TCPPORTHOST
TEXT, 114B, TEXT
TIMEOUT, 1907, TIMEOUT
TITLE, 0045, TITLE
TRGDFTRT, 213B, TRGDFTRT
TRGNSPRM, 125F, TRGNSPRM
TRUE, 003B, TRUE
TRUST, 212C, TRUST
TYPDEF, 0029, TYPDEF
TYPDEFNAM, 002F, TYPDEFNAM
TYPDEFOVR, 0035, TYPDEFOVR
TYPFMLNM, 0030, TYPFMLNM
TYPSQLDA, 2146, TYPSQLDA
UNICODEMGR, 1C08, UNICODEMGR
UNORDERED, 14B1, UNORDERED
UNPUPD, 2158, UNPUPD
UNPUPDALW, 2165, UNPUPDALW
UOWDSP, 2115, UOWDSP
UOWID, 11AA, UOWID
UOWSTATE, 11AC, UOWSTATE
USADATFMT, 242A, USADATFMT
USATIMFMT, 242F, USATIMFMT
USRID, 11A0, USRID
USRORGID, 1C06, USRORGID
USRREGNM, 1C05, USRREGNM
USRSECTOK, 1C07, USRSECTOK
VALNSPRM, 1252, VALNSPRM
VRSNAM, 1144, VRSNAM
VRSNAMANY, 216B, VRSNAMANY
WARNING, 003D, WARNING
XAFLAGS, 1903, XAFLAGS
XAMGR, 1C01, XAMGR
XARETVAL, 1904, XARETVAL
XID, 1801, XID
XIDCNT, 1906, XIDCNT
XIDSHR, 1802, XIDSHR
YMDBLKDATFMT, 2454, YMDBLKDATFMT
YMDCMADATFMT, 2455, YMDCMADATFMT
YMDHPNDATFMT, 2456, YMDHPNDATFMT
YMDPRDDATFMT, 2457, YMDPRDDATFMT
YMDSLHDATFMT, 2458, YMDSLHDATFMT
=========================================

3. Codepoint Term Mapping - Sorted by Codepoints:

Codepoint(Hex), TERM NAME, TEXT
=========================================
 0001, ASSOCIATION, ASSOCIATION
0002, MINLVL, MINLVL
0003, BIN, BIN
0004, BITDR, BITDR
0005, BITSTRDR, BITSTRDR
0006, BOOLEAN, BOOLEAN
0007, QLFATT, QLFATT
0008, CHRDR, CHRDR
0009, CHRSTRDR, CHRSTRDR
000A, CLASS, CLASS
000B, CNSVAL, CNSVAL
000C, CODPNT, CODPNT
000D, COLLECTION, COLLECTION
000E, COMMAND, COMMAND
0010, FDODSC, FDODSC
0011, DFTVAL, DFTVAL
0014, NOTE, NOTE
0015, ENULEN, ENULEN
0016, ENUVAL, ENUVAL
0017, ERROR, ERROR
0018, FALSE, FALSE
0019, HELP, HELP
001A, HEXDR, HEXDR
001B, HEXSTRDR, HEXSTRDR
001C, IGNORABLE, IGNORABLE
001E, INFO, INFO
001F, LENGTH, LENGTH
0021, MAXLEN, MAXLEN
0022, MAXVAL, MAXVAL
0025, MINLEN, MINLEN
0026, MINVAL, MINVAL
0027, NAME, NAME
0029, TYPDEF, TYPDEF
002A, NIL, NIL
002B, NUMBER, NUMBER
002C, OBJECT, OBJECT
002D, OPTIONAL, OPTIONAL
002E, PRMDMG, PRMDMG
002F, TYPDEFNAM, TYPDEFNAM
0030, TYPFMLNM, TYPFMLNM
0031, REPEATABLE, REPEATABLE
0032, REQUIRED, REQUIRED
0033, RESERVED, RESERVED
0034, SCALAR, SCALAR
0035, TYPDEFOVR, TYPDEFOVR
0036, SPCVAL, SPCVAL
0037, SPRCLS, SPRCLS
0038, STRING, STRING
003A, SEVERE, SEVERE
003B, TRUE, TRUE
003C, DATA, DATA
003D, WARNING, WARNING
003E, ACCDMG, ACCDMG
003F, SESDMG, SESDMG
0040, ENUCLS, ENUCLS
0041, CMDTRG, CMDTRG
0042, BINDR, BINDR
0043, BYTDR, BYTDR
0044, BYTSTRDR, BYTSTRDR
0045, TITLE, TITLE
0046, ATTLST, ATTLST
0047, DEFLST, DEFLST
0048, DEFINITION, DEFINITION
0049, INHERITED, INHERITED
004B, ARRAY, ARRAY
004C, ORDCOL, ORDCOL
004D, ELMCLS, ELMCLS
0050, CONSTANT, CONSTANT
005D, INSTANCE_OF, INSTANCE_OF
0061, NAMSYMDR, NAMSYMDR
0064, CODPNTDR, CODPNTDR
0066, NAMDR, NAMDR
0067, MTLEXC, MTLEXC
0068, NCHARDR, NCHARDR
0069, NCHRSTRDR, NCHRSTRDR
006A, FIELD, FIELD
00A7, MTLINC, MTLINC
0100, SCLDTALEN, SCLDTALEN
1041, EXCSAT, EXCSAT
1055, SYNCCTL, SYNCCTL
1069, SYNCRSY, SYNCRSY
106D, ACCSEC, ACCSEC
106E, SECCHK, SECCHK
106F, SYNCLOG, SYNCLOG
1070, CNNTKN, CNNTKN
111F, RSCTYP, RSCTYP
1127, RSNCOD, RSNCOD
112D, RSCNAM, RSCNAM
112E, PRDID, PRDID
113F, PRCCNVCD, PRCCNVCD
1144, VRSNAM, VRSNAM
1147, SRVCLSNM, SRVCLSNM
1149, SVRCOD, SVRCOD
114A, SYNERRCD, SYNERRCD
114B, TEXT, TEXT
1153, SRVDGN, SRVDGN
115A, SRVRLSLV, SRVRLSLV
115D, SPVNAM, SPVNAM
115E, EXTNAM, EXTNAM
116D, SRVNAM, SRVNAM
1184, LOGNAME, LOGNAME
1185, LOGTSTMP, LOGTSTMP
1186, FORGET, FORGET
1187, SYNCTYPE, SYNCTYPE
1196, SECMGRNM, SECMGRNM
119A, PKGDFTCC, PKGDFTCC
119B, DEPERRCD, DEPERRCD
119C, CCSIDSBC, CCSIDSBC
119D, CCSIDDBC, CCSIDDBC
119E, CCSIDMBC, CCSIDMBC
119F, RLSCONV, RLSCONV
11A0, USRID, USRID
11A1, PASSWORD, PASSWORD
11A2, SECMEC, SECMEC
11A4, SECCHKCD, SECCHKCD
11AA, UOWID, UOWID
11AC, UOWSTATE, UOWSTATE
11B4, SVCERRNO, SVCERRNO
11DC, SECTKN, SECTKN
11DD, TCPHOST, TCPHOST
11DE, NEWPASSWORD, NEWPASSWORD
11E8, IPADDR, IPADDR
11E9, SNAADDR, SNAADDR
11EA, RSYNCTYP, RSYNCTYP
1210, MGRLVLRM, MGRLVLRM
1218, MGRDEPRM, MGRDEPRM
1219, SECCHKRM, SECCHKRM
121C, CMDATHRM, CMDATHRM
1232, AGNPRMRM, AGNPRMRM
1233, RSCLMTRM, RSCLMTRM
1245, PRCCNVRM, PRCCNVRM
1248, SYNCCRD, SYNCCRD
124B, CMDCMPRM, CMDCMPRM
124C, SYNTAXRM, SYNTAXRM
1250, CMDNSPRM, CMDNSPRM
1251, PRMNSPRM, PRMNSPRM
1252, VALNSPRM, VALNSPRM
1253, OBJNSPRM, OBJNSPRM
1254, CMDCHKRM, CMDCHKRM
125F, TRGNSPRM, TRGNSPRM
126D, SYNCRRD, SYNCRRD
1403, AGENT, AGENT
1404, MGRLVLLS, MGRLVLLS
1408, CMNMGR, CMNMGR
1409, STGLMT, STGLMT
140D, DSSFMT, DSSFMT
1429, OBJDSS, OBJDSS
1436, RPYDSS, RPYDSS
1437, RPYMSG, RPYMSG
1438, RQSCRR, RQSCRR
1439, RQSDSS, RQSDSS
143C, SUPERVISOR, SUPERVISOR
1440, SECMGR, SECMGR
1442, MGRLVL, MGRLVL
1443, EXCSATRD, EXCSATRD
1444, CMNAPPC, CMNAPPC
1448, SERVER, SERVER
1450, DCTIND, DCTIND
1451, DCTINDEN, DCTINDEN
1452, MGRNAM, MGRNAM
1456, MANAGER, MANAGER
1458, DICTIONARY, DICTIONARY
146C, EXTDTA, EXTDTA
1473, MGRLVLN, MGRLVLN
1474, CMNTCPIP, CMNTCPIP
147A, FDODTA, FDODTA
147B, FDOEXT, FDOEXT
147C, CMNSYNCPT, CMNSYNCPT
147D, FDOOFF, FDOOFF
1480, FDOOBJ, FDOOBJ
14AC, ACCSECRD, ACCSECRD
14B1, UNORDERED, UNORDERED
14C0, SYNCPTMGR, SYNCPTMGR
14C1, RSYNCMGR, RSYNCMGR
14CC, CCSIDMGR, CCSIDMGR
1801, XID, XID
1802, XIDSHR, XIDSHR
1803, BGNATMCHN, BGNATMCHN
1804, ENDATMCHN, ENDATMCHN
1805, SNDPKT, SNDPKT
1900, MONITOR, MONITOR
1901, ETIME, ETIME
1902, ENDCHNTYP, ENDCHNTYP
1903, XAFLAGS, XAFLAGS
1904, XARETVAL, XARETVAL
1905, PRPHRCLST, PRPHRCLST
1906, XIDCNT, XIDCNT
1907, TIMEOUT, TIMEOUT
1908, RESPKTSZ, RESPKTSZ
1909, ENCALG, ENCALG
190A, ENCKEYLEN, ENCKEYLEN
190B, SECTKNOVR, SECTKNOVR
190C, PLGINNM, PLGINNM
190D, PLGINID, PLGINID
190E, PLGINLST, PLGINLST
190F, PLGINCNT, PLGINCNT
1910, PLGINLSE, PLGINLSE
1911, PLGINPPL, PLGINPPL
1912, TCPPORTHOST, TCPPORTHOST
1913, CCSIDXML, CCSIDXML
1C00, MONITORRD, MONITORRD
1C01, XAMGR, XAMGR
1C02, KERSECPPL, KERSECPPL
1C03, MGRLVLOVR, MGRLVLOVR
1C04, PKTOBJ, PKTOBJ
1C05, USRREGNM, USRREGNM
1C06, USRORGID, USRORGID
1C07, USRSECTOK, USRSECTOK
1C08, UNICODEMGR, UNICODEMGR
2001, ACCRDB, ACCRDB
2002, BGNBND, BGNBND
2003, INTRDBRQS, INTRDBRQS
2004, BNDSQLSTT, BNDSQLSTT
2005, CLSQRY, CLSQRY
2006, CNTQRY, CNTQRY
2007, DRPPKG, DRPPKG
2008, DSCSQLSTT, DSCSQLSTT
2009, ENDBND, ENDBND
200A, EXCSQLIMM, EXCSQLIMM
200B, EXCSQLSTT, EXCSQLSTT
200C, OPNQRY, OPNQRY
200D, PRPSQLSTT, PRPSQLSTT
200E, RDBCMM, RDBCMM
200F, RDBRLLBCK, RDBRLLBCK
2010, REBIND, REBIND
2011, BNDCPY, BNDCPY
2012, DSCRDBTBL, DSCRDBTBL
2014, EXCSQLSET, EXCSQLSET
2015, GETNXTCHK, GETNXTCHK
2016, BNDDPLY, BNDDPLY
2101, DSCERRCD, DSCERRCD
2102, QRYPRCTYP, QRYPRCTYP
2103, RDBINTTKN, RDBINTTKN
2104, PRDDTA, PRDDTA
2105, RDBCMTOK, RDBCMTOK
2106, DECPRC, DECPRC
2107, CMDSRCID, CMDSRCID
2108, RDBCOLID, RDBCOLID
2109, PKGID, PKGID
210A, PKGNAM, PKGNAM
210B, DUPQRYOK, DUPQRYOK
210C, PKGSN, PKGSN
210D, PKGCNSTKN, PKGCNSTKN
210E, RTNSETSTT, RTNSETSTT
210F, RDBACCCL, RDBACCCL
2110, RDBNAM, RDBNAM
2111, OUTEXP, OUTEXP
2112, PKGNAMCT, PKGNAMCT
2113, PKGNAMCSN, PKGNAMCSN
2114, QRYBLKSZ, QRYBLKSZ
2115, UOWDSP, UOWDSP
2116, RTNSQLDA, RTNSQLDA
2117, SQLSTTNBR, SQLSTTNBR
2118, FDODSCOFF, FDODSCOFF
2119, FDODTAOFF, FDODTAOFF
211A, RDBALWUPD, RDBALWUPD
211B, BNDCHKEXS, BNDCHKEXS
211C, PKGRPLOPT, PKGRPLOPT
211D, BNDCRTCTL, BNDCRTCTL
211E, PKGATHOPT, PKGATHOPT
211F, SQLCSRHLD, SQLCSRHLD
2120, STTSTRDEL, STTSTRDEL
2121, STTDECDEL, STTDECDEL
2122, STTDATFMT, STTDATFMT
2123, STTTIMFMT, STTTIMFMT
2124, PKGISOLVL, PKGISOLVL
2125, PKGDFTCST, PKGDFTCST
2126, BNDSTTASM, BNDSTTASM
2127, MAXSCTNBR, MAXSCTNBR
2128, DFTRDBCOL, DFTRDBCOL
2129, RDBRLSOPT, RDBRLSOPT
212A, FDOTRPOFF, FDOTRPOFF
212B, FDOPRMOFF, FDOPRMOFF
212C, TRUST, TRUST
212D, PKGRPLVRS, PKGRPLVRS
212F, DGRIOPRL, DGRIOPRL
2130, BNDEXPOPT, BNDEXPOPT
2131, PKGOWNID, PKGOWNID
2132, QRYBLKCTL, QRYBLKCTL
2133, QRYBLKTYP, QRYBLKTYP
2134, QRYEXTDTASZ, QRYEXTDTASZ
2135, CRRTKN, CRRTKN
2136, SMLDTASZ, SMLDTASZ
2137, MEDDTASZ, MEDDTASZ
2138, PRCNAM, PRCNAM
2139, PKGSNLST, PKGSNLST
213A, NBRROW, NBRROW
213B, TRGDFTRT, TRGDFTRT
213D, QRYROWNBR, QRYROWNBR
213F, PKGATHRUL, PKGATHRUL
2140, MAXRSLCNT, MAXRSLCNT
2141, MAXBLKEXT, MAXBLKEXT
2142, RSLSETFLG, RSLSETFLG
2143, CMMTYP, CMMTYP
2144, BNDOPTNM, BNDOPTNM
2145, BNDOPTVL, BNDOPTVL
2146, TYPSQLDA, TYPSQLDA
2147, OUTOVROPT, OUTOVROPT
2148, RTNEXTDTA, RTNEXTDTA
2149, QRYATTSCR, QRYATTSCR
214A, QRYATTSET, QRYATTSET
214B, DYNDTAFMT, DYNDTAFMT
214C, FREPRVREF, FREPRVREF
214D, FREREFOPT, FREREFOPT
214E, GETNXTLEN, GETNXTLEN
214F, GETNXTREF, GETNXTREF
2150, QRYATTUPD, QRYATTUPD
2152, QRYSCRORN, QRYSCRORN
2153, QRYROWSNS, QRYROWSNS
2154, QRYBLKRST, QRYBLKRST
2155, QRYRTNDTA, QRYRTNDTA
2156, QRYROWSET, QRYROWSET
2157, QRYATTSNS, QRYATTSNS
2158, UNPUPD, UNPUPD
2159, ATMIND, ATMIND
215B, QRYINSID, QRYINSID
215C, BUFINSIND, BUFINSIND
215D, QRYCLSIMP, QRYCLSIMP
215E, QRYCLSRLS, QRYCLSRLS
215F, QRYBLKFCT, QRYBLKFCT
2160, DIAGLVL, DIAGLVL
2161, ARMCORR, ARMCORR
2162, REFRST, REFRST
2163, ENDREF, ENDREF
2164, LSTCHK, LSTCHK
2165, UNPUPDALW, UNPUPDALW
2167, PRPSTTKP, PRPSTTKP
2168, RDBSRCCOLID, RDBSRCCOLID
2169, RDBCOLIDANY, RDBCOLIDANY
216A, PKGIDANY, PKGIDANY
216B, VRSNAMANY, VRSNAMANY
2201, ACCRDBRM, ACCRDBRM
2202, QRYNOPRM, QRYNOPRM
2203, RDBATHRM, RDBATHRM
2204, RDBNACRM, RDBNACRM
2205, OPNQRYRM, OPNQRYRM
2206, PKGBNARM, PKGBNARM
2207, RDBACCRM, RDBACCRM
2208, BGNBNDRM, BGNBNDRM
2209, PKGBPARM, PKGBPARM
220A, DSCINVRM, DSCINVRM
220B, ENDQRYRM, ENDQRYRM
220C, ENDUOWRM, ENDUOWRM
220D, ABNUOWRM, ABNUOWRM
220E, DTAMCHRM, DTAMCHRM
220F, QRYPOPRM, QRYPOPRM
2210, INTTKNRM, INTTKNRM
2211, RDBNFNRM, RDBNFNRM
2212, OPNQFLRM, OPNQFLRM
2213, SQLERRRM, SQLERRRM
2214, ENDDTARM, ENDDTARM
2218, RDBUPDRM, RDBUPDRM
2219, RSLSETRM, RSLSETRM
221A, RDBAFLRM, RDBAFLRM
221D, CMDVLTRM, CMDVLTRM
2225, CMMRQSRM, CMMRQSRM
2400, DFTDATFMT, DFTDATFMT
2401, DFTTIMFMT, DFTTIMFMT
2402, DMYBLKDATFMT, DMYBLKDATFMT
2403, DMYCMADATFMT, DMYCMADATFMT
2404, DMYHPNDATFMT, DMYHPNDATFMT
2405, BNDOPT, BNDOPT
2406, DMYPRDDATFMT, DMYPRDDATFMT
2407, SQLAM, SQLAM
2408, SQLCARD, SQLCARD
2409, DMYSLHDATFMT, DMYSLHDATFMT
240A, EXPYES, EXPYES
240B, SQLCINRD, SQLCINRD
240C, HMSBLKTIMFMT, HMSBLKTIMFMT
240D, HMSCLNTIMFMT, HMSCLNTIMFMT
240E, SQLRSLRD, SQLRSLRD
240F, RDB, RDB
2410, FRCFIXROW, FRCFIXROW
2411, SQLDARD, SQLDARD
2412, SQLDTA, SQLDTA
2413, SQLDTARD, SQLDTARD
2414, SQLSTT, SQLSTT
2415, OUTOVR, OUTOVR
2416, HMSCMATIMFMT, HMSCMATIMFMT
2417, LMTBLKPRC, LMTBLKPRC
2418, FIXROWPRC, FIXROWPRC
2419, SQLSTTVRB, SQLSTTVRB
241A, QRYDSC, QRYDSC
241B, QRYDTA, QRYDTA
241C, BNDEXSRQR, BNDEXSRQR
241D, BNDEXSOPT, BNDEXSOPT
241E, DFTPKG, DFTPKG
241F, PKGRPLALW, PKGRPLALW
2420, PKGRPLNA, PKGRPLNA
2421, BNDCHKONL, BNDCHKONL
2422, BNDNERALW, BNDNERALW
2423, BNDERRALW, BNDERRALW
2424, PKGATHRVK, PKGATHRVK
2425, PKGATHKP, PKGATHKP
2426, STRDELAP, STRDELAP
2427, STRDELDQ, STRDELDQ
2428, HMSPRDTIMFMT, HMSPRDTIMFMT
2429, ISODATFMT, ISODATFMT
242A, USADATFMT, USADATFMT
242B, EURDATFMT, EURDATFMT
242C, JISDATFMT, JISDATFMT
242D, JULBLKDATFMT, JULBLKDATFMT
242E, ISOTIMFMT, ISOTIMFMT
242F, USATIMFMT, USATIMFMT
2430, EURTIMFMT, EURTIMFMT
2431, JISTIMFMT, JISTIMFMT
2432, CSTSYSDFT, CSTSYSDFT
2433, CSTBITS, CSTBITS
2434, CSTSBCS, CSTSBCS
2435, CSTMBCS, CSTMBCS
2436, STTSCCCLS, STTSCCCLS
2437, STTASMEUI, STTASMEUI
2438, RDBRLSCMM, RDBRLSCMM
2439, RDBRLSCNV, RDBRLSCNV
243A, EXPNON, EXPNON
243B, EXPALL, EXPALL
243C, DECDELPRD, DECDELPRD
243D, DECDELCMA, DECDELCMA
243E, SQLOBJNAM, SQLOBJNAM
243F, JULCMADATFMT, JULCMADATFMT
2440, JULHPNDATFMT, JULHPNDATFMT
2441, ISOLVLCHG, ISOLVLCHG
2442, ISOLVLCS, ISOLVLCS
2443, ISOLVLALL, ISOLVLALL
2444, ISOLVLRR, ISOLVLRR
2445, ISOLVLNC, ISOLVLNC
2446, JULPRDDATFMT, JULPRDDATFMT
2447, JULSLHDATFMT, JULSLHDATFMT
2448, LOCDATFMT, LOCDATFMT
2449, LOCTIMFMT, LOCTIMFMT
244A, MDYBLKDATFMT, MDYBLKDATFMT
244B, MDYCMADATFMT, MDYCMADATFMT
244C, SRVLCNT, SRVLCNT
244D, SRVLSRV, SRVLSRV
244E, SRVLST, SRVLST
244F, SRVPRTY, SRVPRTY
2450, SQLATTR, SQLATTR
2451, MDYHPNDATFMT, MDYHPNDATFMT
2452, MDYPRDDATFMT, MDYPRDDATFMT
2453, MDYSLHDATFMT, MDYSLHDATFMT
2454, YMDBLKDATFMT, YMDBLKDATFMT
2455, YMDCMADATFMT, YMDCMADATFMT
2456, YMDHPNDATFMT, YMDHPNDATFMT
2457, YMDPRDDATFMT, YMDPRDDATFMT
2458, YMDSLHDATFMT, YMDSLHDATFMT
2459, EXPREOPT, EXPREOPT
 =========================================

If you'd like to save them into an .csv file, just simple copy/paste into an text editor and use excel to open up the .csv file you will get a nice format of term-codepoint mapping table in spreadsheet.

If you'd like to code it, copy into your enum data type or variables or use the perl script similar to following to manipulate it on your will.

=========================================
#!/usr/bin/perl

# -------------------------------------------------
# Usage:
#     perl pasrsDDMTerm.pl input output
# ------------------------------------------------

my $input  = shift;
my $output = shift;

open(FH,"+<$output") or die "Failed to open file. $!";
open INPUT,"<$input" or die "Failed to open file. $!";

foreach my $line (<INPUT>) {
    #print $line;
    my @Token = split (/ /,$line);
   
    print FH "$Token[0], $Token[1], $Token[2]\n";
   
}

close INPUT;
close FH;
=========================================

Enjoy~

- Wenyan

Thursday, March 6, 2014

PostgreSQL Simple Select Query Sequence Diagram


Friday, February 28, 2014

PostgreSQL Database Engine Architecture 1.1


Dear database engine lovers,

For those like nice looking pictures, I came up with this one, hope it saves your time, detail please follow not just the flowchart, source code, or the story of postgreSQL engine, but also your own gut.

Enjoy~

- Wenyan



Reference:
  - http://www.postgresql.org/developer/backend/

Sunday, March 9, 2008

first trial

building Ogre3D: (Done)

- VC 2005 Expression + Window SDK 2003 R2 + Ogre3D SDK

building Mozilla: (Failed)

- xpt_link.exe - Unable To Locate Component "This application has failed to start because MSVCR80.dll was not found. Re-installing the application may fix this problem."

- VC2005 Expression might not work for this, it's not official supported by mozilla.

Let's get it started

Since it's being started from a blank, I use the simple black template.