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: