Search found 42189 matches

by chulett
Thu Feb 12, 2009 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File Stage - row 1, too many columns in record
Replies: 16
Views: 5229

I used both with no issues.
by chulett
Thu Feb 12, 2009 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HTML - Job RUn
Replies: 13
Views: 4282

Dang, can't find anything other than posts mentioning the fact that you can do this if you put dsjob and 'associated libraries' on the other machine. Suggestion: copy dsjob.exe over to the other machine, execute it from a command prompt and see what it complains is missing. Hopefully it's as simple ...
by chulett
Thu Feb 12, 2009 10:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HTML - Job RUn
Replies: 13
Views: 4282

Somewhere in the documentation that ships with the product, if I could be more specific than that, I would. It's also been mentioned here, from what I recall, I'll see if I can find a reference to it.

If someone else has the details, feel free to chime in!
by chulett
Thu Feb 12, 2009 10:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HTML - Job RUn
Replies: 13
Views: 4282

If they have the client software installed, or at least the minimum components needed for 'dsjob' then sure, they can. That minimum is documented somewhere, from what I recall.
by chulett
Thu Feb 12, 2009 10:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequential File Stage - row 1, too many columns in record
Replies: 16
Views: 5229

That would be because this really isn't true: Check your column lengths, if the length of the data is longer than the permitted length, it will nudge the delimiters to the next column Sizes only matters when reading a fixed-width file, otherwise it will happily read 100 characters from a delimited f...
by chulett
Thu Feb 12, 2009 9:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HTML - Job RUn
Replies: 13
Views: 4282

The job will always run on the server. You can initiate it from your desktop, however, using dsjob just like you would from the server command line. Or via the Director, of course.
by chulett
Thu Feb 12, 2009 9:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Functions Documentation
Replies: 4
Views: 2183

Those would be in the BASIC documentation, I do believe.
by chulett
Thu Feb 12, 2009 8:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: orchadmin
Replies: 5
Views: 4354

There's no dsenv file on a Windows server, so everything is via environment variables. Not sure, but I think you need to reboot the server after adding new ones. :?
by chulett
Thu Feb 12, 2009 8:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MAx of two negative decimal
Replies: 6
Views: 1510

Re: MAx of two negative decimal

consulting wrote:My requirement is I want to find the max of two negative decimals
for eg;

max(-89.62,-88.02) I want the output as -89.62
As noted, the 'max' of those two values is -88.02 as -89.62 is less than -88.02.
by chulett
Thu Feb 12, 2009 8:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reading the file blockwise
Replies: 5
Views: 1320

Map how? Give us an example of what that means.
by chulett
Thu Feb 12, 2009 6:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: reading the file blockwise
Replies: 5
Views: 1320

my requirement is i need to read the first block all together at once and after parsing the first block then the second block needs to read all together and so on. What does 'parse' mean here? After you've read all of the records from a 'block', what exactly do you need to do before you start on th...
by chulett
Thu Feb 12, 2009 6:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Iconv MD code question
Replies: 3
Views: 1351

Let's approach this from a different angle - how about you let us know what you are trying to accomplish? Meaning, rather than focusing on your perceived solution, let us know what the problem is you are trying to solve. I believe that Fmt() is your answer, but prefer not to guess.
by chulett
Thu Feb 12, 2009 6:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job is not in the right state
Replies: 7
Views: 2592

First you'd have to definitely know what the issue is. We've given you some possibilities, let us know which is the culprit and we can go from there.
by chulett
Wed Feb 11, 2009 5:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence aborts without running all jobs
Replies: 2
Views: 1851

Re: Sequence aborts without running all jobs

Hmmm... don't really have time to absorb all of this, but wanted to single this out at the moment: The Terminator is set to "Abort without sending STOP requests" and "Wait for all jobs to finish first." This means "Wait for all currently running jobs to finish first", n...
by chulett
Wed Feb 11, 2009 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Partition Table option in Oracle Enterprise Stage
Replies: 4
Views: 2386

Well... there will be specific indexes that support the partitioning, but yes - only if the table itself is partitioned.