Search found 53125 matches

by ray.wurlod
Mon Feb 12, 2007 11:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get "Could not open table file" when create lookup
Replies: 2
Views: 1814

You've given a Data Set control file name that refers to a segment file that either never existed on your system or has been deleted. Or maybe you are using the Data Set with different partitioning than that in use when the Data Set was created. What is the name of the control file (the name ending ...
by ray.wurlod
Mon Feb 12, 2007 11:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deployment and Version Control
Replies: 4
Views: 1001

The Dependencies tab in job properties and Routine properties serves as a check list for other objects that need to be promoted. Version Control can detect that objects are recorded there, and cause the other objects to be promoted (after prompting for permission to do so). Otherwise it's the respon...
by ray.wurlod
Mon Feb 12, 2007 11:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Status code 127 for the job
Replies: 4
Views: 1453

Was that the job status code really, or the exit status of a dsjob command?
by ray.wurlod
Mon Feb 12, 2007 11:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job End Time
Replies: 13
Views: 2552

DSguru2B wrote:
chulett wrote:Or farm it from the log.

'farm it' huh, cool terminology :wink:

I think he meant "harvest".
Nothing to do with Neil Young. :wink:
by ray.wurlod
Mon Feb 12, 2007 11:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I-descriptor was not compiled
Replies: 15
Views: 6258

Forward slashes in some places, backslashes in others. Ya hafta stay alert!
by ray.wurlod
Mon Feb 12, 2007 8:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Deployment and Version Control
Replies: 4
Views: 1001

1. No. 2. Not relevant, since "executable" is not at the O/S level. A dependent object is called by finding it in the Repository. 3. Yes, but it can prompt first. Uncheck "Overwrite Without Query". 4. No. See answer to Q2. 5. It's up to you and how you have encapsulated the dependencies. If they're...
by ray.wurlod
Mon Feb 12, 2007 8:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to know whether the job is restarted
Replies: 1
Views: 836

Not unless you create a Routine to interrogate the job's log.
by ray.wurlod
Mon Feb 12, 2007 8:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I use Change capture for this ?
Replies: 8
Views: 1879

Change Capture will not yield old and new. Its output is a "change" Data Set that can be reapplied to the "before" Data Set to reproduce the "after" Data Set using a Change Apply stage.
by ray.wurlod
Mon Feb 12, 2007 8:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare stage, output columns
Replies: 16
Views: 16569

diff is simply the name of the output column. There are five properties in the stage that let you specify the output value when the result of the comparison between (Key columns in) the first input and those in the second input is one of: second equals first (option 'Equals' Value default 0) first ...
by ray.wurlod
Mon Feb 12, 2007 8:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DS 7.5.1.A Server Install
Replies: 10
Views: 3324

Here's a trick that used to work. Click Cancel.

A dialog opens asking whether you really want to cancel from the installation. You answer No, the process gets a kick in the pants and keeps going.

No guarantees, haven't used this one since a long time back, but you never know.
by ray.wurlod
Mon Feb 12, 2007 8:31 pm
Forum: IBM QualityStage
Topic: Standardizing Business Address and Shipping Address
Replies: 4
Views: 2260

It's sound advice. I wasn't aware you wanted to compare the addresses (since this wasn't in the problem as originally specified), which is why I was advocating two STAN stages/jobs each processing a different set of columns; I thought that all you wanted was standardization.
by ray.wurlod
Mon Feb 12, 2007 5:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: automate cleaning &PH&
Replies: 1
Views: 1042

It depends on how you start your jobs. For example, if you always start jobs using dsjob, then you could rename dsjob for the duration of maintenance. You can delete the contents of &PH& using a wildcard with the DEL command. Beware, however, that "&" is a meaningful character to the she...
by ray.wurlod
Mon Feb 12, 2007 5:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Tuning Fact Table Process
Replies: 14
Views: 5261

It would have been nice to encase your LIST.INDEX between Code tags - in fact, why not edit your previous post to make it so?

BUILD.INDEX is required if there are data in a hashed file on which an index is created. BUILD.INDEX is not required if the hashed file is empty when the index is created.
by ray.wurlod
Mon Feb 12, 2007 5:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of the week - Oconv code
Replies: 12
Views: 2846

On what day does a week start? How is week number 1 in a year defined (all weeks must have seven days, so "starts on Jan 1" is not a good rule). Solution #1 Look at the Transform WEEK.TAG and the WeekTag routine that it calls. These document one business rule (from memory, week begins on a Monday, a...
by ray.wurlod
Mon Feb 12, 2007 5:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Documentation on Quality Stage
Replies: 2
Views: 904

Presumably the other manuals are also in the same folder, but we're probably forbidden access unless we come in through the eService web site, and then there's the problem of how to find this particular folder. There is a search facility.