Search found 42189 matches

by chulett
Fri Mar 24, 2006 8:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: JOB report on Category/Folder
Replies: 18
Views: 4521

gateleys wrote:Hey Jules...

Sorry, Jules has been dead for almost 100 years now. :wink:
by chulett
Fri Mar 24, 2006 7:33 am
Forum: Site/Forum
Topic: Site slow?
Replies: 3
Views: 2000

Site slow?

Really seems to be dragging ass when posting... or is it just me? Don't think so as we're starting to seem some double-posts, first sign of slowness in my experience.

Hmm... nothing seems to be happening, let me click 'Submit' again. :wink:
by chulett
Fri Mar 24, 2006 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is There any way to abort a job after 50 warnings
Replies: 16
Views: 3424

Yes. Completely separate sequence jobs.
by chulett
Fri Mar 24, 2006 7:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot kill a running Job
Replies: 4
Views: 3100

That's because it deleted and recreated the log file for the job. Your problem with the 'blink' error meant the job's original log was corrupted, more than likely because it had exceeded the 2GB boundary. There are other, simpler ways of solving that particular problem. :wink:
by chulett
Fri Mar 24, 2006 7:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is There any way to abort a job after 50 warnings
Replies: 16
Views: 3424

If by that you mean running a series of jobs via a Sequencer and you want individual jobs to have different 'Abort after' warnings levels - you can't. That kind of thing would require custom job control code.
by chulett
Fri Mar 24, 2006 7:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is There any way to abort a job after 50 warnings
Replies: 16
Views: 3424

That's fine... whatever Warning Limit is in effect for the 'parent' Sequence job itself will be passed to all 'child' jobs that it runs automatically.
by chulett
Fri Mar 24, 2006 7:12 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 34623

The simplest way is via a Custom Routine that just takes a value in and calls DSSetUSerStatus using that value. You can then either decide to pass the input argument back as the 'answer' or pass back a '0', depending on exactly how you would use it. For example: Call DSSetUserStatus(Arg1) An...
by chulett
Fri Mar 24, 2006 6:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TimeStamp with milliseconds in PX job
Replies: 5
Views: 1270

Not asking for much, eh? Milliseconds and a timezone. :lol:

Check this post from our dear friend Arnd, it covers the milliseconds part and can probably be leveraged for both.
by chulett
Fri Mar 24, 2006 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: kill job using job id
Replies: 15
Views: 6609

Well, there's always the 'Stop' button in the Director. Other than that there's the operating system which can be used to end any process your have the permissions to put down. On UNIX that would be the 'kill' command against the appropriate PID. Tell us what "i tried to kill the job but cudn succee...
by chulett
Thu Mar 23, 2006 8:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Processing missing files in a directory.
Replies: 5
Views: 1166

Specifically, page 6-31 of the Designer's Guide (version 7.5.1A) is where you want to start reading. There is a section on the Start Loop Activity, End Loop Activity and User Variables Activity stages with examples of how they can be used in a job. Don't be afraid to experiment. Not everything is ex...
by chulett
Thu Mar 23, 2006 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing parameter out of datastage job
Replies: 21
Views: 34623

Search the forum or the online help for USERSTATUS. This can be set with a single value inside a Server job and then easily picked up in a Sequencer and passed in as a parameter to a downstream job.
by chulett
Thu Mar 23, 2006 1:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: High Availability
Replies: 7
Views: 2441

There have been high availability sessions at the last two conferences. It centres around the RTI pack which can automatically allocate jobs to available servers. If one server goes down or is fully loaded it allocates the job to another server. It does come at an extra cost, though I have no idea ...
by chulett
Thu Mar 23, 2006 12:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Updating rows in Oracle
Replies: 2
Views: 823

Just like that. What kind of actual problem are you having? You need to send in the columns to be used in the 'where' clause marked as Key fields. The fields to actually be updated by the generated SQL are the non-Key fields, send those in with the values you want to update them to. Lastly, based on...
by chulett
Thu Mar 23, 2006 11:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS Sequences
Replies: 2
Views: 908

Since the job name is unique in the Project, it doesn't really matter to the Sequence job what category they live in. :wink:
by chulett
Thu Mar 23, 2006 9:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Passing XML Filename as a parameter
Replies: 4
Views: 1490

Outputs / Properties / Wildcard. That controls what file(s) are read. If you don't use a wildcard pattern there but use a 'normal' filename it will just read that file in. You can use a parameter there in either case.