Infosphere Information Server (IIS) Commonly Used Parameters

Parameters are a very big key in, Infosphere Information Server (IIS), to process flexibility in sequences, DataStage jobs and DataQuality jobs.  Parameterization also help reduce development effort, reduce the number of jobs required, and reuse of jobs, by allowing construction of multi instance jobs, which are essentially reused code.

However, sometimes when starting a project, parameters need to created and doing so from memory, doesn’t always achieve the best results. So here is a quick starter list of parameters, which seem to be commonly encountered.  Hopefully, this list will aide in your parametrization efforts and setup.

 

Type Prompt Description Example
String DS_DIR Dataset Directory Path
String DS_LOG_DIR Log File Directory Path
String QUOTES Quotes
String RECIPIENT_EMAIL Recipient Email Address
String SENDER_EMAIL Senders Email Address
String SMTP_SERVER SMTP Mail Server Name
String SQL_DIR SQL File Directory path
String DATE_OFFSET Date Offset Number 1
String DS_ENVIRONMENT Datastage Environment PROD
String SRC_DIR Source Files Directory
String SRC_KEY_GEN_DIR Source Key Generator Files Directory Path
String SRC_REJ_DIR Source Reject Files Directory Path
String WRK_DIR Working Directory Path
String SRC_TABLE Source Table Name
String DB_SCHEMA Database Schema Name
String TGT_TBL Target Table Name
String PROC_DTE Run Control or processing date
String CURR_DTE Current Date

Related References