Search found 53125 matches

by ray.wurlod
Wed Sep 07, 2011 5:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load all Hashed file into memory
Replies: 26
Views: 9620

I've learned something today. There is a limit.
by ray.wurlod
Wed Sep 07, 2011 5:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: remove hidden control character ^J
Replies: 2
Views: 1673

Ctrl-J is Char(10), the LineFeed character. Given that this is a server job, scroll to the right in the Columns grid in the Sequential File stage and set the "contains line terminators" property to Yes for the field in which it occurs.
by ray.wurlod
Wed Sep 07, 2011 5:15 pm
Forum: General
Topic: migration from 7.5 to 8.5
Replies: 3
Views: 1154

A word of warning - it's not "brief". There are major differences. If you don't have the manuals yet full information can also be had from IBM Information Center
by ray.wurlod
Wed Sep 07, 2011 5:11 pm
Forum: General
Topic: Category Creation
Replies: 3
Views: 1653

Why "in UNIX"? The DataStage Designer client is the correct tool for doing this. Categories do not exist in UNIX - they exist in databases. More than that, they would need to be created both in the local project repository and in the common metadata repository. It's quite likely that these...
by ray.wurlod
Wed Sep 07, 2011 5:09 pm
Forum: General
Topic: Fundamental query in Datastage
Replies: 1
Views: 981

Welcome aboard. The short answer is that NO-ONE has access to the metadata repository or services tier. Everything is done through the services exposed by the WebSphere Application Server. The only time these "upper levels" are accessed is during installation. Information Server is impleme...
by ray.wurlod
Wed Sep 07, 2011 5:04 pm
Forum: General
Topic: No log entries in Director
Replies: 4
Views: 1265

Can you identify the job number? Execute this command in Administrator client command window. SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job name>>'; Use that number (nnn) to see whether there are any entries in the log. SELECT COUNT(*) FROM RT_LOGnnn; This will determine whether the problem is in th...
by ray.wurlod
Wed Sep 07, 2011 5:02 pm
Forum: General
Topic: Users being automatically being revoked access from projects
Replies: 3
Views: 1566

Has anything changed "out there" in Kerberos?
by ray.wurlod
Wed Sep 07, 2011 5:00 pm
Forum: IBM QualityStage
Topic: Match specification - incorrect classification
Replies: 5
Views: 2355

Set your Match Cutoff above 23.68. Clearly that's not enough weight to be a match given your blocking fields and match rules.
by ray.wurlod
Wed Sep 07, 2011 3:00 am
Forum: General
Topic: No log entries in Director
Replies: 4
Views: 1265

Start by dreaming up meaningful subjects for your posts!
:evil:
by ray.wurlod
Wed Sep 07, 2011 2:59 am
Forum: General
Topic: Is there any way to find non-api stage is used?
Replies: 4
Views: 1577

Technically every stage in version 7 server edition is an API stage, because every single stage is written to comply with the DataStage plug-in API. Documentation exists for this API, which means it's perfectly possible to create your own stage types including metadata management capability and view...
by ray.wurlod
Wed Sep 07, 2011 2:55 am
Forum: General
Topic: Is there any way to find non-api stage is used?
Replies: 4
Views: 1577

I have no idea what you mean by that term, which is why I asked you to explain it. You have not done so.

And a guaranteed way to annoy me intensely is to use "u" instead of "you" and "r" instead of "are"!
:evil:
by ray.wurlod
Wed Sep 07, 2011 2:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Locating datasets based on the name
Replies: 2
Views: 1071

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO IN (SELECT DISTINCT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%<<Data Set name.ds>>%') ;
by ray.wurlod
Wed Sep 07, 2011 1:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset reading problem when envrionment changed.
Replies: 3
Views: 1677

What precisely is the "issue" that you seek help to fix?

Are you reading from a Data Set that was written when a different configuration file was in force?
by ray.wurlod
Wed Sep 07, 2011 1:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Disk space issue
Replies: 9
Views: 3222

How do you know it's for logs? What is it that is filling your logs? Do you have a log auto-purge policy in place? Or are you writing jobs that generate zillions of warnings, and not running small samples of data while in development? We're happy to help, but you need to help us to help you, initial...
by ray.wurlod
Wed Sep 07, 2011 1:04 am
Forum: General
Topic: Is there any way to find non-api stage is used?
Replies: 4
Views: 1577

What precisely do you mean by "non-api stage"?