Search found 42189 matches

by chulett
Tue Feb 12, 2008 7:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Naming a file with the current timestamp?
Replies: 8
Views: 2492

Or write it out with a static name and then 'after job' rename it using your O/S, adding a timestamp in the process.
by chulett
Tue Feb 12, 2008 7:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to Save Jobs
Replies: 8
Views: 3131

Repository corruption. Have you had any issues you are aware of, space problems where DataStage is installed for example? Can you save it under a new name? Is it just this job or, as your subject says, are you unable to save jobs right now? I would suggest trying to reindex your project and see if t...
by chulett
Tue Feb 12, 2008 7:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RT_CONFIG permission issues
Replies: 5
Views: 1415

Probably. Have you checked out this FAQ post?
by chulett
Mon Feb 11, 2008 7:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: FTP
Replies: 7
Views: 1405

That's because you are returning the output from the command as the status, rather than the status itself. Assuming your routine code still looks as it did in your first post, correct it to look like this: Arg1=' ETL server pathname\FTP.bat' Command = Arg1 Call DSExecute("DOS", Command...
by chulett
Mon Feb 11, 2008 4:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MultiInstance Sequence - InvocID not being passed
Replies: 10
Views: 2266

Actually, the question as to how the Invocation ID is getting passed from the Master Sequence to each 'sub Sequence' and from there to each Multi Instance job has never really been answered. All we know is how the Master Sequence gets invoked. How is all this setup in your Sequences? Are you using J...
by chulett
Mon Feb 11, 2008 1:01 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Package
Replies: 14
Views: 4384

Also ensure whatever user the job will be leveraging has execute grants to the package in question.
by chulett
Mon Feb 11, 2008 12:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Check to ETL job
Replies: 5
Views: 1270

These kind of questions should go back to whomever gave you those requirements. They are the only ones who can determine if you are interpreting them correctly, not us.
by chulett
Mon Feb 11, 2008 10:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link counts return zero
Replies: 9
Views: 2741

So it's either misspelled (case sensitive!) or perhaps it's not pointing to an active stage, i.e. a Transformer?
by chulett
Mon Feb 11, 2008 9:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Jobs not running
Replies: 20
Views: 3913

chulett wrote:Drop the test project, recreate it empty and then populate it from a production export.

:wink:
by chulett
Mon Feb 11, 2008 9:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link counts return zero
Replies: 9
Views: 2741

Cr.Cezon wrote:You must use DSGetStageInfo(JobHandle, Stage, DSJ.STAGEINROWNUM ) instead of DSGetLinkInfo

Must? No. DSGetLinkInfo is just as an appropriate choice here. Not quite sure what's going on, but it sure as heck will do the job. [ponder,ponder]
by chulett
Mon Feb 11, 2008 9:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance Metrics
Replies: 9
Views: 2822

ArndW wrote:I don't think Ray has stated that Rows/Second are meaningless.

Hey Arnd - try a search for 'meaningless metric' and see what comes up. :wink:
by chulett
Mon Feb 11, 2008 9:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resetting a job
Replies: 13
Views: 3181

Yah, it does help to read the docs. :wink:
by chulett
Mon Feb 11, 2008 8:59 am
Forum: General
Topic: hexatridecimal or base 36
Replies: 13
Views: 6132

:lol: Umm... yah! That's exactly what I meant.
by chulett
Mon Feb 11, 2008 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting "Name" field to FirstName,MiddleName,Las
Replies: 4
Views: 1351

Exactly - you need to determine what each part must be when you don't have 'all three parts', and then enforce those rules.
by chulett
Mon Feb 11, 2008 8:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Resetting a job
Replies: 13
Views: 3181

Just use DSPrepareJob. No need to check ahead of time, if it needs to be reset it will reset it, otherwise it does nothing. Unless you have some need to log everything found: the current state, if it needed to be reset, etc.