Properties

Name:	PERSON_T
Schema:	USER
Definer:	USER
Source schema:	SYSIBM
Source name:	VARCHAR
Length:	13
Scale:	0
Codepage:	0
Final:
Inline length:	74
Natural inline length:	74
Create time:	24.06.2006
Alter time:
Description:

SQL

CREATE TYPE "USER    "."PERSON_T"  AS
        ("NAME" VARCHAR(20),
         "AGE" INTEGER)
     INSTANTIABLE
     INLINE LENGTH 74
     WITHOUT COMPARISONS
     NOT FINAL
     REF USING VARCHAR(13) FOR BIT DATA
     MODE DB2SQL;

See Also

List of datatypes