pass a parametersthrough file

dr.murthy · Post by **dr.murthy** » Mon Dec 29, 2008 1:41 am

Hi,

in job sequence while running 100 jobs together, one way to give default value in parameter ok.....

the other way??????????????

is there any way like....................

enter all the parameter and its value that we using in the project written in a txt file

then call the txt file in the job seq......

when ever the parameter occur in J.Seq then the vaue of the parameter is taken from the file

is there any way in this format....

and how to implement this logic....

ie how to call the txt file in job seq..

hamzaqk · Post by **hamzaqk** » Mon Dec 29, 2008 5:56 am

yup. write the name of all the jobs in a delimited text file and use the command stage to read the text file and then loop through it and pass the values to the job.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 29, 2008 2:19 pm

Upgrade to version 8 and use a parameter set, which includes the ability to read parameter values from file.

dr.murthy · Post by **dr.murthy** » Mon Dec 29, 2008 10:02 pm

Thanks for responding,

but iam using ver:7.5.1(A) is there any possibility in this version to read the parametere values through a text file.

chulett · Post by **chulett** » Mon Dec 29, 2008 11:33 pm

Of course, but you'll need to write your own 'job control' for this. Read the list of parameters into memory, interogate the job for the parameters it needs and set any you have that match.

dr.murthy · Post by **dr.murthy** » Tue Dec 30, 2008 12:43 am

could you please let me know briefly how to write job controls.

ray.wurlod · Post by **ray.wurlod** » Tue Dec 30, 2008 2:39 am

1. Learn DataStage BASIC programming language.
2. Create new server job, open job properties, enter job control code on Job Control tab. Save and compile.

Easy.

saikir · Post by **saikir** » Tue Dec 30, 2008 2:45 am

Hi,

I hope the code below can help you.

Reading Parameters from a Parameter File

The Below mentioned code illustrates how to read the following parameters from a parameter hashed file and log information about the directory paths in the log:

- DIM_DSN
- DIM_UID
- DIM_PWD
- STG_DSN
- STG_UID
- STG_PWD
- EDW_DSN
- EDW_UID
- EDW_PWD

Code:

OPEN "STG_Parameters_Hash_File" TO PARAMFILE
ELSE
Call DSLogFatal("Job Failed: Unable To Open Hashed File", "JobControl")
END

READ PARAMREC FROM PARAMFILE , "DIM_DSN"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
DIM_DSN = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "DIM_UID"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
DIM_UID = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "DIM_PWD"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
DIM_PWD = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "STG_DSN"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
STG_DSN = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "STG_UID"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
STG_UID = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "STG_PWD"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
STG_PWD = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "EDW_DSN"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
EDW_DSN = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "EDW_UID"
ELSE
Call DSLogFatal ("Job Failed: Unable To read Record from Hashed File", "JobControl")
END
EDW_UID = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "EDW_PWD"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
EDW_PWD = PARAMREC<1>

READ PARAMREC FROM PARAMFILE , "ROOT_DIR"
ELSE
Call DSLogFatal("Job Failed: Unable To read Record From Hashed File", "JobControl")
END
ROOTDIR = PARAMREC<1>

CLOSE PARAMFILE

-- Assigning Values to Directories

InputDirectory = ROOTDIR: "\Input\PrimarySales\"
InProcessDirectory = ROOTDIR: "\Inprocess\PrimarySales\"
ErrorDirectory = ROOTDIR: "\Error\PrimarySales\"
ReProcessDirectory = ROOTDIR: "\Reprocess\PrimarySales\"
ProcessedDirectory = ROOTDIR: "\Processed\PrimarySales\"
ControlFilesDirectory = ROOTDIR: "\ControlFiles\PrimarySales\"

-- Logging the Directory Path

Call DSLogInfo("Input Dir: ": InputDirectory,"JobParameter")

Call DSLogInfo("Inprocess Dir: ": InProcessDirectory,"JobParameter")

Call DSLogInfo("Error Dir: ": ErrorDirectory,"JobParameter")

Call DSLogInfo("ReProcess Dir: ": ReProcessDirectory,"JobParameter")

Call DSLogInfo("Processed Dir: ": ProcessedDirectory,"JobParameter")
Call DSLogInfo("ControlFiles Dir: ": ControlFilesDirectory,"JobParameter")

Note: You need to write parameters to a hashed file before you start this excercise.

Sai

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Dec 30, 2008 7:28 am

Or use dsjob to get list of parameters and fetch their values from db table (holding the values). The job run string call be prepared in shell and initiated.

All outside DS Basic.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Dec 30, 2008 7:28 am

Or use dsjob to get list of parameters and fetch their values from db table (holding the values). The job run string call be prepared in shell and initiated.

All outside DS Basic.

dr.murthy · Post by **dr.murthy** » Fri Jan 02, 2009 3:00 am

[quote="Sainath.Srinivasan"]Or use dsjob to get list of parameters and fetch their values from db table (holding the values). The job run string call be prepared in shell and initiated.

hi srinivasan,

i did n't understand,could you explain me briefly.

ravij · Post by **ravij** » Fri Feb 06, 2009 5:16 am

Hi saikir,

The Below mentioned code illustrates how to read the following parameters from a parameter hashed file and log information about the directory paths in the log:

I have written the query given by you in Job control and added one job in the same job control of batchjob at the end of the code.

And I created one hashed file with the parameters. When I run the Batch job, it is giving the error like,
"BATCH_CALL_PARAMS_FROM_HASH..JobControl (fatal error from JobControl): Job Failed: Unable To Open Hashed File"

Can you please give some brief description about the code. How to use it and how to call the hashed file into the job control and how to pass these parameters to a job?

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 06, 2009 2:56 pm

Do you have a hashed file called STG_Parameters_Hash_File?

Do you have a VOC pointer to it?

You will need both for the OPEN statement to work.

tonystark622 · Post by **tonystark622** » Sun Feb 08, 2009 7:27 pm

Enter GetParameterFromFile into the search. I think it's the 2nd item returned. Here's a linkviewtopic.php?t=107451&highlight=GetParameterFromFile

This addresses one method to pass Job Parameters through a flat file.

Another way is, of course, to upgrade to v8 :D

Good Luck,
Tony

ravij · Post by **ravij** » Sun Feb 08, 2009 10:55 pm

Hi Ray,

Thanks for your reply.

I already created a hashed file STG_Parameters_Hash_File with all the reqired parameters, but

I don't understand the other thing you have mentioned that we need to have a VOC pointer to it.

Can you please tell me how to get or define that VOC ponter?

Thanks in advance

Tony,

Thanks for your reply, and I will go through your comments and let you know the result.