DB2 Extender functions

You must have the DB2 Extender installed before you can execute a query that contains extender functions.

For more information about the DB2 Extenders please see the DB2 extender documentation library.

The following is a list of the supported DB2 Text Extender functions. You can use these functions in your DADX file.

DB2TX schema functions:

• DB2TX.CCSID,

• DB2TX.CONTAINS,

• DB2TX.FILE,

• DB2TX.FORMAT,

• DB2TX.HANDLE,

• DB2TX.HANDLE_LIST,

• DB2TX.INIT_TEXT_HANDLE,

• DB2TX.LANGUAGE,

• DB2TX.NO_OF_DOCUMENTS,

• DB2TX.NO_OF_MATCHES,

• DB2TX.RANK,

• DB2TX.REFINE,

• DB2TX.SEARCH_RESULT

The following is a list of the supported DB2 Image, Audio, and Video Extenders functions.

MMDBSYS schema functions:

• MMDBSYS.alignVALUE,

• MMDBSYS.ASPECTRATIO,

• MMDBSYS.BITSPERSAMPLE,

• MMDBSYS.BYTESPERSEC,

• MMDBSYS.COMMENT,

• MMDBSYS.COMPRESSTYPE,

• MMDBSYS.CONTENT,

• MMDBSYS.DB2AUDIO,

• MMDBSYS.DB2IMAGE,

• MMDBSYS.DB2VIDEO,

• MMDBSYS.DURATION,

• MMDBSYS.FILENAME,

• MMDBSYS.FINDINSTRUMENT,

• MMDBSYS.FINDTRACKNAME,

• MMDBSYS.FORMAT,

• MMDBSYS.FRAMERATE,

• MMDBSYS.GETINSTRUMENTS,

• MMDBSYS.GETTRACKNAMES,

• MMDBSYS.HEIGHT,

• MMDBSYS.IMPORTER,

• MMDBSYS.IMPORTTIME,

• MMDBSYS.MAXBYTESPERSEC,

• MMDBSYS.NUMAUDIOTRACKS,

• MMDBSYS.NUMCHANNELS,

• MMDBSYS.NUMCOLORS,

• MMDBSYS.NUMFRAMES,

• MMDBSYS.NUMVIDEOTRACKS,

• MMDBSYS.QBSCOREFROMNAME,

• MMDBSYS.QBSCOREFROMSTR,

• MMDBSYS.REPLACE,

• MMDBSYS.SAMPLINGRATE,

• MMDBSYS.SIZE,

• MMDBSYS.THUMBNAIL,

• MMDBSYS.TICKSPERQNOTE,

• MMDBSYS.TICKSPERSEC,

• MMDBSYS.UPDATER,

• MMDBSYS.UPDATETIME,

• MMDBSYS.WIDTH