Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
System Variables
| Description
| Expression
|
---|---|---|
BadFileDir *
| Directory for reject files. It cannot include the following special characters:
* ? < > " | ,
| ${$PMBadFileDir}
|
CacheFileDir *
| The location for the cache file.
| ${$PMCacheDir}
|
Date **
| The current date in ISO (yyyy-MM-dd) format.
| ${system.date}
|
Day **
| The day of week
| ${system.day}
|
ExtProcDir *
| Directory for external procedures. It cannot include the following special characters:
* ? < > " | ,
| ${$PMExtProcDir}
|
Hours **
| Hours
| ${system.hours}
|
JobId
| The id (or job number) of the current job.
| ${system.jobid}
|
LookupFileDir *
| Directory for lookup files. It cannot include the following special characters:
* ? < > " | ,
| ${$PMLookupFileDir}
|
Minutes **
| Minutes
| ${system.minutes}
|
Month **
| Numerical month
| ${system.month}
|
Name
| The name of the current Project.
| ${system.name}
|
RootDir *
| Root directory accessible by the node. This is the root directory for other service process variables. It cannot include the following special characters:
* ? < > " | ,
| ${$PMRootDir}
|
RunId
| The id when a job is run.
| ${system.runid}
|
Seconds **
| Seconds
| ${system.seconds}
|
SessionLogDir *
| Directory for session logs. It cannot include the following special characters:
* ? < > " | ,
| ${$PMSessionLogDir}
|
SourceFileDir *
| Directory for source files. It cannot include the following special characters:
* ? < > " | ,
| ${$PMSourceFileDir}
|
StorageDir *
| Directory for run-time files. Workflow recovery files save to the $PMStorageDir configured in the PowerCenter Integration Service properties. Session recovery files save to the $PMStorageDir configured in the operating system profile. It cannot include the following special characters:
* ? < > " | ,
| ${$PMStorageDir}
|
TargetFileDir *
| Directory for target files. It cannot include the following special characters:
* ? < > " | ,
| ${$PMTargetFileDir}
|
TempDir *
| Directory for temporary files. It cannot include the following special characters:
* ? < > " | ,
| ${$PMTempDir}
|
Timestamp **
| The current date and time in ISO (yyyy-MM-dd HH:mm:ss) format.
| ${system.timestamp}
|
WorkflowLogDir *
| The location for the workflow log file.
| ${$PMWorkflowLogDir}
|
Year **
| Year
| ${system.year}
|
* Values are fetched from the Data Integration Server.
** Time zone is the Secure Agent time zone.
|