Creating a parameter file

You can specify a parameter file name in a data source and use the parameter file to define the criteria to select a unique archive file.

The advantage of using a parameter file with a data source is that it allows you to create and employ a relatively generic data source, and use the parameter file to comprehensively define an archive file for processing.

Syntax

Use keywords and values in a connect string (if your application allows), or in a parameter file, as follows. When you specify an archive ID value, additional keywords and values are ignored.

DIRECTORY = optdirectoryname
( [ARCHIVEID = n | GUID = n |
FILE = archivefilename[SERVER = servername]]
[GROUP = groupid]
[CREATOR = creatorid]
[TABLENAME = dbalias.creatorid.tablename]
[STARTDATE = startdate]
[ENDDATE = enddate]
[SELCRIT = tablename columnname relationaloperator value]
[COLCONN = tablename {AND|OR}]
[SQLTEXT = tablename SQLwhereclause]
[CONN = {AND|OR}] )

Syntax Specifications

DIRECTORY optdirectoryname
The name of the Optim directory.
ARCHIVEID n
Archive file identifier as a numeric value.
GUID n
Globally unique [archive file] identifier as a numeric value.
FILE archivefilename
Specific archive file name or a wildcard pattern.
SERVER servername
Optim server name or wildcard pattern.
GROUP groupid
Group name associated with the archive file, or wildcard pattern.
CREATOR creatorid
Creator ID associated with the archive file, or wildcard pattern.
TABLENAME dbalias.creatorid.tablename
Fully qualified table name, or wildcard pattern, to narrow the focus to archive files containing the named table.
STARTDATE startdate
Start date of range to limit archive files to those created within a specific time frame. Date format must conform to the setting chosen in the Windows Regional Options.
ENDDATE enddate
End date of range to limit archive files to those created within a specific time frame. Date format must conform to the setting chosen in the Windows Regional Options.
SELCRIT tablename columnname relationaloperator value
Selection criteria, to limit archive files to those containing the named table, and the data specified. Use a fully qualified table name (dbalias.creatorid.tablename) for selection criteria. (Selection criteria must conform to SQL syntax and must include a column name, relational operator, and a value.)
COLCONN tablename {AND|OR}
Column connector for multiple local selection criteria applied to the named table.
SQLTEXT tablename sqlwhereclause
SQL WHERE clause, to limit archive files to those containing the named table, and the data specified. Use the fully qualified table name (dbalias.creatorid.tablename). (The SQL WHERE clause (sql) must conform to SQL syntax.)
CONN {AND|OR}
Table connector for SELCRITS or SQLTEXTfor multiple tables.

Selection criteria and SQL WHERE clauses are applied to archive indexes, if any exist. Depending on whether the Only Use Index to Perform Search check box on the Archive tab in personal options is selected, criteria may also be applied to archive file data to identify the desired archive file.



Feedback