Search found 53125 matches

by ray.wurlod
Mon Sep 27, 2004 4:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: XML in 6.x
Replies: 10
Views: 2899

It was posted in Inner Circle, as a tool suitable for self-employed consultants to gain leverage when bidding for work.
Correctly it is not visible to non-members of the Inner Circle.
by ray.wurlod
Mon Sep 27, 2004 4:03 pm
Forum:
Topic: i need metastage student guide
Replies: 9
Views: 4737

Responded also by private email. Check out Ascential's contact form as well as their training options page. I can't believe you've only got $500 training budget for such an expensive item of software! Note, too, that since adopting Sarbanes-Oxley, everything at Ascential is being done strictly "by t...
by ray.wurlod
Sun Sep 26, 2004 9:30 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Multi instance invocation id question
Replies: 10
Views: 4459

Ahh, those wonderful undocumented features! It probably wasn't originally meant to work like that, but the mechanism for resolving "parameter" references turns out to be quite flexible.
by ray.wurlod
Sun Sep 26, 2004 3:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD_SendEvent.B:Error Starting run
Replies: 4
Views: 893

Anything with a name beginning with "DSD." is used within DataStage. Recourse to official support is your only option. I can only guess at what the various DSD... routines do, but won't do so in case I mislead you.
by ray.wurlod
Sun Sep 26, 2004 2:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UniVerse user limit has been reached
Replies: 2
Views: 2401

The PC from which you've failed to connect has a DataStage client licence that is authorised for four users installed. (Actually, it's on the first client that connected to that server, rather from the one that failed, from which the licence count is set.) When it connects, it finds that four client...
by ray.wurlod
Sun Sep 26, 2004 2:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Executing Parallel Jobs
Replies: 3
Views: 1433

Quite simple, but not the answer you're seeking: the Orchestrate engine (which underlies Parallel Extender) has not yet (as of version 7.5) been ported to the Windows environment. That's the "why". It truly is not - as the error message told you - supported on your operating system platform. We unde...
by ray.wurlod
Sat Sep 25, 2004 4:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to use HFC
Replies: 5
Views: 2134

ANALYZE.FILE can be run from the Administrator client command window, or from the TCL prompt in your project account (directory). It exists in two forms. ANALYZE.FILE filename shows the existing tuning parameter settings of a dynamic hashed file. ANALYZE.FILE filename STATS shows more information, i...
by ray.wurlod
Sat Sep 25, 2004 4:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: handling of String to Integer conversion
Replies: 4
Views: 4188

If you're in a position to use BASIC functions, these are the ones you want. Oconv(TheString, "MCN") keeps only the numeric characters. Oconv(TheString, "MC/N") keeps only the non-numeric characters. Oconv(TheString, "MCA") keeps only the alphabetic characters. Oconv(TheString, "MC/A") keeps only th...
by ray.wurlod
Fri Sep 24, 2004 6:07 pm
Forum: Site/Forum
Topic: RSS feed message date/time
Replies: 3
Views: 2694

That date looks suspiciously like "just before 01/01/1970", which is the base date for so many things. I'd suspect the problem is in the feed. :cry:
Is anyone else getting this date? Does anyone else even look at the date?!!
by ray.wurlod
Fri Sep 24, 2004 6:03 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to connect to a Unidata 6 account
Replies: 1
Views: 728

Welcome aboard! :D That telnet connections are also refused suggests that the problem is somewhere in UniData configuration rather than in DataStage. Is the unirpcd daemon running on the UniData server? Is it listening on the correct port number (31438)? Is UniData running on UNIX or Windows? It is ...
by ray.wurlod
Fri Sep 24, 2004 5:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to use HFC
Replies: 5
Views: 2134

Although it's not conventionally implemented (lack of time) there IS a Help menu in the HFC. It provides some advice. Basically, you feed the HFC the expected number of rows and the average size of a row. You select a hashing algorithm from a drop down list and, optionally, a separation (group size)...
by ray.wurlod
Fri Sep 24, 2004 5:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Metadata Mismatch error
Replies: 1
Views: 781

It's a warning that what you've nominated as the column precision for column Company_Nbr in your job (3) does not match that in the actual table (10). Change the precision in your job so that it matches what's in the actual table (and which should also appear in the imported table definition in your...
by ray.wurlod
Fri Sep 24, 2004 5:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle Import Error
Replies: 3
Views: 981

Welcome aboard! :D The message has come from the ODBC driver manager (the final piece in the list of square-bracketed components at the start of the error text). This suggests that there may be a problem with the actual ODBC driver that you're using. Might be worth investigating re-installing that d...
by ray.wurlod
Fri Sep 24, 2004 5:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Initial Loading and subsequent loads in one job
Replies: 3
Views: 1106

You're already following best practice by having two jobs. Why would you want to change? It can be done. It relies on the fact that a passive stage type can not open its outputs until all its inputs are closed. The design is below, but I'd still strongly counsel you to maintain two separate jobs; if...
by ray.wurlod
Fri Sep 24, 2004 5:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage windows NT server for 5.x or 7.x
Replies: 4
Views: 1318

Note also that, with effect from 7.5, DataStage is no longer certified for Windows NT 4.0.