DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
The schema is SYSIBM.
The TYPE_SCHEMA function returns the schema name of the dynamic data type of the expression.
The argument must be a user-defined structured type. This function cannot be used as a source function when creating a user-defined function. Because it accepts any structured data type as an argument, it is not necessary to create additional signatures to support different user-defined types.
The data type of the result of the function is VARCHAR(128). If expression can be null, the result can be null; if expression is null, the result is the null value. Use the TYPE_NAME function to determine the type name associated with the schema name returned by TYPE_SCHEMA.
