Search found 42189 matches

by chulett
Sat Oct 11, 2014 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController Error
Replies: 4
Views: 4835

:!: Please start a new post. Document for us your error.
by chulett
Sat Oct 11, 2014 7:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Data PUll is slow in Datastage 7.5
Replies: 4
Views: 3403

All good advice from Eric. Just want to clarify there is no magic parameter but proper setting of the Array Size may help - IF the 'pull' is actually the culprit. Try this to help with his first bit of advice: add a constraint to your output link of @FALSE so that nothing gets written to the target ...
by chulett
Fri Oct 10, 2014 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TXT File with fixed length fields
Replies: 9
Views: 10191

joycerecacho wrote:And It is not necessary the option 'Record Delimiter = Fixed'.
I assume you mean "Record length = fixed".
by chulett
Fri Oct 10, 2014 12:20 pm
Forum: General
Topic: Job Name If There Are Any In Aborted Status
Replies: 13
Views: 3656

Thinking about the Director, I seem to recall a filter option that would allow you to show only aborted jobs. If that's the case, then:

1. Turn off refresh
2. Turn on the Filter for Aborted only
3. Turn off Category display
4. Print to file

The order is important to minimize waits. :wink:
by chulett
Fri Oct 10, 2014 12:14 pm
Forum: General
Topic: Job Name If There Are Any In Aborted Status
Replies: 13
Views: 3656

If you go the Director route, I'd suggest turning off the refresh as when it happens it will be extremely... painful. :wink: Is there anyone there that can help you put together a shell script? You'd basically need to list projects, jobs and then fetch job status: Listing projects and jobs Retrievin...
by chulett
Fri Oct 10, 2014 10:35 am
Forum: General
Topic: New Line character on Windows
Replies: 17
Views: 6010

Excellent. For posterity's sake and anyone who stumbles across this thread in the future, can you share what part of all that was the actual solution in your case? Thanks.
by chulett
Fri Oct 10, 2014 10:32 am
Forum: General
Topic: Job Name If There Are Any In Aborted Status
Replies: 13
Views: 3656

Can anyone confirm what release added the Administration Console? Not sure that's the correct name for it. Or Operations Dashboard, perhaps? Wondering if it would automatically show something like this so as to not need to script / build something? But thinking that was post 8.5, however.
by chulett
Fri Oct 10, 2014 9:57 am
Forum: General
Topic: Job Name If There Are Any In Aborted Status
Replies: 13
Views: 3656

Welcome. I actually took a quick stab at this when you posted it over on the ITToolbox forums but it looks like it hasn't passed from moderation yet. How are your shell scripting skills? Are you familiar with using dsjob from the command line? It would be easy to script something to find all jobs an...
by chulett
Fri Oct 10, 2014 9:30 am
Forum: General
Topic: New Line character on Windows
Replies: 17
Views: 6010

Looping is discussed in a goodly amount of detail in the manuals, in your shoes I would hunt those down and study the examples there. Also, perhaps this post of mine might help or you can do an exact search for $Counter here (note the dollar sign) for many examples people have posted over the years.
by chulett
Fri Oct 10, 2014 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Single quotes getting replaced in ODBC stage
Replies: 5
Views: 2628

aneesh5142 wrote:Not able to figure out how quotes are getting replaced and when we are giving '\' how it is working.
That backslash is an escape character.
by chulett
Thu Oct 09, 2014 6:49 pm
Forum: General
Topic: New Line character on Windows
Replies: 17
Views: 6010

Look into the User Variables stage.
by chulett
Thu Oct 09, 2014 9:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Migrating 9.1 SDKSequences between environments
Replies: 3
Views: 2886

Remove the directory you copied over. Run the KeyMgtGetNextValue routine so that it creates an empty one properly with the VOC entry and everything else it needs. Then copy your copy back over the top of what it created.

You could 'test' the routine to run it, no need for a job to do that.
by chulett
Thu Oct 09, 2014 9:10 am
Forum: General
Topic: Avoid calling sh.exe
Replies: 7
Views: 2702

I don't think the percentage of people running Windows servers is all that high out there so not sure how many people here could really help. Expecially with something odd like this. :(
by chulett
Thu Oct 09, 2014 7:17 am
Forum: General
Topic: Avoid calling sh.exe
Replies: 7
Views: 2702

Then it seems you should continue to work with IBM, tell them they provided an incomplete (or incorrect) solution.