Defining global constants for runtime

[admin]

Most of the sites Ive worked with use a hashed file to store these. One row per global constant, the key is the constant name and the single non-key column is the constants value for this particular run. Its very efficient. The hashed file can be loaded by the first job in a sequence that gets the values for this run from, say, job parameters or a text file.

-----Original Message-----
From: derick j JOSE [mailto:datastage@rediffmail.com]
Sent: Thursday, 27 September 2001 16:08
To: datastage-users@oliver.com
Cc: ramana_prasad@mindtree.com
Subject: Defining global constants for runtime



Hi, We have facility in datastage to acept input from the end user as
a parameter.And some parameters will be common across all the jobs.So Is there any way to define a global constant with value .So that all the jobs will take the same value from the global constant.Can anybody help me. Thanks Tina

[admin]

If you use an scheduller (ad hoc or standard) you can get the value across
a table or a file. The end user can easily define the value of the
parameters using a common tool like Access or VB. Then the scheduller,
using some tables (eg. JOB and JOB -PARAMETER-INSTANCE) , knows that the
parameter to launch uses this values.
If you need more help I can detail it.
Regards,
Juanjo

> -----Mensaje original-----
> De: derick j JOSE [SMTP:datastage@rediffmail.com]
> Enviado el: jueves 27 de septiembre de 2001 08:08
> Para: datastage-users@oliver.com
> CC: ramana_prasad@mindtree.com
> Asunto: Defining global constants for runtime
>
>
>
> Hi,
> We have facility in datastage to acept input from the end user
> as a
parameter.And some parameters will be common across all the jobs.So Is
there any way to define a global constant with value .So that all the jobs
will take the same value from the global constant.Can anybody help me.
>
> Thanks
> Tina
>

[admin]

Hi,
We have facility in datastage to acept input from the end user as a parameter.And some parameters will be common across all the jobs.So Is there any way to define a global constant with value .So that all the jobs will take the same value from the global constant.Can anybody help me.

Thanks
Tina

[admin]

Hi,

We store all jobs in a control table and create a scheduler job, which will call all jobs from control table. All parameters can be defined in scheduler job and write a code in the job control of scheduler job to assign a value to the parameter by calling DSSetParam function and scheduler will be run by using Remote exec.

Regards
Saravanan




"derick j JOSE"
cc:
Subject: Defining global constants for runtime
27-Sep-2001
02:08
Please respond
to
datastage-users

Sender Info:
No Sender Info
found in the
address Book







Hi,
We have facility in datastage to acept input from the end user as a parameter.And some parameters will be common across all the jobs.So Is there any way to define a global constant with value .So that all the jobs will take the same value from the global constant.Can anybody help me.

Thanks
Tina




______________________________________________________________________________________

Visit us at www.singaporeair.com. ______________________________________________________________________________________