Table of Contents

Search

  1. Preface
  2. Components
  3. API collections
  4. Business services
  5. File listeners
  6. Fixed-width file formats
  7. Hierarchical schemas
  8. Intelligent structure models
  9. Refining intelligent structure models
  10. Mapplets
  11. Saved queries
  12. Shared sequences
  13. User-defined functions

Components

Components

Add Parameters

Add Parameters

Using variables you can configure a parameter that a file listener reads from or writes to.
You can use one of the following types of variables to configure a parameter:
  • System variables
  • User-defined variables
You cannot run a task using the user-defined variable from the user interface. The value of the user-defined variable must be passed using the job resource of the Mass Ingestion Files REST API. For more information, see the REST API help.
Using system variables to add parameters
Use system variables to add parameters to
Folder Path
on the task wizard.
  1. Click the icon next to
    Post Action
    on the file listener task wizard.
    The
    Add Parameters
    window appears.
    Select the system variables from the Add Parameters window.
  2. Select the required variable from the
    System Variables
    column, and click . The selected system variable appears on the
    Expression
    column. Repeat this procedure to select multiple system variables.
    When using a System variable within a task, it should be formatted as
    ${systemvariablename}
    .
    The following table describes the system variables:
    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}
    LookupFileDir *
    Directory for lookup files. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMLookupFileDir}
    Month **
    Numerical month
    ${system.month}
    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}
    SessionLogDir *
    Directory for session logs. It cannot include the following special characters:
    * ? < > " | ,
    ${$PMSessionLogDir}
    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}
    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.
    The parameter substitution occurs when you start a task. When a file listener starts and evaluates that the previously watched location is different due to the difference in the parameter value, a delete notification is sent for the files present in the previously watched location. The notifications are not sent if you disable the delete notification option or enable the
    Exclude events when the file listener is not running
    option.
  3. Click
    OK
    .
    The expression appears in the
    Folder Path
    field.

Using user-defined variables to add parameters

Use user-defined variables to define value for
Folder Path
on the task wizard.
  1. Click the
    Folder Path
    field and enter the variable. The variable should be formatted as
    ${systemvariablename}
    .
  2. Click
    OK
    .
    The expression appears in the
    Folder Path
    .

0 COMMENTS

We’d like to hear from you!