Reading Sequence parameter from a File/database

keshav0307 · Post by **keshav0307** » Mon Jan 30, 2006 7:20 pm

i need to pass some parameters in a job sequence. This parameter will be in oracle table. how can i read this parameter to pass in job sequence.
or how can i read the parameter from a file.

kduke · Post by **kduke** » Mon Jan 30, 2006 7:27 pm

Select it into a hash file with a job. Use either UtilityHashRead or the get next surrogate key routine to develop your own routine.

keshav0307 · Post by **keshav0307** » Mon Jan 30, 2006 9:03 pm

Duke
where will i get the UtilityHashRead routine..
Please tell me in detail, how can i do this.

chulett · Post by **chulett** » Mon Jan 30, 2006 9:34 pm

Comes with the product, in the sdk category under the Utility sub-category. Technically it's the UtilityHashLoop routine. Pop it open, the Long Description describes how it works and you can always read the code.

kumar_s · Post by **kumar_s** » Wed Feb 01, 2006 7:24 am

Hi,

I am not sure, whether these routines can be used for Hash table under PX Edition.

-Kumar

chulett · Post by **chulett** » Wed Feb 01, 2006 7:40 am

Not in a PX job itself without inclusion of the dreaded BASIC Transformer, but we're talking in a Sequence job which is a form of Server job. So the answer is yes.