Search found 53125 matches

by ray.wurlod
Thu Feb 05, 2009 12:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Concatenate 3 files and generate sequence number
Replies: 14
Views: 7004

dr.murthy, your question is not the same as the original, because they are on UNIX and you are on Windows. You really ought to have begun a new thread.
by ray.wurlod
Thu Feb 05, 2009 12:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Variable for output value of server routine
Replies: 8
Views: 5184

Welcome aboard. One of the things we can't deal with is "it doesn't work". You must be more specific. HOW doesn't it work? What were the expected and actual results? When you test the routine, does it generate the expected result? Certainly the $ReturnValue activity variable is the correct...
by ray.wurlod
Thu Feb 05, 2009 12:01 pm
Forum: IBM QualityStage
Topic: how to make a SOA services with deduplication
Replies: 17
Views: 6350

Did you deploy as "always running"? How many instances did you deploy?
by ray.wurlod
Thu Feb 05, 2009 2:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display Jobs in a Category
Replies: 20
Views: 5567

It must be executed while attached to a project directory.
by ray.wurlod
Thu Feb 05, 2009 2:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to run 2 jobs Parallel in JOB SEQUENCER
Replies: 18
Views: 5716

Possibly JobA finishes in less than one second. So they appear to start in the same clock second.
by ray.wurlod
Thu Feb 05, 2009 2:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Are there any new steps involved in installing NLS?
Replies: 1
Views: 923

There are not. You install with, or you install without, NLS.
by ray.wurlod
Thu Feb 05, 2009 1:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Command for listing running jobs
Replies: 2
Views: 1216

director.exe (on the client)
by ray.wurlod
Thu Feb 05, 2009 1:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Display Jobs in a Category
Replies: 20
Views: 5567

Try it.

Bonne chance!
by ray.wurlod
Thu Feb 05, 2009 1:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Ideal sequence of jobs in a sequence
Replies: 6
Views: 1513

Since you have version 8, you can use the resource estimator to indicate the likely resources to be consumed by each job. Then assemble them so that any dependencies are addressed, and the total demand for resources remains under 100% of available resources.
by ray.wurlod
Thu Feb 05, 2009 1:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TD Connector Error
Replies: 1
Views: 2099

Search DSXchange for "The specified module could not be found." It's been addressed on a number of prior occasions.
by ray.wurlod
Thu Feb 05, 2009 1:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Concatenate 3 files and generate sequence number
Replies: 14
Views: 7004

No, just use the cat command as the Filter command of the Sequential File stage, which will then read the output of the cat command. Handle the column headings either in the Filter command (perhaps using head +2) or within your job. Use @OUTROWNUM to generate the line numbers.
by ray.wurlod
Thu Feb 05, 2009 1:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parsing address informaiton
Replies: 5
Views: 1622

Re: parsing address informaiton

Quality Stage US area rule set will do the same but you will need to customize the Rule Set because the data does not have a separator between tokens (words), so you will need to adjust the rule a little bit to parse this kind of record for you Not true. You can define the data to be fixed width an...
by ray.wurlod
Wed Feb 04, 2009 9:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping Construct in datastage
Replies: 3
Views: 1739

Add a new column to your input. This column has the same value, say "X", in every row. A Column Generator stage would be ideal. Create a Data Set containing pairs of values, "X" and a value, for example X,100; X,125; X,150 and so on up to the largest possible value. Permit duplic...
by ray.wurlod
Wed Feb 04, 2009 6:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: parsing address informaiton
Replies: 5
Views: 1622

QualityStage has this functionality straight out of the box, and can handle misspelled entries as well. You would simply insert a standardization stage that uses the USAREA rule set into your job. If you don't have QualityStage licensed then the MatchField() function may stand you in good stead in s...
by ray.wurlod
Wed Feb 04, 2009 6:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Syntax for trimPadding() function of APT_String?
Replies: 1
Views: 1097

A good place to look would be the chapter on the modify operator in the Orchestrate Operators manual. This shows how the arguments to the Modify stage's string_trim() function work.