Search found 53125 matches

by ray.wurlod
Wed Apr 18, 2012 2:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel datasets
Replies: 7
Views: 2233

There will be orphaned segment files in this scenario, and the Data Set utility (by which I assume you mean the Data Set Management utility) can not identify them.
by ray.wurlod
Wed Apr 18, 2012 2:58 am
Forum: General
Topic: Equivalent of WeekdayFromDate in Job sequence
Replies: 7
Views: 3277

DataStage doesn't generate the trailing linefeed - the cat command does.
by ray.wurlod
Wed Apr 18, 2012 1:43 am
Forum: General
Topic: Equivalent of WeekdayFromDate in Job sequence
Replies: 7
Views: 3277

The @FM is the trailing linefeed. If you don't remove that, then the Iconv() function won't work. Trim() gets rid of extraneous white space, just in case there is any.
by ray.wurlod
Wed Apr 18, 2012 1:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Complex Flat File Stage
Replies: 27
Views: 10509

Have you specified the "A margin" to be in the correct column?
by ray.wurlod
Tue Apr 17, 2012 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Find the character in a string
Replies: 11
Views: 14684

There's a very elegant solution if you're prepared to use the BASIC Transformer stage (or a server Transformer in a server Shared Container in your parallel job, or a server job). You can use server pattern matching via the MatchField() function, and delimited field replacement via the FieldStore() ...
by ray.wurlod
Tue Apr 17, 2012 4:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: parallel datasets
Replies: 7
Views: 2233

It all depends on whether the original two nodes' resource disk settings are included in the new four node configuration file or not.
by ray.wurlod
Tue Apr 17, 2012 4:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file error
Replies: 2
Views: 1028

VOC isn't your issue (yet). You don't have permission to create the operating system file. Solve that one first.
by ray.wurlod
Tue Apr 17, 2012 4:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Find the character in a string
Replies: 11
Views: 14684

"WS" or "TS"?

If it's always two characters then an approach using substring would be the most efficient. For example:

Code: Select all

InLink.TheString[1,2] : "TS" : InLink.TheString[3,Len(InLink.TheString)-2]
by ray.wurlod
Tue Apr 17, 2012 1:41 am
Forum: General
Topic: Jobs disapper in the Director
Replies: 5
Views: 1176

Is anyone running Clear Status File from Director or from DS.TOOLS menu? Either of these is likely to reset status to Not Compiled.
by ray.wurlod
Tue Apr 17, 2012 1:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Make Vector stage
Replies: 1
Views: 977

Correct the lengths.
by ray.wurlod
Tue Apr 17, 2012 1:37 am
Forum: General
Topic: Unable to query the Datastage Repositary tables
Replies: 5
Views: 1669

The dsenv script sets up necessary environment variables to enable you to use the dssh environment. The fact that you can't open the unohist file may be related to permissions. This file is used in initialization of the dssh environment. You might like to try $DSHOME/bin/uv instead. After, of course...
by ray.wurlod
Mon Apr 16, 2012 11:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed Files Dictionary getting corrupted
Replies: 2
Views: 1168

There's nothing in the tool that does that. Find the culprit!
by ray.wurlod
Mon Apr 16, 2012 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date to Timestamp
Replies: 16
Views: 4747

Is 04/05 April 5th or 4th May?