GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  DataStage
Go To First  |  Previous Question  |  Next Question 
 DataStage  |  Question 76 of 140    Print  
How do we use Job Parameters in datastage jobs.
I know we use them in the project level and also in the job level and also that we can give values at run time(like UN, Pswd etc). Theoratically I understood. But practically unable to implement it. Can somebody explain me in detail with an example. I wud seriously appreciate your help. Thanks Guyz.


  
Total Answers and Comments: 2 Last Update: January 29, 2009     Asked by: Geekmania 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
November 19, 2007 05:18:30   #1  
Fanguna        

RE: How do we use Job Parameters in datastage jobs.
There is an icon to go to Job parameters in the tool bar. Or you can press Ctrl+J to enter into Job Parameters dialog box. Once you enter give a parameter name and corresponding default value for it. This helps to enter the value when you run the job. Its not necessary always to open the job to change the parameter value. Also when the job runs through script its just enough to give the parameter value in the command line of script.
Else you have to change the value in the job compile and then run in the script. So its easy for the users to handle the jobs using parameters.

 
Is this answer useful? Yes | No
January 27, 2009 05:18:45   #2  
Behrouz Member Since: January 2009   Contribution: 2    

RE: How do we use Job Parameters in datastage jobs.

For example I create a parameter for my hashfile folder like it :


Name: $pHashdir type:string def.value: C:DataStageInput DATAHash


and when I use my hash file in path file name i use just this parameter $pHashdir


and when you run your job datastage replace this one C:DataStageInput DATAHash


you can use it for the username sourcename password of your DB



 
Is this answer useful? Yes | No

 Related Questions

Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated
Read Answers (6) | Asked by : Madhavi

Hi ,in my pc i am unable to login to the Ascential datastage 7.1. whatever the hostname i am specifying... i m getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)n when i explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It\'s important that the lastline (host=name) is terminated

We have the Datastage server7.5 installed on Unix machine. We need to have a DSN to connect to the database which is on some other unix machine.please let me know it is enough if we create a DSN at the client machine or do we have to change the config file in UNIX?It is very urgent for us and we are not able to solve?pls help me in this regard.Madhavi
Read Answers (1) | Asked by : Madhavi

Latest Answer : To handle the error handling you can use the reject link option available in the transformer stage. ...
Read Answers (1) | Asked by : Amar

Latest Answer : Parallel extender is that the parallel processing of data extraction and transformation application . there are two types of parallel processing 1) pipeline parallelism 2) partition parallelism. ...
Read Answers (2) | Asked by : Deepak Prasad

View Question | Asked by : saritha.ppr

If a DataStage job has aborted after say 1000 records, how to continue the load from 1000th record after fixing the error?
Read Answers (6) | Asked by : etl

Latest Answer : two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------> ...

I am trying to execute batch file which has dsjob command to run data stage job from CLI.I am getting error code = 81011 (project not found but project is there)But I can run other jobs. I am getting into problem for one particular batch.any help
View Question | Asked by : Dilip

To pass parameters to the job we can use Unix shell program. But I do not know exactly how to do that.Plz let me know detail steps to pass the parameter through shell script
Read Answers (2) | Asked by : mmwenu


 Sponsored Links

 
Related Articles

Advertising Industry Jobs

Advertising Industry Jobs for IT Professionals : Today there are many global enterprises which are integrating both technology and entertainment. Many of these firms develop and market services and products which have the ability to greatly enhance entertainment for many consumers. These companies w
 

Finding Your First Job Researching Jobs

by ResumeEdge.com - The Premier Resume Writing and Editing Service Now that determined your interests and skills, time to do some heavy-duty research on occupations. Now that determined your interests and skills, time to do some heavy-duty research. lose sight of the fact that your ability t
 

Does New College Graduate Equal Entry Level Jobs?

Does New College Graduate Equal Entry Level Jobs Breaking into the career field of your choice after college can be more difficult than some people may imagine During college all you can think about is the education and getting through the process of receiving that education and when you graduate yo
 

Applying For The Jobs That You Deserve

Applying For The Jobs That You Deserve So you’ ve finally graduated from college and it’ s time to find a job This is a scary and exciting time and it can be a bit hard to determine what jobs you should be applying for Many college graduates actually make the mistake of applying
 

After Graduation: Where To Look For Jobs

After Graduation Where To Look For Jobs Searching for a job can be very stressful for many students nearing graduation Unfortunately all the education in the world doesn’ t teach you how to go out and find the jobs you need and want after college so you need to know where to look to land t
 

Live DataStage Interview Questions

Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated questions here Live DataStage Interview Questions Published by Manoj G on 05 24 2005 Thanks to our site visitor Manoj for sending these DataStage Interview Questions You can find the updated que
 

SQL Server 2000: Creating Stored Procedure with Input and Output Parameters

This tutorial explains how to create and use Stored Procedures with Input Parameters and output parameters along with the screen shots and sample code Creating Stored Procedure with Input Parameters mosgoogle Input Parameters in Stored Procedures are placeholders for data that the user needs to send
 

Finding Your First Job - Researching Jobs

Now that you ve determined your interests and skills it s time to do some heavy duty research on occupations mosgoogle mosgoogle by ResumeEdge com Now that you ve determined your interests and skills it s time to do some heavy duty research Don t lose sight of the fact that your ability to do effic
 

How to Search Jobs

With so many people now losing their jobs these days because of the recession searching for a job may not be easy as you have to compete with many others who may be in the same predicament as you are. It is quite prudent therefore for you to follow some time-tested and quick time-saving job search t
 

Creating Jobs for Silverlight SMS Distribution

Once you have generated the SMS package which is necessary for Silverlight you will next need to distribute it through the creation of a job. There are a number of things that this job may include and one is the collection of computers that will get the SMS package which is needed for Silverlight. m
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape