IBM Books

Image, Audio, and Video Extenders Administration and Programming

DBaAdminGetInaccessibleFiles


Image Audio Video
  X  

Returns the names of inaccessible files that are referred to in audio columns of user tables. The application must be connected to a database before calling this API.

It is important that you free up the resources that are allocated by this API after calling it. Specifically, you must free up the filelist data structure as well as the filename field in each entry in the filelist.

Authorization

SYSADM, SYSCTRL, SYSMAINT

Library file
OS/2 and Windows AIX, HP-UX, and Solaris
dmbaudio.lib libdmbaudio.a (AIX)

libdmbaudio.sl (HP-UX)

libdmbaudio.so (Solaris)

Include file

dmbaudio.h

Syntax

long DBaAdminGetInaccessibleFiles(
      char *qualifier,
      long *count,
      FILEREF *(*fileList)
      );

Parameters

qualifier (in)
A valid user ID or a null value. If a user ID is specified, all tables with the specified qualifier are searched. If a null value is specified, all tables in the current database are searched.

count (out)
The number of entries in the output list.

fileList (out)
A list of inaccessible files that are referred to in the table.

Error codes

MMDB_SUCCESS
API call processed successfully.

SQL_ERROR or other SQL return codes
Error returned from DB2.

MMDB_RC_NOT_CONNECTED
Application does not have valid connection to a database.

MMDB_RC_MALLOC
System cannot allocate memory to return the results.

MMDB_RC_NO_AUTH
User does not have proper authority to call this API.

Examples

List all inaccessible files that are referred to in audio columns of tables that are owned by user ID rsmith:

#include <dmbaudio.h>
long idx;
 
rc = DBaAdminGetInaccessibleFiles("rsmith",
       &count, &filelist);


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