IBM Books

Image, Audio, and Video Extenders Administration and Programming

GET REFERENCED FILES


Image Audio Video
X X X

List all media files and the column names that reference them in a table, tables with a specific qualifier, or all the tables in the current database.

Authorization

For all tables in the current database, that is, if you do not specify USER or IN: SYSADM, SYSCTRL, SYSMAINT, DBADM

For a particular table (if you specify IN) or tables that belong to a qualifier (if you specify USER): Select

Command syntax

>>-GET REFERENCED FILES----+-----------------+--FOR------------->
                           +-USER--user_ID---+
                           '-IN--table_name--'
 
      .-,----------------.
      V                  |
>--------extender_name---+-------------------------------------><
 

Command parameters

user_ID
The qualifier of the tables in the database whose referenced files you want to list. The command searches only tables with that qualifier.

table_name
The name of the table in the current database whose referenced files you want to list. The command searches that table only.

extender_name
The name of the extender. Valid extender names are db2image, db2audio, and db2video.

Examples

List all the image files referenced by table entries in all the tables in the database:

get referenced files
   for db2image

List all the image files referenced by entries in tables with the qualifier anita:

get referenced files
   user anita for db2image

List all the image files referenced by entries in the employee table:

get referenced files
   in employee for db2image

Usage notes

Connect to the database before using this command.

If you do not specify any parameters, the command searches all the tables in the database.


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