Search found 53125 matches

by ray.wurlod
Wed Jul 06, 2011 5:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: multiple rows to single row
Replies: 15
Views: 5846

In Server jobs the Aggregator stage has a "keep first/last" capability.
by ray.wurlod
Wed Jul 06, 2011 5:05 pm
Forum: General
Topic: login and logout logs in datastage server
Replies: 3
Views: 1244

It's not automatically captured. You can modify the operation of each project to capture this information by modifying the paragraphs in VOC called LOGIN and LOGOUT, typically to execute a routine to capture and record that information. Whatever you do it is absolutely vital that the LOGIN is "...
by ray.wurlod
Wed Jul 06, 2011 5:03 pm
Forum: General
Topic: Self Deadlatch error on device
Replies: 6
Views: 1749

Warning: geek content

The unohist file is a relic of UniVerse. Its purpose is to attempt to re-issue the same internal UniVerse user number (as reported by @USERNO) for a subsequent login in the same tty.
by ray.wurlod
Wed Jul 06, 2011 5:00 pm
Forum: General
Topic: Releasing a crashed Routine connection
Replies: 3
Views: 979

Did you try logging it out from Director or from DS.TOOLS ?
by ray.wurlod
Wed Jul 06, 2011 4:58 pm
Forum: General
Topic: Using $Counter in ExecCommand
Replies: 5
Views: 2256

How did you produce the "list of things" on which the StartLoop activity bases its looping?
by ray.wurlod
Wed Jul 06, 2011 4:56 pm
Forum: General
Topic: InfoSphere 8.5 Blueprint Director
Replies: 2
Views: 1159

log wrote:Application "com.ibm.im.launchpoint.diagram.application.LaunchPointApplication" could not be found in the registry.
Looks like the installation was incomplete.
by ray.wurlod
Wed Jul 06, 2011 4:55 pm
Forum: General
Topic: after job Subroutine causing the isssue
Replies: 1
Views: 1251

I doubt that you can pass an activity variable to an after-job subroutine, since activity variables have scope only in the sequence, not within individual activities (excepting, of course, activity variables from upstream activities). Since you have the job handle - I presume you're using DSJ.ME - y...
by ray.wurlod
Wed Jul 06, 2011 2:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Row into columns
Replies: 6
Views: 2651

This is a pivot. Use a Pivot stage.

You may also need to use a Column Import stage to break the comma-delimited string into separate fields.
by ray.wurlod
Wed Jul 06, 2011 2:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: divide the Data
Replies: 1
Views: 1252

This is a pivot. Use the Pivot stage.
by ray.wurlod
Wed Jul 06, 2011 2:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to replace a string with new string ?
Replies: 1
Views: 1790

Search DSXchange for pxEreplace() function, posted by DSGuru2B.
by ray.wurlod
Wed Jul 06, 2011 2:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to save Changes done thru Administrator
Replies: 1
Views: 1017

Is there any information in SystemOut.log or SystemErr.log that might explain what the problem is?
by ray.wurlod
Tue Jul 05, 2011 3:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic needed
Replies: 16
Views: 8197

The key has two columns, Col1 and Col2.
by ray.wurlod
Tue Jul 05, 2011 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic needed
Replies: 16
Views: 8197

A key-based partitioning algorithm immediately downstream of the Sequential File stage.
by ray.wurlod
Tue Jul 05, 2011 2:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pattern Matching
Replies: 11
Views: 4366

Only DB2 and Oracle support sparse lookup. Sorry.
by ray.wurlod
Tue Jul 05, 2011 2:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic Queries in ODBC stages
Replies: 9
Views: 2148

Use more processing nodes. (Throw more resources at it.)