select FORMATNAME,DESCRIPTION,MIMETYPE from WCUSER.DATAFORMAT

FORMATNAME DESCRIPTION MIMETYPE
UGC Part Pro/Engineer part x-ptc/x-part
UGC Assembly Pro/Engineer assembly x-ptc/x-asm
XML XML file text/xml
DWG DWG file image/vnd.dwg
DXF DXF file image/vnd.dxf
CC CC file application/x-camcad
CCZ CCZ file application/x-gzip
EDZ EDZ file application/edz
ED ED file application/ed
OL OL file application/octet-stream
NONE no format - bogus mime text/plain
File Set to represent file set documents text/plain
URL Link URL format text/html
PROE set of Pro/ENGINEER data files text/plain
CADDS5 set of CADDS5 data files text/plain
CATIA set of CATIA data files text/plain
Audio Sound Clip audio sound clip audio/basic
Bitmap Image bitmap image image/bmp
Cals cals format application/cals-1840
Executable executable file application/octet-stream
GIF Image gif image image/gif
HTML File html file text/html
JPEG Image jpeg image image/jpeg
Microsoft Excel excel file application/vnd.ms-excel
Microsoft PowerPoint powerpoint file application/vnd.ms-powerpoint
Microsoft Word word file application/msword
Microsoft Project project file application/msproject
MPEG Movie Clip mpeg video/mpeg
PDF acrobat pdf application/pdf
Postscript postscript file format application/postscript
Rich Text rich text application/rtf
SGML sgml file text/sgml
Text File text file text/plain
TIFF tiff image/tiff
Wave Sound audio sound wave file audio/wav
Zip zip file application/zip
Unknown this is for files whose type is unknown x-unknown/x-unknown
VPF Intralink gateway x-ptc/x-vpf
GBF PTC visualization x-world/x-gbf
GAF PTC visualization x-world/x-gaf
VRML vrml x-world/x-vrml
CGM Image cgm image image/cgm
SLP Image render format image/slp
STL Image stereolithography image/stl
FRM PTC Pro/Engineer format x-ptc/x-frm
REP PTC Pro/Engineer report x-ptc/x-rep
DGM PTC Pro/Engineer diagram x-ptc/x-dgm
LAY PTC Pro/Engineer layout x-ptc/x-lay
DRW PTC Pro/Engineer drawing x-ptc/x-drw
PIC PTC Pro/Engineer picture drawing format x-ptc/x-pic
Package PTC visualization package x-ptc/x-package