IBM Books

Administrative API Reference

sqlurcon - Reconcile

Validates the references to files for the DATALINK data of a table. The rows for which the references to files cannot be established are copied to the exception table (if specified), and modified in the input table.

Authorization

One of the following:

Required Connection

Database

Version

sqlutil.h

C API Syntax 



/* File: sqlutil.h */
/* API: Reconcile */
/* ... */
SQL_API_RC SQL_API_FN
  sqlurcon (
    char * pTableName,
    char * pExTableName,
    char * pReportFileName,
    void * pReserved,
    struct sqlca * pSqlca);
/* ... */

Generic API Syntax 



/* File: sqlutil.h */
/* API: Reconcile */
/* ... */
SQL_API_RC SQL_API_FN
  sqlgrcon (
    unsigned short TableNameLen,
    char * pTableName,
    unsigned short ExTableNameLen,
    char * pExTableName,
    unsigned short ReportFleNameLen,
    char * pReportFileName,
    void * pReserved,
    struct sqlca * pSqlca);
/* ... */

API Parameters

TableNameLen
Input. A 2-byte unsigned integer representing the length in bytes of the table name.

pTableName
Input. Specifies the table on which reconciliation is to be performed. An alias, or the fully qualified or unqualified table name can be specified. A qualified table name is in the form schema.tablename. If an unqualified table name is specified, the table will be qualified with the current authorization ID.

ExTableNameLen
Input. A 2-byte unsigned integer representing the length in bytes of the exception table name.

pExTableName
Input. Specifies the exception table into which rows that encounter link failures for DATALINK values are to be copied.

ReportFileNameLen
Input. A 2-byte unsigned integer representing the length in bytes of the report file name.

pReportFileName
Input. Specifies the file that will contain information about the files that are unlinked during reconciliation. The name must be fully qualified (for example, /u/johnh/report). The reconcile utility appends a .ulk extension to the specified file name (for example, report.ulk).

pReserved
Reserved for future use.

pSqlca
Output. A pointer to the sqlca structure. For more information about this structure, see SQLCA.

Usage Notes

During reconciliation, attempts are made to link files which exist according to table data, but which do not exist according to Data Links File Manager metadata, if no other conflict exists.

Reconciliation is performed with respect to all DATALINK data in the table. If file references cannot be re-established, the violating rows are inserted into the exception table (if specified). These rows are not deleted from the input table. To ensure file reference integrity, the offending DATALINK values are nulled. If the column is defined as not nullable, the DATALINK values are replaced by a zero length URL.

If an exception table is not specified, the DATALINK column values for which file references cannot be re-established are copied to an exception report file (<pReportFileName>.exp), along with the column ID and a comment.

At the end of the reconciliation process, the table is taken out of datalink reconcile pending (DRP) state.

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

[ DB2 List of Books | Search the DB2 Books ]