Search found 53125 matches

by ray.wurlod
Wed Apr 14, 2010 12:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read excel file in Datastage
Replies: 1
Views: 4599

Doesn't the DSXchange Search facility work for you?

This question has been asked, and answered, on more than a few occasions.
by ray.wurlod
Tue Apr 13, 2010 2:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: aggregator stage hangs and job aborts
Replies: 3
Views: 1192

Moderator: please move to Server forum

Server Aggregator stage does have limitations with the amount of unsorted data it can handle. Search for more information.
by ray.wurlod
Tue Apr 13, 2010 2:20 pm
Forum: General
Topic: IIS administration
Replies: 5
Views: 1352

Again, it depends. If you are using internal registy, that statement is correct.

However, you still need to map internal user names onto operating system user names as "DataStage credentials".
by ray.wurlod
Tue Apr 13, 2010 5:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DSconstants usage in Job Sequence
Replies: 1
Views: 1164

Sure, use the expression editor.

For example, you might want a trigger that fires if a job activity (J42) finishes OK or finishes with warning. A suitable Custom trigger expression would be

Code: Select all

J42.$JobStatus = DSJS.RUNOK Or J42.$JobStatus = DSJS.RUNWARN
by ray.wurlod
Tue Apr 13, 2010 5:24 am
Forum: General
Topic: Retrieving data from DS8.1 xmeta tables
Replies: 12
Views: 37225

The XMETA database is not meant to be used in this way. It is accessed via services such as the metadata delivery service and metadata analysis service.
by ray.wurlod
Tue Apr 13, 2010 5:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reg Schema file
Replies: 7
Views: 2121

Depends.

What do you want to DO with the data records once you've read them?
by ray.wurlod
Tue Apr 13, 2010 5:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup file set best place to use it
Replies: 5
Views: 2266

I think you must have misinterpreted what I said. The only place you can use a Lookup File Set is to service the reference input to a Lookup stage. The benefit you get is that the index on the lookup key is pre-built - it does not have to be build "on the fly" by the LUT_CreateOp operator....
by ray.wurlod
Tue Apr 13, 2010 5:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find the Job Type?
Replies: 5
Views: 2808

No.

Nor can you run it from the WebSphere Application Server administration console.

Nor does the query access the unified metadata repository (XMETA) - it accesses the local repository for the project.
by ray.wurlod
Tue Apr 13, 2010 5:15 am
Forum: General
Topic: IIS administration
Replies: 5
Views: 1352

No.

Unless you count iexplore "http://wasservername:9080" as "from the command line".
by ray.wurlod
Tue Apr 13, 2010 2:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning free job.
Replies: 3
Views: 1521

Char(2) columns must have a Null Field Value containing precisely two characters, even if they're space characters. Char(6) columns must have a Null Field Value containing precisely six characters, even if they're space characters.
by ray.wurlod
Tue Apr 13, 2010 2:48 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding logic
Replies: 7
Views: 2608

For a small number of possible levels yes. But it's not what DataStage is intended to do.
by ray.wurlod
Mon Apr 12, 2010 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Help req. with other country characters
Replies: 5
Views: 1531

First question - do you have National Language Support (NLS) enabled?
by ray.wurlod
Mon Apr 12, 2010 4:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xml as binary
Replies: 9
Views: 3136

You could always zip the XML. That would be binary.
:wink:
by ray.wurlod
Mon Apr 12, 2010 3:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob userstatus
Replies: 1
Views: 2338

I don't think so. As far as I'm aware, using the user status area or writing the value to somewhere on disk are the only choices. Of course, you could write your own C programs that manipulate memory in a way that is sharable betwen processes, but that's definitely not an "out of the box" ...
by ray.wurlod
Mon Apr 12, 2010 3:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: xml as binary
Replies: 9
Views: 3136

jagadam wrote:I have a requirement where they(the client) are expecting to send an xml as an attachment to the webservices.
Resist stupid requirements!

XML is a text-based standard.