IBM Books

Image, Audio, and Video Extenders Administration and Programming


Altering a table

The DBA adds an audio column to the employee table and enables it for use by the Audio Extender.

What the DBA does: The DBA uses the db2ext command-line processor to enable the personnel database for use by the Audio Extender:

ENABLE DATABASE FOR DB2AUDIO

The DBA then issues the following SQL statement to alter the employee table. The DBA uses the DB2 command line processor to issue the SQL statement.

ALTER TABLE employee              /*name of the table*/
      ADD voice DB2AUDIO          /*employee audio recording*/

The DBA uses the db2ext command-line processor to enable the employee table and the voice column for use by the Audio Extender:

ENABLE TABLE employee FOR DB2AUDIO 
ENABLE COLUMN employee voice FOR DB2AUDIO

What happens: In response to the ENABLE DATABASE command, the Audio Extender:


UDF name Description
AlignValue Get the bytes per sample value of the audio
BitsPerSample Get the number of bits used to represent the audio
BytesPerSec Get the average number of bytes per second of audio
Comment Get or update user comments
Content Get or update the content of an audio
DB2Audio Store the content of an audio
Duration Get the playing time of an audio
Filename Get the name of the file that contains an audio
FindInstrument Get the number of the audio track that records a specific instrument in an audio
FindTrackName Get the track number of a named track in an audio recording
Format Get the audio format
GetInstruments Get the names of the instruments recorded in an audio
GetTrackNames Get the track names in an audio
Importer Get the user ID of the importer of an audio
ImportTime Get the timestamp when an audio was imported
NumAudioTracks Get the number of recorded tracks in an audio
NumChannels Get the number of audio channels
Replace Update the content and user comments for an audio recording
SamplingRate Get the sampling rate of the audio
Size Get the size of an audio in bytes
TicksPerQNote Get the number of clock ticks per quarter note used in recording an audio
TicksPerSec Get the number of clock ticks per second used in recording an audio
Updater Get the user ID of the updater of an audio
UpdateTime Get the timestamp when an audio was updated

In response to the ENABLE TABLE command, the Audio Extender:

In response to the ENABLE COLUMN command, the Audio Extender:


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