DSXchange

Of course you can. Re-type the code as if it were your own work, but include an acknowedgment in the routine code that it is based on ideas obtained from here and in particular from Kim Duke (www.duke-consulting.com). That way it's not third-party, and highlights the foolishness of that policy.

When you upgrade to 7.5 the projects are automatically upgraded. Are you doing an -itag installation? In that case alone the above statement is not true, but will not affect your scripts, as the two server installations are separate. Otherwise they are on separate machines, and again the project nam...

Was this when you were compiling the job sequence, or a server job? Part of compiling a job sequence occurs on the client, and error codes in the 81xxx range relate the the DataStage RPC mechanism. Does this error occur reliably, or did it occur only once? If the former, check that you have write pe...

I don't believe "from OLE DB to Seq.file" is pertinent; the problem is populating a hashed file. Therefore your job contains either a Hashed File stage or a UV stage with an input link. How large is your hashed file? (How much free space you have is irrelevant; a hashed file can not exceed 2GB witho...

My logic had assumed 1 for Pass and 0 for Fail. You sum them first (in an Aggregator), then rely on the rule that 0 is False and any non-zero value is True. With your logic you may need one or three Not() functions, depending on what you want to do with the result afterwards. In the syntax error, is...

There is a glitch in the DB2 Enterprise stage when the remote instance is on a different platform (mainframe or AS/400). That's probably the glitch to which your advisors referred. It should be OK to another UNIX machine.

Search is your friend. With over 100 posts you should know that by now.

Invalid user id/password can also be diagnosed if the server licence has expired but the client licence has not. Just one more thing that you might like to check.

Treat them as Boolean values (1 or 0). You can then combine them with summing in an Aggregator stage then pass them through a final Transformer applying Not(Not(InLink.colname)) to each to produce a final value. If you want a literal "Pass" or "Fail" for each column apply an Oconv() function with "S...

As far as I can ascertain, client licensing (total connections) is enforced in a very similar way to how it is done now. Server side licensing I'm not sure about. How about asking on IBM DeveloperWorks, which seems to be gaining some momentum now?

We are aware of what you want to do. We suggested search because, curiously, you are not the first to have this requirement. I'd be happy to do it for your for a fee, but the answer can be had for free with just a small amount of initiative. Indeed, I have just checked, and the function has been pos...

Right click in the Palette background area and choose Customize. This opens a window in which you can customize your palette (for the currently-open job type) to your heart's content.

Version 8.0 licensing is totally different, now confirming to IBM licensing methods. No more auth codes. You get ALL the IBM Information Server components on a single DVD and use a GUI-based (Windows or X-Windows) installer. There is also a command-line installer. The installer reads an XML file tha...

The Administrator client offers the ability to specify a user ID under which scheduled jobs will be run, and to test that user can schedule jobs, when the server platform is Windows.

In the Modify stage (parallel jobs) there are lookup_string_from_int16() and lookup_int16_from_string() functions, plus equivalents for int32 and ustring data types. There is no equivalent in server jobs; most would choose to pre-load a small hashed file or to initialize a stage variable with a sear...