Search found 53125 matches

by ray.wurlod
Wed Apr 06, 2011 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic:
Replies: 9
Views: 9508

Give your clients a list of the ASCII7 characters, with the advice that their decision means that these are the only characters that can be processed.
by ray.wurlod
Wed Apr 06, 2011 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is the significance of scratch area?
Replies: 3
Views: 1497

Surely the scratch area is the location of the itch.
:lol:
by ray.wurlod
Wed Apr 06, 2011 3:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Display and Import errors for SOME jobs
Replies: 4
Views: 2512

It's a memory issue on the client, not on the server (to which commands like shmtest relate). Close some other windows.
by ray.wurlod
Wed Apr 06, 2011 4:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: i have 3 records,in that i want to delete first record
Replies: 3
Views: 1861

Use a constraint expression in a Transformer stage or a Filter stage that does not pass ename='abc'
by ray.wurlod
Wed Apr 06, 2011 4:34 am
Forum: General
Topic: Architecture of Datastage 8
Replies: 3
Views: 2190

The explanation in the manuals, particularly the installation and administration manuals, is reasonably clear. DataStage is one of many products making up the IBM InfoSphere Information Server suite, so it's a bit unreasonable to talk about the architecture of DataStage as if it were still a stand-a...
by ray.wurlod
Wed Apr 06, 2011 4:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is the significance of scratch area?
Replies: 3
Views: 1497

Based on your research so far, what do YOU believe to be the significance of scratch area?

Is this an interview question?
by ray.wurlod
Wed Apr 06, 2011 2:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server ODBC connector Exception
Replies: 8
Views: 14549

Try using CHR() rather than CHAR() in the REPLACE() function.
by ray.wurlod
Wed Apr 06, 2011 12:27 am
Forum: General
Topic: Trigger the list of jobs at the same time
Replies: 8
Views: 2317

I just scheduled four jobs for the same time from the DataStage Director. To the nearest minute (that is, as far as anyone could tell by looking at Director) they all started at the same time and they all ran concurrently.
by ray.wurlod
Tue Apr 05, 2011 11:32 pm
Forum: General
Topic: Trigger the list of jobs at the same time
Replies: 8
Views: 2317

Unless you have a multi-threaded scheduler you're never going to get more than one job to start at precisely the same time. It really doesn't matter anyway, because of variability in job startup times. It's enough to have them start very close together. The easiest way to do this is to schedule them...
by ray.wurlod
Tue Apr 05, 2011 8:53 pm
Forum: General
Topic: Sidekick Needed
Replies: 0
Views: 730

Sidekick Needed

We have a need for a reasonably experienced DataStage developer to work in Canberra (Australia). Must have a DSA security clearance of Confidential or higher. Site is currently making the transition from version 8.1 to 8.5. Job types are parallel and sequence. Most Information Server tools are in th...
by ray.wurlod
Tue Apr 05, 2011 8:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to understand the warning message...
Replies: 4
Views: 1701

You really need to study partitioning in greater depth. The alert message can safely be ignored (for example demoted to Informational using a message handler). Entire partitioning uses shared memory on SMP architecture; the alert message is telling you that that can't happen because Entire is not th...
by ray.wurlod
Tue Apr 05, 2011 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Count(*)
Replies: 22
Views: 6734

I could give a parallel job answer, since you posted it in the parallel jobs forum. However your mention of a Link Collector suggests server job, and this is how you marked the job type. Seems to me that this could be solved with three links each with its own counting Aggregator stage. One link hand...
by ray.wurlod
Tue Apr 05, 2011 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xmla scripts in datastage
Replies: 14
Views: 5946

A Google search for "execute XMLA file" returned over 20,000 hits. Surely one of these will have your answer!
by ray.wurlod
Tue Apr 05, 2011 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Repeating Headers
Replies: 5
Views: 1829

Perhaps you could post an example of what you mean?
by ray.wurlod
Tue Apr 05, 2011 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: List.readu out put Details
Replies: 2
Views: 1305

The projectname&!DS.ADMIN!& locks are taken on a non-existent record. Note that the lock type is "RL" - that is, it's a shared lock. The purpose of this lock is to indicate that there is a connected client; some administrator tools require exclusive access to the project, and check...