Dynamic Server also supports the BOOLEAN data type, which is a built-in opaque data type that can store true, false, or NULL values. The symbol t represents a literal BOOLEAN true, and f represents a literal BOOLEAN false.
Like other built-in opaque data types, BOOLEAN column values cannot be retrieved by a distributed query (nor modified by INSERT, DELETE, or UPDATE operations on a remote database) unless all of the tables that the DML operation accesses are in databases of the local Dynamic Server instance.
Values of BOOLEAN and other built-in opaque data types can be returned from a remote database by a UDR only if both of the following conditions are true:
Other built-in opaque data types of Dynamic Server include BLOB, CLOB, LVARCHAR, IFX_LO_SPEC, IFX_LO_STAT, INDEXKEYARRAY, POINTER, RTNPARAMTYPES, SELFUNCARGS, STAT, CLIENTBINVAL, and XID data types. The first three types are discussed in subsequent sections of this chapter.
Dynamic Server also supports the built-in opaque data types LOLIST, IMPEX, IMPEXBIN, and SENDRECV. These types cannot, however, be accessed in a remote database by DML operations, nor returned from a remote database by a UDR, because these data types do not have the required support functions.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]