Search found 53125 matches

by ray.wurlod
Thu Aug 28, 2008 2:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to do export/import
Replies: 2
Views: 1300

Indeed ANY software that uses OLE Automation ?
by ray.wurlod
Thu Aug 28, 2008 1:47 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating an Error table
Replies: 4
Views: 1437

And does "the business" want to look at one table or lots of tables?

My personal preference is for a single table - but my personal preference ought not to influence your business users' requirements.
by ray.wurlod
Thu Aug 28, 2008 1:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: PX_Debug variable - Help required
Replies: 8
Views: 3583

Has $PX_DEBUG been brought into any jobs as a job parameter?
by ray.wurlod
Thu Aug 28, 2008 12:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Found this on wikipedia
Replies: 14
Views: 4301

No-one ever claimed that they used strong encryption. I'm sure that if you search DSXchange you will find others who have posted how easy it is to break. I think it was only a mechanism by Ascential marketing to be able to check the "we have encrypted parameters" check box.
by ray.wurlod
Thu Aug 28, 2008 12:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing v8 - what are the gotchas?
Replies: 1
Views: 919

1. Topology. You now have to install Information Server, WebSphere Application Server (WAS) and DataStage server. All on one machine, separate machines, or some combination thereof. If different, you may need to remember to start the ASB (Application Server Backbone) agent. Choices made here will af...
by ray.wurlod
Thu Aug 28, 2008 12:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple v8 installs on the same server?
Replies: 15
Views: 4043

The technical reason is that they've hard coded the shared memory keys. This means that, if you want 7.5 to be co-resident, it is the 7.5 version that has to have non-default shared memory keys. Given that they also sell hardware, I don't think there's currently any business case to convince IBM to ...
by ray.wurlod
Thu Aug 28, 2008 12:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Max Date in Aggregator.
Replies: 5
Views: 3225

Transformer before and after is what I had in mind. I'm sure there is a function you can use in a Modify stage, which will be something like string_from_timestamp[formatstring](inputcolumn) (That was from memory.) There is also a timestamp_from_string() function. Find details in the Orchestr...
by ray.wurlod
Thu Aug 28, 2008 12:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Information Analyzer Performance Issue
Replies: 6
Views: 2752

Try, just for the test, doing the same profiling against the CSV file. Please consider how much work is involved in a column analysis; the number of metrics and statistics that are gathered. These are vital, because the remainder of the analyses depend upon these results. And what kind of hardware a...
by ray.wurlod
Thu Aug 28, 2008 12:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: where to find for userstatus function
Replies: 2
Views: 1796

There's no such function "out of the box". It must have been a user-written function. What is it you need to accomplish? If it's to set the user status, use DSSetUserStatus. However this is a subroutine so, to use it from inside a job, you need to call it from a function. Examples have been posted.
by ray.wurlod
Thu Aug 28, 2008 12:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Version Control repository
Replies: 11
Views: 4970

Guess I'll leave this topic open 1 more night until I catch up to AMT (AustralianMeanTime). Time isn't mean in Australia. Like the spaces and the sky, it's very generous. And, out in the desert, it really is "big sky country". Also there are three, sometimes four, sometimes even five time zones in ...
by ray.wurlod
Wed Aug 27, 2008 9:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple v8 installs on the same server?
Replies: 15
Views: 4043

Definitely NO.

Every version 8 DataStage server must be on a separate machine.

It's a rule, made by a company that sells hardware. Hmm...
by ray.wurlod
Wed Aug 27, 2008 9:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Version 8 Admin Class
Replies: 4
Views: 1312

It's HUGELY different, which might explain the delay in getting an Admin class out the door. The "within DataStage" stuff hasn't changed all that much, but user authentication is now managed through Information Server as is session (and therefore lock) management, plus there's the central metadata r...
by ray.wurlod
Wed Aug 27, 2008 9:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About Big5 HKSCS
Replies: 1
Views: 887

There are BIG5 maps. Go to your Administrator client, Projects page. Click the NLS button then choose the Server Maps tab. This will show you which maps are currently loaded. Choose the All option to see all available maps. If BIG5 is not a loaded map, choose it and click Install. You will need to r...
by ray.wurlod
Wed Aug 27, 2008 8:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to find Age --using DOB and currDate
Replies: 2
Views: 1062

365.25 would be closer, and 365.249 even closer (for really long-lived folks). But better would be to compare the dates properly - subtract the years and then add one if the birthdate has already gone past in the current year. Beware of other cultural conventions. In some Chinese applications, a chi...
by ray.wurlod
Wed Aug 27, 2008 8:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Creating an Error table
Replies: 4
Views: 1437

Whatever is right for your business. Who is going to look at this error table/these error tables? What do THEY need?