FirebirdSQL logo
  • Anglaiskeyboard_arrow_down
 Window (Analytical) FunctionsContext Variables 

System packages provide utility stored functions and stored functions.

List of System Packages
[fblangref50-sys-pckg-blobutil]

Utilities for blob manipulation

[fblangref50-sys-pckg-profiler]

Profiler

[fblangref50-sys-pckg-timezoneutil]

Time zone utilities

RDB$BLOB_UTIL

Package of functions and procedures for blob manipulation

Function IS_WRITABLE

RDB$BLOB_UTIL.IS_WRITABLE returns TRUE when a BLOB is suitable for data appending using BLOB_APPEND without copying.

Input parameter

  • BLOB type BLOB NOT NULL

Return type: BOOLEAN NOT NULL.

Function NEW_BLOB

RDB$BLOB_UTIL.NEW_BLOB creates a new BLOB SUB_TYPE BINARY.It returns a BLOB suitable for data appending, similar to BLOB_APPEND.

The advantage over BLOB_APPEND is that it’s possible to set custom SEGMENTED and TEMP_STORAGE options.

BLOB_APPEND always creates BLOBs in temporary storage, which may not always be the best approach if the created BLOB is going to be stored in a permanent table, as this will require a copy operation.

The BLOB returned from this function, even when TEMP_STORAGE = FALSE, may be used with BLOB_APPEND for appending data.

Input parameters

  • SEGMENTED type BOOLEAN NOT NULL

  • TEMP_STORAGE type BOOLEAN NOT NULL

Return type: BLOB SUB_TYPE BINARY NOT NULL.