Search found 53125 matches

by ray.wurlod
Wed Feb 25, 2009 5:35 pm
Forum: General
Topic: Does DataStage have an internal timestamp format?
Replies: 3
Views: 3092

None.
by ray.wurlod
Wed Feb 25, 2009 3:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Very slow log refresh under director
Replies: 8
Views: 10963

No matter where the log is stored, it's in a database table and its retrieval query includes an ORDER BY clause based on the date sorter field (this is a hidden field in log view, though it's there). Therefore it behoves you always to keep the log as small as possible. That is, have as few entries a...
by ray.wurlod
Wed Feb 25, 2009 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strip Chars at the end and not in middle
Replies: 9
Views: 3241

... or just do the same in an External Filter stage. In an expression or routine, you need to have a rule that specifies how many characters to remove. You did not state such a rule. I hesitate to assume anything, but it would appear that you want the trailing non-numeric characters removed. As requ...
by ray.wurlod
Wed Feb 25, 2009 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project Creation date/time
Replies: 14
Views: 4837

The project name can be had from the system variable @ACCOUNT, because this code will be executed from within the project.
by ray.wurlod
Wed Feb 25, 2009 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can identify invalid duplicates?
Replies: 10
Views: 2596

Not sure what you mean by "invalid". What makes 002 BBB an exception, for example? Why 002 AAA rather than 001 AAA?

Does the Change Key column in the Sort stage suffice for a solution? If this is 0 then you have a duplicate.
by ray.wurlod
Wed Feb 25, 2009 3:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Did anyone installed ver 8.1 in SUSE Linux
Replies: 7
Views: 1837

If you've got 8.1 then you should have a readme document that outlines everything that has been "fixed in the current release".
by ray.wurlod
Wed Feb 25, 2009 3:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting default values in the job parameters
Replies: 5
Views: 1807

Which of the default values does it report? The one currently set in Director (DSJ.PARAMDEFAULT) or the design-time default (DSJ.PARAMDESDEFAULT)?
by ray.wurlod
Wed Feb 25, 2009 3:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning Message: Cannot preserve partitioning
Replies: 8
Views: 9978

Do you understand why? Do you understand what this setting does?

Are you even interested?
by ray.wurlod
Wed Feb 25, 2009 3:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQSeries issue - Could not load module(s)
Replies: 2
Views: 1228

Welcome aboard.

The library about which it's complaining is libimqs23ia_r.a (or libimqs23ia_r.o) - check that this library is installed and in its expected location.

This may or may not be why mqs.so could not be loaded - perform the same checks for it.
by ray.wurlod
Wed Feb 25, 2009 3:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: NZ Load Commit
Replies: 1
Views: 789

Using NZ Load, I don't believe you can also have auto-commit. Basically a load is not really a transactional operation.
by ray.wurlod
Wed Feb 25, 2009 3:28 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dspipe_wait(22354): Reader(22524) process has terminated.
Replies: 3
Views: 1286

Don't think so - do you see a Collector link marker icon on the link going in to the server shared container?
by ray.wurlod
Wed Feb 25, 2009 3:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: BDW q on trans in a bank
Replies: 2
Views: 835

Ask IBM about their Change Detection software, which scrapes this information from the transaction logs.

Please avoid abstruse abbreviations, such as "BDW" and "q", which make it more difficult for those whose first language is not English.
by ray.wurlod
Wed Feb 25, 2009 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup memory
Replies: 1
Views: 861

When's the interview?

The book is Parallel Job Developer's Guide, the chapter is the one on the Lookup stage.
by ray.wurlod
Wed Feb 25, 2009 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Stage and Link Names in a Job
Replies: 3
Views: 2330

You attach to the job, execute DSGetJobInfo() to get a list of the stage names then iterate through this list executing DSGetStageInfo() to get a list of the link names associated with each stage. Then you detach the job. I'm sure there are examples of the required code extant in DSXchange awaiting ...
by ray.wurlod
Wed Feb 25, 2009 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: QualityStage standardize stage error
Replies: 6
Views: 2020

After designing (or importing) the job, did you provision the server with the files it needs?