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
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.