DataStage - How do you pass filename as the parameter for a job?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 29 of 390

How do you pass filename as the parameter for a job?

Total Answers and Comments: 3

Last Update: May 06, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 22, 2005 16:51:43

Mujeebur Rehman

RE: How do you pass filename as the parameter for a job?

While job developement we can create a paramater 'FILE_NAME' and the value can be passed while running the job.

Is this answer useful? Yes | No

November 28, 2005 02:02:54

sridhar245

Member Since: November 2005 Contribution: 4

RE: How do you pass filename as the parameter for a jo...

1. Go to DataStage Administrator->Projects->Properties->Environment->UserDefined. Here you can see a grid where you can enter your parameter name and the corresponding the path of the file.

2. Go to the stage Tab of the job select the NLS tab click on the Use Job Parameter and select the parameter name which you have given in the above. The selected parameter name appears in the text box beside the Use Job Parameter button. Copy the parameter name from the text box and use it in your job. Keep the project default in the text box.

Is this answer useful? Yes | No

May 06, 2007 22:45:05

hanug

Member Since: June 2006 Contribution: 24

RE: How do you pass filename as the parameter for a jo...

1. Define the job parameter at the job level or Project level.
2. Use the file name in the stage(source or target or lookup)
3. supply the file name at the run time.

Hanu.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank