Search found 53125 matches

by ray.wurlod
Tue Nov 08, 2005 2:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter stage and dynamic file creation
Replies: 4
Views: 1748

I don't believe it can be done using dynamically generated file names without creating some code. I would be happy to be corrected. What's the basis of the Filter stage? You can't have a dynamic number of output links! What's your strategy for separating the countries? About the only strategy with a...
by ray.wurlod
Tue Nov 08, 2005 2:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how t get max of timestamp
Replies: 7
Views: 1509

This post seems to duplicate this post
by ray.wurlod
Tue Nov 08, 2005 2:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how t get max of timestamp
Replies: 7
Views: 1509

This post seems to duplicate this post
by ray.wurlod
Tue Nov 08, 2005 2:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL not working
Replies: 6
Views: 2058

There is no "max function in a Transformer". If you built your expressions using the Expression Editor you would realize this.

You can form a maximum value in an Aggregator stage, or in SQL from a database table.
by ray.wurlod
Tue Nov 08, 2005 2:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to increase default 2gb for Hashed files.
Replies: 2
Views: 976

Provided that the hashed file is undamaged, you can RESIZE it to use 64-bit pointers without needing to re-create (and therefore re-populate) it.

It's best practice to have a USING clause with a RESIZE when the file is large, so that you can make use of two separate disks.
by ray.wurlod
Tue Nov 08, 2005 2:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Aborted after 50 errors logged.
Replies: 7
Views: 3484

Tools > Options only sets the default value.

When you run the job, open the Limits tab in the Job Run Options dialog (in which you are also prompted for parameter values). It's there that the limit for the current run is set.
by ray.wurlod
Tue Nov 08, 2005 2:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Commandline running-dsjobs
Replies: 2
Views: 960

The dsjob command is actually on the server but I'm guessing that's the same machine in your case. Simply redirect the output of dsjob -logsum into a file and then execute whatever printing command you want. Use the && pipeline operator so that it doesn't try to print anything that does not ...
by ray.wurlod
Tue Nov 08, 2005 2:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Verb UNLOCK is not in your VOC error
Replies: 6
Views: 3550

Prefer the DS.TOOLS menu, or Cleanup Resources in Director, if you're planning to unlock jobs. Do not unlock anything unless you are 100% certain that it's safe to do so. The locks are there for a reason. In general the only locks that it's safe to unlock are those held by defunct processes. And the...
by ray.wurlod
Tue Nov 08, 2005 2:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning in lookup stage
Replies: 6
Views: 2725

The first message stems from a partitioning requirement of the data - there is not enough information in your post to determine why one might exist - such as your job design. Remove the preserve-partitioning flag; set partitioning to Auto unless you have some reason for doing something different. Th...
by ray.wurlod
Tue Nov 08, 2005 1:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: need help to reuse reject datset of lookup
Replies: 4
Views: 2081

Run the rejects link into a Copy stage and make a link from there into the Funnel stage. You should not (can not?) need to name virtual Data Sets; they take a name based on the link name. But wouldn't it be easier just to change the Lookup stage "Lookup Failed" rule to Continue? Then you wouldn't ne...
by ray.wurlod
Tue Nov 08, 2005 1:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORCHESTRATE step execution terminating Error
Replies: 2
Views: 2682

Research UNIX signals, it's well worthwhile knowing about them. Your system administrator may be able to advise. Somehow, somewhere, one of the steps (player processes) in your job received a signal of type SIGINT; its signal handler processes that signal by terminating. There is not enough informat...
by ray.wurlod
Tue Nov 08, 2005 1:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warnings from lookup against Teradata Enterprise Stage
Replies: 8
Views: 5517

Reference to "partition 9" is concerning, if you only have two processing nodes. Is it a partitioned table? If so, have the DBA ensure that there is sufficient work/scratch space for all partitions.
by ray.wurlod
Tue Nov 08, 2005 1:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sending Job report to a file.
Replies: 7
Views: 1830

Try using a folder other than the root folder. Try referring to it with forward slashes, that is, as a UNIX-style pathname.
by ray.wurlod
Tue Nov 08, 2005 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Import table in Ms. Excel file to DB2 table
Replies: 9
Views: 3457

It is absolutely vital that the Excel worksheet is well-formed for ODBC - that is, it has columnar format and column headings. Also, when importing the table definition from the ODBC data source, you need to check the "include system tables" box, because worksheets are presented as system tables, in...
by ray.wurlod
Tue Nov 08, 2005 5:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can a stopped sequence be restartable
Replies: 3
Views: 883

No.

The job sequence must be reset or recompiled. Either of these will remove the checkpoint information from the stopped run.

Therefore there are no options.