Passing job parameter from text file

[rafik2k]

Hi,
I want to read paramter from text file and use the value of paramter in my job.
Example
FileName is parameter

Code: Select all

Parameter name,prompt,value
domain_name,Enter value name domain, electricity

I tried searching in archive, but failed to get desired result.

Please let me know any reference of previous post or suggestion on same

Thanks

[ray.wurlod]

Well, it's definitely been discussed before.

You can't do it within the job - job parameters are fixed when the job starts. Use whatever method you like in a job sequence to read the lines from the parameter file. Load these up into, say, user variables and use these to supply parameter values to the job.

[rafik2k]

Thanks Ray!
I need to read all 3 variable

Parameter name,prompt,value

from first line and their corresponding value from 2nd file.

Can you pleae let me know or give me hints how to acheive this?
I believe I will have write the routine, but don't know the actual syntax of reading text file.

Thanks

[JoshGeorge]

In the sequence you can call your routine by passing the file name, line number to be read and field number of the parameter. You can call this for all the parameters you want to read...

Code: Select all

Routine:

Open your seq file 
Ans = Trim(Field(FileLine,',',FieldNumber)) 
Close your seq file

[sachin1]

hello if your input parameters are fixed, say in number 1,2 ...3 or more, but thier values are stored in text file then, you can do is in JOB CONTROL use following

DSSetParam
DSRunJob
...DSDetachJob

you can read your file and set values for parameters using DSSetParam.