Search found 53125 matches

by ray.wurlod
Tue Feb 17, 2009 1:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Job not opned
Replies: 10
Views: 2853

It sounds like the index on the local repository table DS_STAGETYPES has become out of date (or that the Teradata stage types were not installed in the project, but I'd guess the former). Open your Administrator client command window and, when no-one else is using the project (and you can be absolut...
by ray.wurlod
Tue Feb 17, 2009 1:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Job not opned
Replies: 10
Views: 2853

Potassium permanganate in water.
:lol:
by ray.wurlod
Tue Feb 17, 2009 1:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: could not compile job - compiler issue
Replies: 4
Views: 11485

Install the correct compiler (Visual Studio .Net C++) before installing DataStage server.
by ray.wurlod
Tue Feb 17, 2009 1:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Error
Replies: 6
Views: 2392

We don't do "urgent" or "ASAP". DSXchange is an all-volunteer site whose members post as and when they can, if they have something to contribute. If you need urgent assistance, sign up with your support provider for premium services, and learn just how much "urgent" co...
by ray.wurlod
Tue Feb 17, 2009 1:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Error
Replies: 6
Views: 2392

Because you're breaking one of the rules somewhere, for example trying to shoehorn too many characters into a field, or read a null value into a structure in which you've declared it to be non-nullable. Go back in the code where the Get.Pin%%V0S0P4 macro is defined to see precisely what it's doing. ...
by ray.wurlod
Tue Feb 17, 2009 1:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in Oracle Metadata importing
Replies: 1
Views: 1079

Tell us how you're trying to import it.

Have you tried using the orchdbutil facility (importing the record schema)?
by ray.wurlod
Tue Feb 17, 2009 1:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to open text file
Replies: 6
Views: 2358

Disk full? File permissions? Directory permissions?
Verify parameter value (posted in "job starting" event in job log).
by ray.wurlod
Tue Feb 17, 2009 1:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding Hash File Usage
Replies: 4
Views: 1342

No. It can't. For starters, Hashed File stage is a passive stage whereas Funnel is (technically) an active stage. And the correct terminology is HASHED file, not "hash" file. I guess if you were really clever about generating guaranteed unique keys on all inputs and made sure that the data...
by ray.wurlod
Mon Feb 16, 2009 5:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: equivalent function for oracle "months_between" fu
Replies: 2
Views: 1347

No.

The closest you can get without writing you own is DaysFromDateSince().
by ray.wurlod
Mon Feb 16, 2009 5:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding UVSH Processes
Replies: 1
Views: 1326

Each job sequence, each server job and each Transformer stage in a server job will generate a uvsh process (though directly-connected Transformer stages may share the same uvsh process). Ordinarily when a job aborts they are cleaned up automatically. However, if they are still waiting on some event ...
by ray.wurlod
Mon Feb 16, 2009 2:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to Rebuild repository index using DS.REINDEX ALL
Replies: 5
Views: 6871

You would benefit by reading my entire post.

Premium membership is not expensive, at less than 30c per day. It is one of the ways that DSXchange is funded.
by ray.wurlod
Mon Feb 16, 2009 2:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implicit conversion from source type "decimal[38,10]&qu
Replies: 3
Views: 2776

It's not an error it's an alert. The second person personal pronoun is spelled "you" in English, not "u", and the corresponding present tense of the verb "to be" is spelled "are", not "r". Please strive for a professional standard of written English ...
by ray.wurlod
Mon Feb 16, 2009 2:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Incorrect -dboptions option list; failed on Expected ",
Replies: 4
Views: 7171

What are your connection properties in the Oracle Enterprise stage?
by ray.wurlod
Mon Feb 16, 2009 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join/Lookup Stage output
Replies: 9
Views: 4772

The right input can return NULLs in a left outer join, and therefore must be Nullable.
by ray.wurlod
Mon Feb 16, 2009 2:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot get exlusive access to ex..job may be being monitored
Replies: 9
Views: 5350

Do not, ever, use kill -9 on DataStage processes.

You will only deepen the hole you have already dug.

Use the DS.TOOLS menu or Cleanup Resources in Director.