Nonstop Database, HiRDB Version 9 Command Reference

[Contents][Index][Back][Next]

5.4.11 srcuoc statement (specification of UOC storage library information)

To use UOC to edit data and then store the data in a database, you can use an srcuoc statement to specify the UOC information. For details about UOCs, see section 5.11 Using a UOC to load a table.

When data loading is performed on an audit trail table, a system-provided UOC (audit trail data registration UOC) inputs and edits the audit trail files. You must specify the srcuoc statement in order to load data into the audit trail table.

Criterion
Specify the srcuoc statement to use a UOC to perform data loading or to perform data loading on an audit trail table.
Organization of this subsection
(1) Format
(2) Explanation

(1) Format

 
When using a user-created UOC
 srcuoc library-name entry=function-name [param='user-parameters']
 
When data loading into an audit trail table (using the audit trail data registration UOC)
 srcuoc param='parameters-for-audit-trail-data-registration-UOC'
 

(2) Explanation

(a) library-name

~<pathname>

Specifies the absolute pathname of the shared library where the UOC is stored.

(b) entry=function-name

Specifies the name of the function in the library that is to be called.

(c) param='user-parameters'

~<character string> ((1-1,023 bytes))

Specifies user parameters to be passed to the UOC (because the user cannot use the command line to pass parameters directly to the UOC).

The character string specified in this operand is passed as is to the UOC via the interface area.

Do not include any space or tab in the user parameters character string.

(d) param='parameters-for-audit-trail-data-registration-UOC'

~<character string>((1-4095 bytes))

Specifies in the following format information about the audit trail files that are to be subject to data loading:

 
param='dir=name-of-HiRDB-file-containing-audit-trail-files
        ,file={(name-of-audit-trail-file-subject-to-data-loading
              [,name-of-audit-trail-file-subject-to-data-loading...])|all}
       [,mode={normal|force}]'
 

dir=name-of-HiRDB-file-containing-audit-trail-files
Specifies the name of the HiRDB file that contains the audit trail files.

file={(name-of-audit-trail-file-subject-to-data-loading[,...])|all}
Specifies the names of the audit trail files that are to be subject to data loading.
Specify all to use all audit trail files located in the HiRDB file specified in the dir operand.

mode={normal|force}
Specifies whether data loading is to be performed, depending on an audit trail file's status. The table below shows the relationship between the mode operand's value and whether data loading is performed.
Status of audit trail file mode value Data loading
Whether shut down Data loading status
Not shut down Completed normal N
Waiting Y
Completed force Y#
Waiting Y#
Shut down Completed normal N
Waiting N
Completed force N#
Waiting N#
Current -- normal N
force N

Legend:
Y: Data loading is performed
N: Data loading is not performed
--: Not applicable

#
A control statement error results if you specify file=all together with mode=force.
You can use the pdls -d aud command to check the names and status of the audit trail files.