Search found 53125 matches

by ray.wurlod
Fri Apr 02, 2010 2:18 pm
Forum: IBM QualityStage
Topic: How to hande addresses with Puerto Rican token
Replies: 10
Views: 4800

What kind of override did you use?
Classification, Input Text and Input Pattern overrides are applied before the pattern action language; Unhandled Text and Unhandled Pattern are applied afterwards.
by ray.wurlod
Fri Apr 02, 2010 3:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: log entries not creating in DataStage Director client view
Replies: 7
Views: 6783

You can use any registered user ID in the Reporting console. Using isadmin (or whatever your IS Administrator ID is) you have all privileges, but most users can view reports. You may need to configure viewability of DataStage logs.
by ray.wurlod
Fri Apr 02, 2010 1:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: log entries not creating in DataStage Director client view
Replies: 7
Views: 6783

Check the values of the following in the DSParams file in each project. RTLogging ORLogging If I recall correctly (I can't check right now) RTLogging specifies that logging will be to the local repository, ORLogging specifies that logging will be to tables in the unified metadata repository (XMETA)....
by ray.wurlod
Thu Apr 01, 2010 9:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Removing trailing special character when source is DB2 data
Replies: 6
Views: 6103

My guess is that the trailing character is either a UNIX line feed (Char(10)) or the first character of a DOS line terminator (Char(13)). Either way, these should have been cleaned off before being loaded into the DB2 table - this is the correct way to handle this problem. Once you've found out what...
by ray.wurlod
Thu Apr 01, 2010 9:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loop Implementation
Replies: 12
Views: 4191

Yes, as I indicated earlier, a Cartesian product (cross join) in your extraction SQL. Stage variables to keep track of what's happening. And patience to await the result of processing a very large number of rows (every possible combination).
by ray.wurlod
Thu Apr 01, 2010 9:23 pm
Forum: General
Topic: Constraint not functioning
Replies: 4
Views: 1648

Given that this is a server job, your statement that rows are being dropped is incredible - in server Transformer stage any row that is not output on any other output must appear on the reject output. From the link names, I am guessing that both of these are reference links. Are the lookups succeedi...
by ray.wurlod
Thu Apr 01, 2010 9:19 pm
Forum: General
Topic: Is there a way to get a list of Active Sessions in UNIX?
Replies: 2
Views: 1548

Don't think so. What you're reading there is an in-memory table in one of the WebSphere Application Server services.

Chapter 13 of IBM Information Server Administration Guide does not mention any operating system interface.
by ray.wurlod
Thu Apr 01, 2010 4:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loop Implementation
Replies: 12
Views: 4191

There's no looping within the Transformer stage until the next version.
by ray.wurlod
Thu Apr 01, 2010 4:25 pm
Forum: IBM QualityStage
Topic: How to hande addresses with Puerto Rican token
Replies: 10
Views: 4800

Classification overrides for VILLA and CASA would seem most appropriate to me. Change the classification of these two words to ?

If you don't like to do that, try an Input Pattern override to process the ^P+T pattern to street number, street name, street name, street type.
by ray.wurlod
Thu Apr 01, 2010 4:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Business Glossary Uninstall
Replies: 4
Views: 1520

Uninstalling Business Glossary will not impact DataStage at all.

Step-by-step instructions are in one of the manuals, I suspect in the Installation and Upgrade guide for Information Server. (Can't check at the moment - in an internet cafe.)
by ray.wurlod
Thu Apr 01, 2010 4:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Location of actual data in datasets
Replies: 8
Views: 2546

Gurus, I was doing a quick search in the Forum regarding more information about datasets including the above question, Can you please explain (or point to forum locations if this was previously discussed? ) When I go through the documentation " It just says that dataset stores data in a persis...
by ray.wurlod
Thu Apr 01, 2010 4:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Location of actual data in datasets
Replies: 8
Views: 2546

Re: Location of actual data in datasets

In Dataset Management while copying a dataset without giving any explicit path which location the dataset gets created. Also .ds is the descriptor file. Where is the actual location of the records in the dataset. Is it a single path or multiple path in the disk. Regards, Suman Multiple, determined ...
by ray.wurlod
Thu Apr 01, 2010 4:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conditional lookup in Lookup stage
Replies: 5
Views: 2034

No.

Does this happen only on your computer, or for everyone at your site?

If it's just yours, try re-installing the DataStage client.
by ray.wurlod
Thu Apr 01, 2010 4:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Could not map table file "/data/node1/lookuptable"
Replies: 5
Views: 2075

What is /data/node1/lookuptable? Is it the name of the reference source? Is it too large to fit into memory?
by ray.wurlod
Thu Apr 01, 2010 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Left join user defined sql in Oracle EE stage
Replies: 6
Views: 8705

Somewhere in your design ORG_340b_GRANT_CODE column is defined as not nullable.