IBM Books

Image, Audio, and Video Extenders Administration and Programming

GET INACCESSIBLE FILES


Image Audio Video
X X X

List all media files that are inaccessible and referenced by 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 INACCESSIBLE FILES----+-----------------+--FOR----------->
                             +-USER--user_ID---+
                             '-IN--table_name--'
 
      .-,----------------.
      V                  |
>--------extender_name---+-------------------------------------><
 

Command parameters

user_ID
The qualifier of the tables in the current database whose inaccessible files you want to list.

table_name
The name of the table in the current database whose inaccessible files you want to list.

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

Examples

List all the image files referenced by tables in the database, but are inaccessible:

get inaccessible files
   for db2image

List all the image files referenced in tables with the qualifier anita, but are inaccessible:

get inaccessible files
   user anita for db2image

List all the image files referenced by entries in the employee table, but are inaccessible:

get inaccessible files
   in employee FOR db2image

Usage notes

Connect to the database before using this command.

If you specify a table the command lists inaccessible files for that table. If you specify a qualifier, the command lists inaccessible files for only those tables with that qualifier. If you specify neither, the command lists inaccessible files for all the tables in the current database.


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