Page 1 of 1

Default values in datastage job

Posted: Tue Apr 30, 2002 8:09 am
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

Posted: Thu May 02, 2002 7:53 pm
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.

Posted: Sat May 04, 2002 8:54 pm
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