Search found 53125 matches

by ray.wurlod
Mon Nov 24, 2008 2:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UserDefined Function output is empty when called from DS job
Replies: 9
Views: 6621

Tell us what's happening in and around line 90 in RT_BP759/JOB.1316733923.DT.1493956403.TRANS1
by ray.wurlod
Mon Nov 24, 2008 2:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem in connecting DB2 server
Replies: 6
Views: 3442

The client is irrelevant here. It is DataStage server that needs to be able to connect to DB2 and therefore it is on the DataStage server that the bind needs to be done.
by ray.wurlod
Mon Nov 24, 2008 2:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: odbc error while fetching data
Replies: 8
Views: 5115

Or just use a double-quoted name in the Table field.
by ray.wurlod
Mon Nov 24, 2008 2:36 pm
Forum:
Topic: Data lineage request within job
Replies: 5
Views: 1858

You're saying that you want a running job to be able to retrieve its own lineage information? Or is one job to retrieve the lineage information of another job? Either way there's nothing obvious that springs to mind until and unless they publish an API in to the metadata layer. Some of this exists i...
by ray.wurlod
Sun Nov 23, 2008 1:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Processing on SMP & MPP architectures
Replies: 3
Views: 1458

Exactly the same except:
    (a) the fastnames are different in an MPP configuration file

    (b) the mechanisms used for inter-process communication are different between SMP and MPP
by ray.wurlod
Sun Nov 23, 2008 1:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: odbc error while fetching data
Replies: 8
Views: 5115

Table names containing space characters have to be quoted. Is yours?
by ray.wurlod
Sat Nov 22, 2008 1:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence Aborted
Replies: 6
Views: 2379

No, you can also get this if one of the databases to which you're connected is in a "not ready" state, or takes too long to execute your "query from hell".
by ray.wurlod
Sat Nov 22, 2008 1:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence Aborted
Replies: 6
Views: 2379

No, you can also get this if one of the databases to which you're connected is in a "not ready" state.
by ray.wurlod
Fri Nov 21, 2008 6:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Importing null tmsp from a var-length delimited file
Replies: 5
Views: 1879

Seems to be. In any case, "" is not valid as a timestamp. The Sequential File stage requires in-band nulls (that is, a substitute value that is valid for the data type).
by ray.wurlod
Fri Nov 21, 2008 5:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Importing null tmsp from a var-length delimited file
Replies: 5
Views: 1879

If you have no control over the structure, specify the data type as VarChar and convert the type within your job (if necessary). Only VarChar can legitimately have a Null Field Value of "" in a parallel job.
by ray.wurlod
Fri Nov 21, 2008 2:24 pm
Forum:
Topic: Information Analyzer and Business Glossary in Version 8
Replies: 29
Views: 15442

All of the Information Server products share the same metadata repository and the same set of metadata delivery services.
by ray.wurlod
Fri Nov 21, 2008 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot Delete Job From Repository in DS 8
Replies: 12
Views: 10197

Try running DS.CHECKER command when you have exclusive access to the project.

Nagaraj's suggestion will probably not work at version 8 because it only addresses the local repository and not the common repository.
by ray.wurlod
Fri Nov 21, 2008 10:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sharing disk and scratchdisk between multiple projects
Replies: 2
Views: 1288

The obvious one, that you probably don't have enough disk space even for one project, springs immediately to mind. Regularly make sure that files are being cleaned up from scratch disk (particularly if jobs abort).
by ray.wurlod
Fri Nov 21, 2008 10:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unmatched records Capturing
Replies: 9
Views: 1712

Only the Merge stage consumes rows as they are selected from its Update input(s). You could devise a mechanism to discover what remains in the Data Set supplying the Update input.
by ray.wurlod
Fri Nov 21, 2008 10:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup warnings in TPT
Replies: 5
Views: 2483

There's no "=" in a KEEP specification.
If you're renaming the column, you don't name the column in KEEP or DROP.