Changes to DS_JOBOBJECTS are not required.
Siva is showing you the form of the 200+ update statements you could use in place of the 200+ changes using Manager or Designer!
If there is a systematic change to be made (as a silly example you might want to name your jobs JOB0001, JOB0002, and so on), you could create a DataStage job that would do it. Otherwise, you're up for 200+ manual changes: no short cut.
Make very sure you have a backup before you muck about with DS_JOBS because absolutely everything in the Run Time part of the Repository depends on the name to number mapping in the DS_JOBS table.
Code: Select all
CREATE.FILE DS_JOBS_COPY DYNAMIC
COPY FROM DS_JOBS TO DS_JOBS_COPY ALL OVERWRITING
A less silly example might be to replace one string with another in all job names. For example all your jobs are named Load... and you wanted them to be renamed Transfer... - in this case you could use the Ereplace function in the DataStage job.
Or, in SQL:
Code: Select all
UPDATE DS_JOBS SET NAME = 'Transfer' || SUBSTRING(NAME FROM 5) WHERE NAME LIKE 'Load%';
At this point, none of your job sequences work any more, and none of your job control code works any more, and none of your calls to functions like UtilityRunJob work any more.
Effecting the same changes within the design time objects for these is a far more difficult proposition, and relies on knowledge about how design time objects are stored in the DataStage Repository that is not in the public domain. Of course, if you have no job sequences, job control routines or calls to UtilityRunJob, you're laughing (but are probably in the early phases of development or using third party scheduling tools).