SQL - SYSIBM.SYSSTRINGS - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSSTRINGS

Contains information about character conversion.
Each row describes a conversion from one coded character set to another.

Nome da coluna Tipo de dados Descrição Uso
 INCCSID  INTEGER NOT NULL  The source CCSID for the character conversion represented by this row. G
 OUTCCSID  INTEGER NOT NULL  The target CCSID for the character conversion represented by this row. G
 TRANSTYPE  CHAR(2) NOT NULL  Indicates the nature of the conversion. Values can be:

 GG    GRAPHIC to GRAPHIC
 MM    EBCDIC MIXED to EBCDIC MIXED
 MS    EBCDIC MIXED to SBCS
 PM    ASCII MIXED to EBCDIC MIXED
 PS    ASCII MIXED to SBCS
 SM    SBCS to EBCDIC MIXED
 SS    SBCS to SBCS
 MP    EBCDIC MIXED to ASCII MIXED
 PP    ASCII MIXED to ASCII MIXED
 SP    SBCS to ASCII MIXED		 G
 ERRORBYTE  CHAR(1) FOR BIT
 DATA (Nulls are all)		  The byte used in the conversion table as an error byte. Null empty  windicates the absence of an error byte. S
 SUBBYTE  CHAR(1) FOR BIT
 DATA (Nulls are all)		  The byte used in the conversion table as a substitution wcharacter. Null  empty string indicates the absence of a substitution character. S
 TRANSPROC  CHAR(8) NOT NULL
 WITH DEFAULT		  The name of a module or blanks. If IBMREQD is 'N', a nonblank value is  the name of a conversion procedure provided by the user. If IBMREQD is  'Y', a nonblank value is the name of a DB2 module that contains DBCS  conversion tables. The first five characters of the name of a
 user-provided conversion procedure must not be 'DSNXV'; these  characters are used to distinguish user-provided conversion procedures  from DB2 modules that contain DBCS conversion tables.		 G
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the basic machine-readable material (MRM)  tape (see the information following this table):

 N    No

 Y    Yes		 G
 TRANSTAB  VARCHAR(256) FOR BIT DATA
 NOT NULL WITH DEFAULT		  Either a conversion table or an empty string G

Each row in the table must have a unique combination of values for its INCCSID, OUTCCSID, and IBMREQD columns.
Rows for which the value of IBMREQD is N can be deleted, inserted, and updated subject to this uniqueness constraint and to the constraints imposed by a VALIDPROC defined on the table.
An inserted row could have values for the INCCSID and OUTCCSID columns that match those of a row for which the value of IBMREQD is Y.
DB2 would then use the information in the inserted row instead of the information in the IBM-supplied row.
Rows for which the value of IBMREQD is Y cannot be deleted, inserted, or updated. For information about the use of inserted rows for character conversion, see Appendix C of Installation Guide.


© Copyright IBM Corp.