Search found 42189 matches

by chulett
Tue May 12, 2009 10:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Tags in a single Line
Replies: 3
Views: 1296

What you see is what you get from the 'Formatted output' option. Turn it off. XML does not need formatting of any kind. People do, but no parser does.

If you really think you need that, take your file and 'pretty print' it with an external utility.
by chulett
Tue May 12, 2009 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle error
Replies: 4
Views: 1342

The changes needed are documented and haven't changed from what you needed to do for the 7.5 server.
by chulett
Tue May 12, 2009 4:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: state files in surrogate key generator
Replies: 13
Views: 13884

A little crazy, I know, but this is explained in the Parallel Job Developer's Guide pdf manual. :wink:
by chulett
Tue May 12, 2009 2:50 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle error
Replies: 4
Views: 1342

Sounds like you don't have your new server properly configured for Oracle. Does it have an Oracle client installed on it? Have you made the dsenv changes it needs?
by chulett
Tue May 12, 2009 2:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: state files in surrogate key generator
Replies: 13
Views: 13884

How many nodes is your job running on?
by chulett
Tue May 12, 2009 2:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: state files in surrogate key generator
Replies: 13
Views: 13884

What makes you think the increment isn't 1? What are you seeing?
by chulett
Tue May 12, 2009 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: deleting /tmp/* caused "score file deleted" warnin
Replies: 11
Views: 2850

1) Because you still have jobs running, I assume. If you restore the ones for the jobs that have not completed yet, I would assume the error would not be generated. 2) Temporary stuff, whatever temp data the process needs to accumulate while the job runs, I would imagine. Honestly can't say other th...
by chulett
Tue May 12, 2009 12:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: deleting /tmp/* caused "score file deleted" warnin
Replies: 11
Views: 2850

You deleted ones in use by a the currently running job and it logged the fact that it couldn't find it when it went to remove it. Just... don't do that.
by chulett
Tue May 12, 2009 10:14 am
Forum: Site/Forum
Topic: RSS Feed broken?
Replies: 1
Views: 2570

RSS Feed broken?

Anyone else having problems with RSS on the site? :?
by chulett
Tue May 12, 2009 7:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Selecting a particular row in a sequential file
Replies: 7
Views: 2537

There are all kinds of ways to pick the record(s) you want from a sequential file input stream, including just the Nth record. Gonna go all anal here and reiterate that the answer to the question that was asked - I was just wondering if it was possible to read a specific record from a sequential fil...
by chulett
Tue May 12, 2009 7:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: concatenating the target file with the system date
Replies: 4
Views: 1817

The other typical piece of advice is to write to a static filename and then rename it with the date/timestamp after job. A simple script/batch can do the trick.
by chulett
Tue May 12, 2009 7:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Processing Flat files
Replies: 6
Views: 1878

Then you'll need some sort of 'pre-processing' step to validate filenames and only pass along ones that match your mysterious criteria. How exactly does one validate your filenames? What are the business rules? :?
by chulett
Tue May 12, 2009 7:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Still RUNNING while Director shows it as ABORTED...
Replies: 3
Views: 1557

A job that fails can still spend a great deal of time afterwards writing errors to the log. And the Designer does not show job status, all green links <> job running ok.
by chulett
Tue May 12, 2009 7:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Columnname containing # in transformer derivation
Replies: 1
Views: 1068

You need to read the documentation for the stage. Off the top of my head, you set that environment variable and you then use a different character (or pair of characters?) to represent the # in the job and it translates it/them back under the covers.
by chulett
Tue May 12, 2009 7:38 am
Forum: General
Topic: How to create Users in Datastage Administrator?
Replies: 2
Views: 993

No, you simply create them via your normal underlying operating system's methodology.