This section gives reference information for the DB2 extenders. The UDFs are listed in alphabetical order.
The following information is given for each UDF:
The following table lists the UDFs and identifies the extenders that
provide each UDF. The UDFs in this table can be coded in embedded SQL
statements or in DB2 CLI calls.
UDF | Description | Image | Audio | Video |
---|---|---|---|---|
AlignValue | Returns the number of bytes per sample in a WAVE audio, or in an audio track of a video. | x | x | |
AspectRatio | Returns the aspect ratio of the first track of an MPEG1 and MPEG2 video. | x | ||
BitsPerSample | Returns the number of bits of data used to represent each sample of WAVE or AIFF audio in an audio, or in an audio track of a video. | x | x | |
BytesPerSec | Returns the data transfer rate, in average bytes per second, for a WAVE audio. | x | ||
Comment | Returns or updates a comment stored with an image, audio, or video. | x | x | x |
CompressType | Returns the compression format, such as MPEG-1, of a video. | x | ||
Content | Retrieves or updates the content of an image, audio, or video from a database. | x | x | x |
DB2Audio | Stores the content of an audio in a database table. | x | ||
DB2Image | Stores the content of an image in a database table. | x | ||
DB2Video | Stores the content of a video in a database table. | x | ||
Duration | Returns the duration (that is, playing time in seconds) of a WAVE or AIFF audio, or video. | x | x | |
Filename | Returns the name of the server file that contains the contents of an image, audio, or video. | x | x | x |
FindInstrument | Returns the track number of the first occurrence of a specified instrument in a MIDI audio. | x | ||
FindTrackName | Returns the number of a specified named track in a MIDI audio. | x | ||
Format | Returns the format of an image, audio, or video. | x | x | x |
FrameRate | Returns the throughput of a video in frames per second. | x | ||
GetInstruments | Returns the instrument name of all instruments in a MIDI audio. | x | ||
GetTrackNames | Returns the name of all tracks in a MIDI audio. | x | ||
Height | Returns the height, in pixels, of an image or video frame. | x | x | |
Importer | Returns the user ID of the person who stored an image, audio, or video in a database table. | x | x | x |
ImportTime | Returns a timestamp that indicates when an image, audio, or video was stored in a database table. | x | x | x |
MaxBytesPerSec | Returns the maximum throughput of a video in bytes per second. | x | ||
NumAudioTracks | Returns the number of audio tracks in a video or MIDI audio. | x | x | |
NumChannels | Returns the number of recorded audio channels in a WAVE or AIFF audio, or video. | x | x | |
NumColors | Returns the number of colors in an image. | x | ||
NumFrames | Returns the number of frames in a video. | x | ||
NumVideoTracks | Returns the number of video tracks in a video. | x | ||
QbScoreFromName | Returns the score of an image (uses a named query object). (Replaces QbScore.) | x | ||
QbScoreFromStr | Returns the score of an image (uses a query string). | x | ||
QbScoreTBFromName | Returns a table of scores for an image column (uses a named query object). | x | ||
QbScoreTBFromStr | Returns a table of scores for an image column (uses a query string). | x | ||
Replace | Updates the content of an image, audio, or video stored in a database, and updates its comment. | x | x | x |
SamplingRate | Returns the sampling rate of a WAVE or AIFF audio, or of an audio track in a video, in number of samples per second. | x | x | |
Size | Returns the size of an image, audio, or video, in bytes. | x | x | x |
Thumbnail | Returns or updates a thumbnail-size version of an image or video frame stored in a database. | x | x | |
TicksPerQNote | Returns the clock speed of a recorded MIDI audio, in ticks per quarter note. | x | ||
TicksPerSec | Returns the clock speed of a recorded MIDI audio, in ticks per second. | x | ||
Updater | Returns the user ID of the person who last updated an image, audio, or video in a database table. | x | x | x |
UpdateTime | Returns a timestamp that indicates when an image, audio, or video in a database table was last updated. | x | x | x |
Width | Returns the width in pixels of an image or video frame. | x | x |