Search found 53125 matches

by ray.wurlod
Thu Jan 20, 2011 3:23 pm
Forum: General
Topic: can't compile, can't open, can't rename nor delete a job
Replies: 2
Views: 1325

Is any error message generated? (If so, what is that message?)
by ray.wurlod
Thu Jan 20, 2011 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to configure the DB2 Plug In in UNIX for server
Replies: 4
Views: 2625

As far as DB2 is concerned, DataStage is just another client application. Therefore DB2 client software must be installed on the DataStage server machine and configured in the usual way (for example setting the DB2INSTANCE environment variable, performing the appropriate bind command (bind19 or bind...
by ray.wurlod
Thu Jan 20, 2011 3:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_uvput() - Write failed for record id
Replies: 15
Views: 14459

This error can also be caused by an illegal key (null, or one containing dynamic array delimiter characters ("mark characters")).
by ray.wurlod
Thu Jan 20, 2011 3:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Iconv(Col,"MC/N")
Replies: 2
Views: 1453

The problem, in short, was between the keyboard and the chair.
:wink:
by ray.wurlod
Thu Jan 20, 2011 3:15 pm
Forum: General
Topic: Change the field from mechanical to Data warehousing
Replies: 3
Views: 1109

So what do you mean by "change"?
by ray.wurlod
Thu Jan 20, 2011 3:14 pm
Forum: General
Topic: Regarding job unlocking
Replies: 2
Views: 1255

1. The user number is found in the LIST.READU report.

2. Script listpid.sh is for listing processes associated with a particular executable and, possibly, killing them. It's a standard shell script; read through it to learn what the options are and what it does.
by ray.wurlod
Thu Jan 20, 2011 4:40 am
Forum: General
Topic: Passing stage variable to a parameter
Replies: 1
Views: 769

It's not possible.
by ray.wurlod
Thu Jan 20, 2011 4:40 am
Forum: General
Topic: Stage Names
Replies: 5
Views: 1909

They're in DS_JOBOBJECTS and have a DSRID value of the form VnSm where n is the view number and m is the stage number (the order in which stages were added to the job) but not VnSmPk (these objects are "pins", or points at which links join to stages. So you need to constrain your query on ...
by ray.wurlod
Thu Jan 20, 2011 4:37 am
Forum: General
Topic: Regarding Oracle as Metadata Repository V8.5 Infosphere
Replies: 1
Views: 956

Get into the habit of researching in the Information Center particularly for version 8.5. The manual IBM InfoSphere Information Server Planning, Installation, and Configuration Guide will also prove useful in answering questions about requirements and planning for installation. You will need to have...
by ray.wurlod
Thu Jan 20, 2011 4:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: input dataset '0' is NULL. Record dropped
Replies: 4
Views: 10351

Although documented as returning NULL, a failed lookup can return "" instead when. This is particularly true if the output column is declared not nullable (and has a string data type - numeric data types can be set to 0). :idea: Tip: make use of the fact that the Len() function returns 0 w...
by ray.wurlod
Thu Jan 20, 2011 4:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SetNull() Function in stage variable
Replies: 3
Views: 3263

The limitation to have only non-null stage variables is one of a number eased in version 8.5.
by ray.wurlod
Thu Jan 20, 2011 4:25 am
Forum: General
Topic: Import Table Definition from Command Line
Replies: 4
Views: 1953

I suspect that the question relates to importing a table definition from a database, rather than from an exported, already-imported table definition. I'm not sure that - despite what the graphical importer claims about orchdbutil being used under the covers - that there's any public documentation ab...
by ray.wurlod
Wed Jan 19, 2011 11:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to configure SCD in DS 8.5?
Replies: 1
Views: 2161

Is the Parallel Job Developer's Guide (beginning on page 395) of any help?
by ray.wurlod
Wed Jan 19, 2011 11:16 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Optimize hashed file
Replies: 9
Views: 3790

You learning some patience would also help. We post as and when we can, and answers that require a deal of thought take even longer as we've learned not to rush in to things.

Right now I am busy earning a living. Ordinarily I only spend one hour per day on DSXchange (starting about 5am).
by ray.wurlod
Wed Jan 19, 2011 3:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Output links from Change Capture
Replies: 2
Views: 1549

How many times do you propose to ask this question?