Default values in datastage job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cwong
Charter Member
Charter Member
Posts: 26
Joined: Tue Apr 30, 2002 8:02 am
Location: Canada

Default values in datastage job

Post by cwong »

Hi all,

Have you tried removing the default values in datastage job with a batch job ?

This is considered as a safe-guard process after the jobs got migrated from development into production. Just in case and ideally to remove all default values that had entered for the parameters with a batch job (instead of manually thru the jobs).

The idea is like the batch job: CompileALL to compile jobs in batch mode massively.

Thanks in advance,

Cwong


cwong
chinek
Participant
Posts: 75
Joined: Mon Apr 15, 2002 10:09 pm
Location: Australia

Post by chinek »

not tried removing the default values, but you can replace these values with production ones. the way to do it is to export your development jobs and open up the export file (which is just a text
file with Notepad and run a Replace All for those development parameter values with your production ones.
Import these jobs to production and you're done.
cwong
Charter Member
Charter Member
Posts: 26
Joined: Tue Apr 30, 2002 8:02 am
Location: Canada

Post by cwong »

Thanks chinek.

Along with your suggestion, I will try with a job or script to "edit" the export file.

FYI, we use a GetParm routine to read in the values from a parameter file and assign to the parameter in the batch control job.

The intent is to clean out or empty out the default values after the job got migrated from DEV to production. After all, there are 2 separate DS servers and would not be so bad.

cwong

cwong
Post Reply