The following table lists the formats in which you can store, retrieve, or update image, audio, and video objects. For image objects only, you can have the Image Extender convert the format of the image as it stores, retrieves, or updates it. (Audio and video object formats cannot be converted when stored, retrieved, or updated.)
The Read and Write columns in the table indicate which formats can be read and which formats can be converted when written. When the entry in the Read column in the table is x, the corresponding object format can be used when storing, retrieving, or updating. When the entry in the Write column is x, an object (image only) can be converted to the corresponding format when stored, retrieved, or updated. For example, an image in BMP format can be converted to a GIF format when stored, retrieved, or updated. An image in JPG format can be converted to TIF format. But an image in TIF format cannot be converted to JPG format.
Although listed in the table in uppercase, format specifications in store,
retrieve, or update requests are not case sensitive. For example, the
specifications GIF, gif, and Gif are equivalent.
Table 4. Formats that can be processed by the DB2 extenders
Format | Description | Read | Write |
---|---|---|---|
Image Formats | |||
_IM | PS/2 Audio Video Connection (AVC) | x |
|
BMP | OS/2 - Microsoft Windows bitmap1 | x | x |
EPS | Encapsulated PostScript |
| x |
EP2 | Encapsulated level 2 PostScript |
| x |
GIF | Compuserve GIF89a (including animated GIFs2) and 87 | x | x |
IMG | IOCA image | x | x |
IPS | Brooktrout FAX card file | x | x |
JPG | JPEG3 (JFIF format) | x |
|
PCX | PC paint file (grayscale only) | x | x |
PGM | Portable gray map (from PBMPLUS) | x | x |
PS | PostScript |
| x |
PSC | Compressed PostScript image |
| x |
PS2 | PostScript level 2 (color) |
| x |
TIF | All TIFF 5.0 formats | x | x |
YUV | Digital video for YUV | x | x |
Audio formats | |||
AIF or AIFF | Audio Interchange File Format | x |
|
AIFFC | Audio Interchange File Format Compressed | x |
|
AU | Sun audio file format | x |
|
MIDI | Musical Instrument Digital Interface | x |
|
MPG1 or MPEG1 | Moving Pictures Expert Group 1 | x |
|
WAV or WAVE | Wave | x |
|
Video formats | |||
AVI | Audio/Video Interleaved | x |
|
MPG1 or MPEG1 | Motion Picture Coding Expert Group 1 | x |
|
MPG2 or MPEG2 | Motion Picture Coding Expert Group 2 | x |
|
QT | Quicktime (AVI) | x |
|