Search found 53125 matches

by ray.wurlod
Wed Nov 18, 2009 2:49 am
Forum: General
Topic: Aggregator adding 1 month while grouping
Replies: 5
Views: 1732

Aggregator aggregates. And only aggregates. Other stages perform other tasks. For example you might use a Transformer stage to effect re-formatting. I see no reference to your subject in your description. Do you mean "adding an additional month" or "adding 1 to the month value in the ...
by ray.wurlod
Tue Nov 17, 2009 10:45 pm
Forum: General
Topic: Problem with permission
Replies: 11
Views: 4274

Basically it's the directory where the thing throwing the error is. Or is meant to be.
by ray.wurlod
Tue Nov 17, 2009 10:45 pm
Forum: General
Topic: istool deploy package - problem with REPLACE option.
Replies: 5
Views: 5633

Category pathnames are specified with backslashes, if I recall correctly. Maybe you need something like \Jobs\myServer\SysTest01
by ray.wurlod
Tue Nov 17, 2009 6:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading the Surrogate key for Time_Dimension table
Replies: 5
Views: 1282

It would be useful to know the pertinent data types, too, because the answer will be different depending on what these are.
by ray.wurlod
Tue Nov 17, 2009 6:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot find parameter file record DSParams in &UFD&
Replies: 1
Views: 5108

&UFD& is an internal reference to the project directory. I'm guessing that the users do not have sufficient permission to this directory or specifically to the DSParams file within the directory. If it's not that, and someone has removed/renamed DSParams, then you are deep in the brown stuff...
by ray.wurlod
Tue Nov 17, 2009 6:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Split 'group by' result into files
Replies: 13
Views: 5111

In "Good Omens", by Terry Pratchett and Neil Gaiman, one of the characters calls his car Dick Turpin, because it's always holding up traffic.

Are we far enough off topic yet?

Please don't hijack threads unless yours is precisely the same issue (which it rarely is).
by ray.wurlod
Tue Nov 17, 2009 6:13 pm
Forum: General
Topic: istool deploy package - problem with REPLACE option.
Replies: 5
Views: 5633

Does the -preview option work (a) without -repl and (b)with -repl ?

Have you tried -repl rather than -replace, just in case "they" aren't parsing the command line options correctly?
by ray.wurlod
Tue Nov 17, 2009 4:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Loading the Surrogate key for Time_Dimension table
Replies: 5
Views: 1282

We don't do "urgent" or "very urgent". You see, your issue is not urgent for us. DSXchange is an all-volunteer site (no-one is compelled to respond) whose members post when and if they can. Therefore demands for urgent response we regard as offensive. If you need urgent response...
by ray.wurlod
Tue Nov 17, 2009 4:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: All the Job Activity details in a Sequence
Replies: 7
Views: 2104

Do you mean the jobs that are designed into the sequence as Job activities, or do you mean the jobs that are actually executed when the sequence runs (which may be only a subset of the first list, depending on the logic of the sequence)?
by ray.wurlod
Tue Nov 17, 2009 4:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal Termination
Replies: 11
Views: 4008

Code: Select all

CREATE.FILE DATA DSG_BP 19
by ray.wurlod
Tue Nov 17, 2009 4:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: USER IDS are revoked while running a sequence job
Replies: 4
Views: 2058

Please strive to use a professional standard of written English on DSXchange. It helps those whose first language is not English. Mine is, but I still struggled with what you had written. There is no message limit of 72 or 144 characters here; you can be as expressive as you wish. So SMS-style abbr...
by ray.wurlod
Tue Nov 17, 2009 6:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to use XML file as a source file
Replies: 9
Views: 2977

Please strive for a professional standard of written English here on DSXchange; it makes life easier for those whose first language is not English, and shows respect for other posters.
by ray.wurlod
Tue Nov 17, 2009 6:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extracting the Data from XML File
Replies: 17
Views: 7413

If you really want U to answer, why not send U a private message or email?
by ray.wurlod
Tue Nov 17, 2009 6:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extracting records from Binary files using server routine
Replies: 8
Views: 3467

Try the "MX0C" conversion in Oconv/Iconv. The "MB" conversion will let you get to binary representation.
by ray.wurlod
Tue Nov 17, 2009 6:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is Basic Transformer recommended to be use in Parallel Job?
Replies: 7
Views: 1951

There must be more information than what you provided. Have you reset the job after it aborts and, if so, is there any additional diagnostic information logged?