Search found 53125 matches

by ray.wurlod
Fri Oct 03, 2008 3:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error reading Oracle
Replies: 3
Views: 1082

The point of that test was to isolate the problem to the shared container (or not). Now you need to do some more detective work. Look in the job log to see that actual SQL statement that was sent to Oracle. For example check that the job parameter references were resolved satisfactorily. (If they we...
by ray.wurlod
Fri Oct 03, 2008 3:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error loading "orchoracle":
Replies: 1
Views: 1042

Read the message, do as it says.

As well as PATH, check LIBPATH.
by ray.wurlod
Fri Oct 03, 2008 3:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: unique record count
Replies: 1
Views: 763

While you could use stage variables to detect change and reset/increment a counter, the best solution is to use the Aggregator stage. It is a very efficient stage type in parallel jobs.
by ray.wurlod
Fri Oct 03, 2008 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter the string data
Replies: 7
Views: 1967

What do you mean by "filter"?
by ray.wurlod
Fri Oct 03, 2008 3:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg: NULL values in comma delimited file
Replies: 15
Views: 6465

Don't push. It's offensive.

DSXchange is an all-volunteer site whose members post as and when they can, if they have something to contribute. And they are under no compulsion to do so - unlike your official support provider whom you are paying to answer your questions.
by ray.wurlod
Fri Oct 03, 2008 3:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems while exporting from DS Manager
Replies: 4
Views: 1704

Probably not. For a start you don't know the names of the DLLs. The objects are exposed by the OLE Automation servers represented by the DLLs (sometimes by OCX files). Without a heck of a lot of work you can't know which are in which.
by ray.wurlod
Fri Oct 03, 2008 1:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error reading Oracle
Replies: 3
Views: 1082

For testing purposes does it work (a) in a job without the shared container and (b) in a job with just the shared container and nothing else?
by ray.wurlod
Fri Oct 03, 2008 1:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to execute Data Stage PX job in Windows XP
Replies: 2
Views: 1380

7.5x2 is your only choice unless you want to go to version 8.0.

Your other alternative is to replace the operating system with a supported Linux operating system. Version 7.5.3 parallel jobs can run on Linux.
by ray.wurlod
Fri Oct 03, 2008 1:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Stage - Phanthom Error
Replies: 5
Views: 1496

yuva010 wrote:What can be seen in this file?

The state of your system (in particular the contents of memory) at the point of failure. You need documentation and probably some analysis tools, not to mention knowledge of the memory model used inside DataStage, to make any sense of a core file.
by ray.wurlod
Fri Oct 03, 2008 1:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter the string data
Replies: 7
Views: 1967

Sequential File stage with pipe character ("|") specified as the field separator.
by ray.wurlod
Fri Oct 03, 2008 1:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle_DB: "null_field" length (5) must match fiel
Replies: 1
Views: 1098

This is a perennial problem of users not understanding fixed-width data.

Read the error message carefully and Search DSXchange for the solution.
by ray.wurlod
Fri Oct 03, 2008 1:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: calling of store procedures
Replies: 4
Views: 1749

The immediately prior post to yours does precisely that, as far as I can discern.
by ray.wurlod
Fri Oct 03, 2008 1:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problems while exporting from DS Manager
Replies: 4
Views: 1704

Have you installed ANY other Windows software that might have overwritten the DataStage DLLs?
The object that can not be created is the export progress reporter.
Re-installing the client is the probable solution.
by ray.wurlod
Fri Oct 03, 2008 12:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: UNICODE for CHAR/ VARCHAR2 columns
Replies: 2
Views: 1325

"Unicode" in the Extended property can mean a number of things, but most usually means that it can "talk" to data types NCHAR and NVARCHAR.
by ray.wurlod
Fri Oct 03, 2008 12:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to execute Data Stage PX job in Windows XP
Replies: 2
Views: 1380

Welcome aboard. The only pre-8.0 version of DataStage that supports running of DataStage parallel jobs on Windows platform is 7.5x2 (which is not the same as 7.5.2). I daresay you have not installed this particular version. The solution is to obtain and install version 7.5x2 or version 8.anything.