Search found 61 matches

by wasimraja
Mon Mar 10, 2008 5:11 pm
Forum: General
Topic: Modify all the jobs in a project
Replies: 16
Views: 6986

Thanks Ken.
by wasimraja
Mon Mar 10, 2008 4:23 pm
Forum: General
Topic: Modify all the jobs in a project
Replies: 16
Views: 6986

alright. I guess I am confused. I did a search for Batch::UTILSetDefaultParameters and this is what I found. If Update = "Y" Then Open "DS_JOBS" TO F.JOBS Then Read prototypenbr from F.JOBS,PrototypeJob Then PROTOFILE = "DS_JOB":prototypenbr Open PROTOFILE TO F.PROTO Th...
by wasimraja
Mon Mar 10, 2008 4:08 pm
Forum: General
Topic: Modify all the jobs in a project
Replies: 16
Views: 6986

Can you please tell me how to run this "UTILSetDefaultParameters.bat"
by wasimraja
Mon Mar 10, 2008 3:39 pm
Forum: General
Topic: Modify all the jobs in a project
Replies: 16
Views: 6986

Thanks Craig.

Is there a utility that can do this for defining subroutines too?
by wasimraja
Mon Mar 10, 2008 3:30 pm
Forum: General
Topic: Modify all the jobs in a project
Replies: 16
Views: 6986

My lucky day. :D

Thanks Ken
by wasimraja
Mon Mar 10, 2008 3:22 pm
Forum: General
Topic: Modify all the jobs in a project
Replies: 16
Views: 6986

Did you mean Kenneth Bland, Craig?

For some reason, whatever personal message that I send through DSxchange stays forever in my outbox rather than the sentbox. I guess I will just have to hope that he sees this. :)
by wasimraja
Mon Mar 10, 2008 3:15 pm
Forum: General
Topic: Modify all the jobs in a project
Replies: 16
Views: 6986

Modify all the jobs in a project

Hi All,

I have a project which contains 'n' number of jobs. I want to add a job parameter to each of the jobs with the value as $PROJDEF. Is there a simpler way of doing this rather than modifying the jobs one by one.

Your time is appreciated.
by wasimraja
Thu Mar 06, 2008 9:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in writing log summary to a file
Replies: 13
Views: 5544

Thanks Ray.

and thanks for the tip Craig. I will try to that outside of the jobs.

I am marking this topic as resolved.

I cant thank you guys enough.
by wasimraja
Thu Mar 06, 2008 8:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in writing log summary to a file
Replies: 13
Views: 5544

Thanks Shane. Works like a charm.

Only thing is it doesnt write anything if the job is stopped.
by wasimraja
Thu Mar 06, 2008 8:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in writing log summary to a file
Replies: 13
Views: 5544

Though I couldnt read the content, I understood what you meant. It is always returning me DSJS.RUNNING as the job is still running. I understand that it shouldnt be a after-job subroutine.

About time I got a membership.
by wasimraja
Thu Mar 06, 2008 7:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in writing log summary to a file
Replies: 13
Views: 5544

My bad. I was thinking that each DSJS.<<status>> gives a different return integer.

I should be actually manipulating this inside the routine itself instead of worrying about the integer written to the log.

Will let you guys know if I am successful.
by wasimraja
Thu Mar 06, 2008 7:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in writing log summary to a file
Replies: 13
Views: 5544

Thanks Shane. That was exactly what I was looking for. I did three different runs where one finished, one aborted and one stopped. The log file had code "0" all the three times. Following is the code I used Status = DSGetJobInfo (DSJ.ME, DSJ.JOBSTATUS) Am I missing something or is there a ...
by wasimraja
Thu Mar 06, 2008 5:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in writing log summary to a file
Replies: 13
Views: 5544

Thanks Craig. I will check the help files for that. Meanwhile, is there a way that I can get the "Control" statement which says "Job X Finished" or "Job X aborted" by editing the existing code above.
by wasimraja
Thu Mar 06, 2008 5:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in writing log summary to a file
Replies: 13
Views: 5544

To add to the above details, the routine truncates lot of data to "(...)" in the file just like the way it it seen in the director log. Is there a way I can get the full details instead of "(...)"
by wasimraja
Thu Mar 06, 2008 5:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in writing log summary to a file
Replies: 13
Views: 5544

Problem in writing log summary to a file

Hi All, Following is the code I use to write the log to a target directory. I got this code from one of the posts in dsxchange. This writes the log summary for the particular job from where it is called. It writes the exact same log as in Director except the last line of type "Control". Ca...