DSXchange

George Gregan's 100th test: they'll be wanting to make it a good one for him, especially since he's returning from a shoulder injury. :D

I'll be in that part of the world next week (India, that is, not necessarily the land of 1600 dsapi_slave processes!). Mukund, can you take a look at the output of this command: ps -ef | head -1 ; ps -ef | grep dsapi | grep -v grep to determine whether they've been around for a long time, or are fai...

Tell is what it IS doing, if it's not taking you into UniVerse. I suspect one of two things, either that you have not used cd to get to a project directory, or that you have not executed the dsenv shell script to set environment variables needed to run uv . Once logged in, here's the sequence: DSHOM...

Can you please delete this post from Editor's Corner? It's not necessary to post on every Forum. Wolfgang's answer is 100% correct. However there is an alternative syntax that some people prefer. Fmt(TheString, "R%":Arg1) The "%" character has the special meaning of "use zero as a ...

Actually I probably should have continued to talk about zombie dsapi processes too, but didn't. The most likely causes are disconnections from parent processes, whether network dropouts, aborted jobs being run in debugger, or whatever.

Because dsenv is a shell script, order of execution is unimportant. Put the commands anywhere you want. Bourne shell syntax is preferred (I've forgotten why). ORACLE_HOME=pathname ; export ORACLE_HOME Don't forget that there are no spaces beside the "=" character when setting environment variables. ...

I would have created the hashed file with CREATE TABLE, which builds the dictionary for you. (SO does creating the hashed file from a Hashed File stage!)

My name is of Swiss origin, the family being located mainly in and around Lausanne. Visit Wurlod Architects to see some innovative architecture. As you can see from my profile, I'm part of the Australian branch of the family, begun when three Swiss ancestors were shipwrecked on the southern shore of...

You can probably work out that dsapi stands for "DataStage API". When a DataStage client connects, it does so through the dsrpc mechanism, requesting the dscs service ( unirpc and uvcs for earlier DataStage releases that were built on UniVerse). After verifying that the user's machine is authorised ...

There are two types of Transformer stage in parallel jobs, if you have a sufficiently recent version. One is called the Transformer stage; this one can NOT use BASIC functions such as Iconv() and Oconv(). The other is called the BASIC Transformer stage, which gives you access to the full range of Da...

You can include selection criteria (anything you might use in a WITH phrase) in the UniData stage. This can use job parameters if necessary. For example ORDER.DATE AFTER '#CutoffDate#' Creating an index on any selection fields in the UniData file will assist the selection (but slow updating). Pre-si...

I've done three regressions and unquestioningly each time completely uninstalled the one version before installing the new, then importing from older, compatible, exports. Not unthinkingly, but unquestioningly, because I am aware of the very many things that could go wrong (and with which I won't bo...

Somewhere you need to record that you've processed it. If there's an incrementing key in the source, all you need to record is the maximum key value processed, and select any key larger. If the records in the source are timestamped, you can select on this basis. Store the primary keys when extractin...

Anywhere where there's a two-way test, one path is taken if the expression is true, the other path is taken if the expression is not true. Note that I deliberately said "not true" rather than "false". Where a value is NULL, we can not safely assert that it is true, so it must take the other path. Th...

You need to design a mechanism that doesn't re-select rows that have already been processed, unless changes have occurred to those rows that make them candidates for further processing. The technique is known generically as Changed Data Detection, and there are many ways to accomplish it. Search thi...