Search found 53125 matches

by ray.wurlod
Thu Sep 08, 2005 1:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pattern Matching in DS PX
Replies: 3
Views: 1140

BASIC Transformer stage?
by ray.wurlod
Thu Sep 08, 2005 1:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regarding Date conversion
Replies: 17
Views: 6101

Sorry, should have been clearer. Substring from the expression editor's operator menu. It's represented in the expression using square brackets.
by ray.wurlod
Wed Sep 07, 2005 11:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regarding Date conversion
Replies: 17
Views: 6101

Look a bit more closely at the right(left(svr,2),2) part of your expression. Consider using the Substring function for the middle component.
by ray.wurlod
Wed Sep 07, 2005 9:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Referencing Environment Variables in Routine
Replies: 5
Views: 1470

Not direct, but you can use DSExecute. Either go to the operating system and echo the value of the environment variable, or go to UV and use the ENV command. I prefer the former, though you need to make it platform specific, for example echo %TMPDIR% for Windows but echo $TMPDIR for UNIX.
by ray.wurlod
Wed Sep 07, 2005 7:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Date conversion from mm/dd/yy to CCYY-MM-DD
Replies: 8
Views: 3781

Suggestion to all employers of consultants: make sure (a condition of hire?) that anything the consultant leaves is tagged with the consultant's contact details, and some kind of warranty as to fitness for purpose (plus, maybe, some form of support undertaking).

You won't regret it.
by ray.wurlod
Wed Sep 07, 2005 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to determine partitioning of pre-existing PX dataset
Replies: 7
Views: 2640

Right mouse click in the background area in Monitor. It's the same menu from which you enable/disable visibility of %CP.
by ray.wurlod
Wed Sep 07, 2005 3:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Routines have disappeared
Replies: 2
Views: 2034

It could be a problem with indexing in the Repository; the clients use the indexes (particularly the CATEGORY index) to retrieve components for display. At some time when there are no components open for editing in the project, use either the Administrator client Command window or a telnet session i...
by ray.wurlod
Wed Sep 07, 2005 1:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: COUNT Problem
Replies: 12
Views: 2623

It doesn't have to be in the project directory. Search the forum for SETFILE and VOC.
by ray.wurlod
Wed Sep 07, 2005 1:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server Shared Container and Parallel Shared Container
Replies: 1
Views: 1050

1) Server shared containers contain server stage types, parallel shared containers contain parallel stage types.
2) You may already have developed the functionality and prefer to reuse the component.
3) Reusability of logic across multiple jobs.
4) Depends.
by ray.wurlod
Wed Sep 07, 2005 1:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server Shared Container in a Parallel job
Replies: 1
Views: 899

At the end of Chapter 2 in Parallel Job Developer's Guide there is a discussion on the restrictions on using server job shared containers in parallel jobs. Read that, and see whether you've violated any of them.
by ray.wurlod
Tue Sep 06, 2005 11:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Automated QA
Replies: 5
Views: 1445

(OK, I'll bite.) :P

Documentation should be the first step. One should always leave any IT work in a state that anyone competent can take over without having to waste time researching what the hell it does (or is intended to do).
by ray.wurlod
Tue Sep 06, 2005 11:46 pm
Forum: IBM QualityStage
Topic: QualityStage Ruleset problem
Replies: 5
Views: 2936

It's usually the Data folder in your Project that these files are written.

I would have to check whether the Rules Analyzer uses this folder, however, and my current site isn't using QS. Anyone else?
by ray.wurlod
Tue Sep 06, 2005 9:05 pm
Forum: Enhancement Wish List
Topic: Disable View Data
Replies: 2
Views: 1826

Mere mortals should not be permitted to view the infinite. 8)
by ray.wurlod
Tue Sep 06, 2005 8:54 pm
Forum: Enhancement Wish List
Topic: Disable View Data
Replies: 2
Views: 1826

Disable View Data

The View Data button should be disabled if the sequential file name is /dev/null (UNIX) or ...\NUL (Windows).

Call it idiot-proofing.
by ray.wurlod
Tue Sep 06, 2005 8:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unix sort error
Replies: 3
Views: 1027

Chances are that /data/files/customers/custFile has become too large for the sort command to manage given your allocation of memory. What are your ulimit values? (Use the command ulimit -a to find out.)