Search found 53125 matches

by ray.wurlod
Sun Jul 11, 2010 3:32 am
Forum: Site/Forum
Topic: Do I pay $99 to Renew my Account?
Replies: 2
Views: 2937

by ray.wurlod
Sun Jul 11, 2010 3:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Remove Duplicates not removing duplicates
Replies: 6
Views: 2332

Keith has it. Your data are not partitioned correctly or not sorted correctly or both.
by ray.wurlod
Sun Jul 11, 2010 3:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating Hash File is efficient or Creating Index?
Replies: 10
Views: 3984

The "A" stands for "attribute". "Attribute mark" is a synonym for "field mark". Therefore storage really is a dynamic array in a DataStage hashed file. The key is separated from the rest of the record by a "segment mark" (Char(255)). On that basis th...
by ray.wurlod
Sat Jul 10, 2010 2:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating Hash File is efficient or Creating Index?
Replies: 10
Views: 3984

Keys and non-key columns are stored adjacent in the DataStage (UniVerse) hashed file structure. Each page consists of a contiguous set of records. The key value is used to determine the physical location of the page on which the record is stored (using a hashing algorithm, from which the name HASHED...
by ray.wurlod
Sat Jul 10, 2010 2:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX Books
Replies: 4
Views: 2054

It's the name of the document that is the manual.
by ray.wurlod
Sat Jul 10, 2010 2:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What privileges are required to run a parallel job?
Replies: 1
Views: 962

It's an environment variable. It should, if it exists, contain the pathname of the parallel engine directory.
by ray.wurlod
Sat Jul 10, 2010 2:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Differences between SybaseOC stage & ODBC-Sybase
Replies: 5
Views: 1298

ODBC uses ODBC protocols, Sybase stages use Sybase OC client software.
by ray.wurlod
Sat Jul 10, 2010 2:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Differences between Datastage Enterprise and Server Edition
Replies: 3
Views: 1261

Why not ask the original authors of the article at that site? Basically the point made is that the two are completely separate products, sharing only a name. The original DataStage (now server edition) was created by VMark Software, while the parallel execution engine was developed by a company call...
by ray.wurlod
Sat Jul 10, 2010 2:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Training
Replies: 7
Views: 2813

No.

You may be able to convince your IBM sales rep/reseller to let you have an evaluation copy, but one of the requirements for that is that there must exist a reasonable likelihood of a sale.
by ray.wurlod
Sat Jul 10, 2010 2:23 am
Forum: General
Topic: SAP Error
Replies: 9
Views: 3104

Have you installed the SAP pack on your production system? This message indicates that the cataloged routine could not be loaded. Since this routine exists in the global catalog ($DSHOME/catdir) that either means that it's not there, or that you don't have permission to read that particular file (*D...
by ray.wurlod
Sat Jul 10, 2010 2:20 am
Forum: General
Topic: Orchestrate operators
Replies: 6
Views: 1905

Orchestrate operators are the small pieces of C++ executable code - the classes, if you will, from which objects are instantiated. For example, when you design a job that has a Sequential File stage that reads a file, the runtime executable will include an import operator whose task is to read the f...
by ray.wurlod
Sat Jul 10, 2010 2:18 am
Forum: General
Topic: Repository database
Replies: 3
Views: 1167

a) It's not a file it's a database. That's why it's called the repository database. b) Yes, it's a database. c) It's a database that is installed in a location you specify when installing IBM InfoSphere Information Server. d) Yes you can query it. Like with any other undocumented database, you need ...
by ray.wurlod
Sat Jul 10, 2010 2:14 am
Forum: General
Topic: why Datastage ?
Replies: 3
Views: 2505

1) Faster than you could do it with pen and paper. 2) Depends which version you're asking about. In version 8 there are four tiers - the common metadata repository for Information Server, the services tier (also known as the "domain"), the DataStage engine tier and the DataStage client tier.
by ray.wurlod
Sat Jul 10, 2010 2:13 am
Forum: General
Topic: Table value to local variable
Replies: 27
Views: 5848

So? Even though that may be a stupid requirement, it does not prevent you providing a lookup mechanism. Use a lookup stage.
by ray.wurlod
Sat Jul 10, 2010 2:11 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: start and stop the WISD jobs
Replies: 7
Views: 4552

I've learned something today. Does the "old way" - having the job check for the existence of a file or of a value in a file - not work any more?