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 helps 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

• Infosphere Datastage – Useful Links
• What are the Infosphere DataStage job status log values?
• Infosphere Datastage – How to Generate Datastage Technical Design Job Reports
• Infosphere Datastage – Useful Date Transformations