Search found 53125 matches

by ray.wurlod
Mon Oct 29, 2007 7:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to use the string cycle option in Row Generator
Replies: 4
Views: 1801

Multiple Value properties, as suggested by balajisr, is the way to get this to work. I've done lots of them.
by ray.wurlod
Mon Oct 29, 2007 7:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we run two separate flows to a single target
Replies: 4
Views: 1172

Maybe. Probably. But not if the two flows are occurring simultaneously and writing to the same sequential file. This is an operating system restriction, not a DataStage restriction. One writer, or N readers. And you may run into locking (deadlock) issues if you are trying to insert the same keyvalue...
by ray.wurlod
Mon Oct 29, 2007 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job is running too long
Replies: 4
Views: 1169

Define "too long".
Surely it takes as long as it takes (all else being equal).
If it takes two hours and you expected it to finish in one, change your ideas so that you expect it to finish in two.
by ray.wurlod
Mon Oct 29, 2007 6:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to delete job from a project under command line
Replies: 21
Views: 13744

Why do you want to do this? DataStage's main strength - the way it's always been marketed - is the amount of coding/scripting that you DON'T have to do. You CAN delete a job from within the GUI. That's the DataStage way. Your assertion, therefore, is totally incorrect. As it happens, one CAN delete ...
by ray.wurlod
Mon Oct 29, 2007 4:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: File with multiple headers
Replies: 5
Views: 1588

Load values from row #1 and row #2 (as detected by @INROWNUM) into stage variables and from there into output columns. Constrain the output @INROWNUM = 3.
by ray.wurlod
Mon Oct 29, 2007 4:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: User Profiles
Replies: 1
Views: 668

Multiple users are managed by the operating system, whether UNIX or Windows. The same considerations apply to use of groups and DataStage roles. The only difference is how you set up users and groups; in Windows there are GUI front ends (Windows (!)) for doing these tasks.
by ray.wurlod
Sun Oct 28, 2007 10:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job is running too long
Replies: 4
Views: 1169

One way is to change your expectations.
by ray.wurlod
Sun Oct 28, 2007 10:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implied and Explicit decimal data type
Replies: 3
Views: 3151

The simple answer is that there are no data types in server jobs (internally), but parallel jobs executed in a strongly-typed C-language environment.
by ray.wurlod
Sun Oct 28, 2007 10:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: performance issue with incremental load CRC job.
Replies: 7
Views: 3239

We have no idea what your job design is, so it is impossible to recommend anything apart, perhaps, considering using multiple parallel streams of processing, if your operating system has sufficient spare resources.
by ray.wurlod
Sun Oct 28, 2007 2:49 am
Forum: Site/Forum
Topic: Read or Unread
Replies: 3
Views: 2595

Was able to see it again today. Mind you, I'm not using my usual machine; I'm using an Arabic Windows 2003 Server with IE6. There's a workaround - refreshing the page updates the icons to "all have been read" status. But without explicitly refreshing the page that does not occur. Will continue to mo...
by ray.wurlod
Sun Oct 28, 2007 2:46 am
Forum: Site/Forum
Topic: new Forum Event and Conferences
Replies: 5
Views: 3817

That particular one doesn't seem to be private.
by ray.wurlod
Sun Oct 28, 2007 2:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Phantoms are running after job aborted
Replies: 5
Views: 1066

NEVER kill DataStage processes.
by ray.wurlod
Sun Oct 28, 2007 2:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot save the new job..........
Replies: 7
Views: 1483

Time to mark the thread as resolved.
by ray.wurlod
Sat Oct 27, 2007 10:59 pm
Forum: Site/Forum
Topic: Read or Unread
Replies: 3
Views: 2595

Read or Unread

Is it me, or are the read/unread icons on the index page not resetting to unread once all the posts in a forum have been read? This appears to be new behaviour since yesterday.
by ray.wurlod
Sat Oct 27, 2007 10:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: generate 4 digit sequence number
Replies: 5
Views: 1293

How do you propose to guarantee the "+1" requirement across an arbitrary number of parallel processing nodes? Are you going to introduce a bottleneck by forcing a Column Generator stage to execute in sequential mode? Is this, indeed, a sensible requirement in a parallel job?