Contents - Data types
system procedure.............................................................................................. 155
SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT
system procedure.............................................................................................. 156
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE system procedure..... 157
SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE system procedure........... 157
SYSCS_UTIL.SYSCS_COMPRESS_TABLE system procedure...................... 158
SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE system procedure..... 159
SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system
procedure...........................................................................................................161
SYSCS_UTIL.SYSCS_EXPORT_TABLE system procedure............................ 162
SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE system
procedure...........................................................................................................163
SYSCS_UTIL.SYSCS_EXPORT_QUERY system procedure.......................... 164
SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE system
procedure...........................................................................................................166
SYSCS_UTIL.SYSCS_IMPORT_DATA system procedure.............................. 167
SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE system
procedure...........................................................................................................168
SYSCS_UTIL.SYSCS_IMPORT_TABLE system procedure.............................170
SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE system
procedure...........................................................................................................171
SYSCS_UTIL.SYSCS_FREEZE_DATABASE system procedure.....................173
SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system procedure................174
SYSCS_UTIL.SYSCS_RELOAD_SECURITY_POLICY system procedure...... 174
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure...... 175
SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS system procedure.......... 175
SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING system procedure............176
SYSCS_UTIL.SYSCS_SET_USER_ACCESS system procedure.................... 176
SYSCS_UTIL.SYSCS_SET_XPLAIN_MODE system procedure......................177
SYSCS_UTIL.SYSCS_SET_XPLAIN_SCHEMA system procedure................. 178
SYSCS_UTIL.SYSCS_UPDATE_STATISTICS system procedure...................178
System procedures for storing jar files in a database....................................... 179
Data types............................................................................................................... 186
Numeric types....................................................................................................186
Data type assignments and comparison, sorting, and ordering........................ 188
BIGINT data type.............................................................................................. 192
BLOB data type................................................................................................. 193
BOOLEAN data type......................................................................................... 193
CHAR data type................................................................................................ 194
CHAR FOR BIT DATA data type...................................................................... 195
CLOB data type.................................................................................................195
DATE data type................................................................................................. 196
DECIMAL data type...........................................................................................197
DOUBLE data type............................................................................................198
DOUBLE PRECISION data type.......................................................................198
FLOAT data type............................................................................................... 199
INTEGER data type...........................................................................................199
LONG VARCHAR data type..............................................................................200
LONG VARCHAR FOR BIT DATA data type................................................... 200
NUMERIC data type..........................................................................................200
REAL data type................................................................................................. 201
SMALLINT data type......................................................................................... 201
TIME data type.................................................................................................. 202