IBM Books

Image, Audio, and Video Extenders Administration and Programming


User-defined functions

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.

Table 14. DB2 Extender UDFs
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


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]