Search found 53125 matches

by ray.wurlod
Tue Jun 28, 2005 6:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple Lookup
Replies: 4
Views: 1148

Ultimately, no matter how you do it, you're going to need multiple lookups of some kind, because you need to retrieve information from five separate rows into one output row. The two mechanisms you asked us to exclude (multiple lookups and multiple joins with different aliases) are the fundamental w...
by ray.wurlod
Tue Jun 28, 2005 6:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Output file full--File size limitation?
Replies: 5
Views: 1457

Each logical file in a File Set or persistent Data Set can be up to 2GB, so it's not that.
by ray.wurlod
Tue Jun 28, 2005 6:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logical Count
Replies: 10
Views: 2632

Ultimately it is the partitioning algorithm that governs distribution. Round robin will give as even a distribution as it is possible to achieve. However hashing on a particular column value will tend to reflect any biases in the distribution of hashvalues resulting from the distribution of values i...
by ray.wurlod
Tue Jun 28, 2005 5:55 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: FTP Connector, do not concatenate
Replies: 7
Views: 3709

Looks like the only solution is one card per file. What does your support provider advise?
by ray.wurlod
Tue Jun 28, 2005 5:53 pm
Forum: IBM QualityStage
Topic: QS Plugin reinstall?
Replies: 7
Views: 3687

That's because you should never need to connect the QS clients to your production project, so it's moot whether the plug-in components are in this project or not.
by ray.wurlod
Tue Jun 28, 2005 8:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: load order
Replies: 6
Views: 1479

Quite straightforward. Things are loaded in exactly the order that you design.
by ray.wurlod
Tue Jun 28, 2005 8:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Run Job In Unix
Replies: 5
Views: 1129

Code: Select all

nohup dsjob -run project1 job1 & ; nohup dsjob -run project1 job2 &


runs them both as background requests and returns control immediately, but gives you no further control over the jobs
by ray.wurlod
Tue Jun 28, 2005 7:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Like function
Replies: 3
Views: 1414

Match is the best, as Roy suggested. However it uses idiosyncratic syntax, for example for its wildcard. One syntax that will do the job you seek is the expression InLink.Tariff Match "...USSD..." (the three dots represent a wildcard). A variant in which "0X" is the wildcard is InLink.Tari...
by ray.wurlod
Tue Jun 28, 2005 7:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Completed job log should be converted to *.txt and emailed
Replies: 5
Views: 1358

Why not create a server job to create the text file, and a job sequence (or job control routine) to run that job then email the file?
by ray.wurlod
Tue Jun 28, 2005 7:52 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Why Rnd() function generates same number twice?
Replies: 10
Views: 2965

"Nonrepeatable sequence" means exactly that; it is the sequence that is not repeatable; not any one number in the sequence. Indeed, there is a small but finite possibility that every number in the sequence will be the same, but this will not be true the next time a sequence is generated unless you d...
by ray.wurlod
Tue Jun 28, 2005 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Source Report
Replies: 4
Views: 1131

The file name or table name is usually a property of a link, not of a stage, so you would need -llinks rather than -lstages as your driving option. That may, in turn, require you to iterate through the stages.
But even then I'm not sure that the file/table name information is reported.
by ray.wurlod
Tue Jun 28, 2005 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logical Count
Replies: 10
Views: 2632

The job will always distribute the processing across all of your nodes, as specified in the configuration file with which the job runs.
by ray.wurlod
Tue Jun 28, 2005 7:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp conversion
Replies: 23
Views: 5861

Is the default timestamp format different on the other machine? (You can view this using the Administrator client, Parallel tab in the project properties.)
by ray.wurlod
Tue Jun 28, 2005 7:19 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: FTP Connector, do not concatenate
Replies: 7
Views: 3709

Is there some way to get the FTP adapter to issue an MGET command?
by ray.wurlod
Mon Jun 27, 2005 7:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding Stage Name
Replies: 4
Views: 1254

In Designer, open it via Rename then use Ctrl-C to copy the select name or partial name.
To get a list of stage names in a job, use

Code: Select all

DSGetJobInfo(hJob, DSJ.STAGELIST)
or

Code: Select all

dsjob -lstages project job