Search found 53125 matches

by ray.wurlod
Fri Jun 15, 2007 2:48 pm
Forum:
Topic: metadata repository
Replies: 3
Views: 1819

My earlier answer was incomplete, as it related to DataStage rather than to MetaStage. Tom's answer reminded me that, again up to but not including version 8.0, MetaStage has a separate repository ("directory"), in a database of your choice from among a limited number of options. The MetaStage direc...
by ray.wurlod
Fri Jun 15, 2007 2:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compile a Job
Replies: 3
Views: 1168

Parallle jobs generate osh script which can be viewed in the job properties window, Generated OSH tab. If the job contains a Transformer or Build stage there may also be C++ generated; this can not be viewed on the client; it is stored on the server in a subdirectory called RT_SCnnnn where nnnn is t...
by ray.wurlod
Fri Jun 15, 2007 2:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: if then else problem
Replies: 7
Views: 1814

Is this in a routine or in a derivation expression? Your answer to that will affect what is the correct answer to your question.

Please delete duplicate post.
by ray.wurlod
Fri Jun 15, 2007 2:23 am
Forum: General
Topic: Video tutorials
Replies: 10
Views: 3415

When it's ready. No date estimated, as you'd only hold them to it. Once the recording is finished, there's still a whole lot of editing to be done and then it has to be integrated with a web site.

Let's say not before July 31, and maybe after that.
by ray.wurlod
Thu Jun 14, 2007 11:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: C++ Compiler
Replies: 5
Views: 2222

My guess is that Vincent has installed on a supported platform, not XP.
by ray.wurlod
Thu Jun 14, 2007 11:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: I am not able to compile my job ......pls urgent
Replies: 13
Views: 5594

Where they are is irrelevant - they are hashed files in your Repository.

Use list_readu command (or LIST.READU command or Cleanup Resources in Director) to see the locks. Use the DS.TOOLS menu or the UNLOCK command to free the locks held by defunct process(es).
by ray.wurlod
Thu Jun 14, 2007 11:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reporting Discarded records in a flat file
Replies: 11
Views: 3184

Experiment with the other rules as well, particularly Replace, or Replace and Warn.
by ray.wurlod
Thu Jun 14, 2007 11:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 64bit hased file bad performance
Replies: 22
Views: 4848

Good thinking that man! (Obviously I can't brain today - I must have the dumb.) If, for whatever reason, you still need to single-stream the data that are using the lookup, another technique called a Distributed File (a logical "umbrella" over the sixteen hashed files) will allow you to spread the l...
by ray.wurlod
Thu Jun 14, 2007 11:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Event detail Warning
Replies: 13
Views: 3943

But only slightly.
8)
by ray.wurlod
Thu Jun 14, 2007 11:17 pm
Forum: General
Topic: unable to open desinger
Replies: 6
Views: 1680

Windows NT, Windows XP, Windows 2000, Windows 2003, Vista ?

Are you the only one at your site with this issue?

Can you open Designer from one of the other clients' Tools menu?

Are there any error events in the Windows Event Viewer?
by ray.wurlod
Thu Jun 14, 2007 11:14 pm
Forum: General
Topic: datastage tutorial
Replies: 3
Views: 1527

There's a famous acronym in this industry: TANSTAAFL There Ain't No Such Thing As A Free Lunch There is no such site, and no such freebies. The amount of time and effort expended in preparing quality training material mean that anyone who does so expects some return. I know, it's something I do. Dep...
by ray.wurlod
Thu Jun 14, 2007 8:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 64bit hased file bad performance
Replies: 22
Views: 4848

gsym, to make the Quote tags work, uncheck the "Disable BBCode in this post" check box when posting/editing a post.
by ray.wurlod
Thu Jun 14, 2007 8:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Event detail Warning
Replies: 13
Views: 3943

My guess was slightly astray. In fact your foreign key references ORDID on the ORDERS table. Therefore your INSERT statement for the ITEMS table appears to contain an ORDID value that does not exist on the ORDERS table. The only "solution" is not to insert any row into the ITEMS table for which the ...
by ray.wurlod
Thu Jun 14, 2007 8:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: 64bit hased file bad performance
Replies: 22
Views: 4848

He did. It's static - type 18.
:oops:
by ray.wurlod
Thu Jun 14, 2007 7:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: (Server=Dedicated) parameter in TNSNAMES.ORA file
Replies: 4
Views: 4851

The entry in tnsnames.ora instructs the client connection - irrespective of the actual client tool - to make use of the Dedicated features. Presumably its absence instructs the client connection not to make use of the said features.