sysusers  Chapter 2: dbccdb Tables

Chapter 1: System Tables

sysxtypes

All databases

Description

sysxtypes contains one row for each extended, Java-SQL datatype.

See Java in Adaptive Server Enterprise for more information about Java-SQL classes and datatypes.

Columns

The columns for sysxtypes are:

Name

Datatype

Description

xtid

int

System-generated ID for the extended type.

xtstatus

int

Internal status information. Unused.

xtmetatype

int

Unused.

xtcontainer

int

The ID of the JAR file containing the class. Can be NULL.

xtname

varchar(255) null

The name of the extended type.

xtsource

text null

Source code for the extended type. Unused.

xtbinaryinrow

varbinary(255) null

Object code for the extended type. For Java classes, it contains the class file. Data is stored in-row up to a length of 255 bytes.

xtbinaryoffrow

image

Object code for the extended type. For Java classes, it contains the class file. Data is stored off-row as an image column.

Indexes





Copyright © 2005. Sybase Inc. All rights reserved. Chapter 2: dbccdb Tables

View this book as PDF