DSXchange

It's a standalone laptop, on which client and server are both installed. As noted, the setup worked when first installed and only stopped working when I changed countries (and therefore network address and time zone). The IP address is served by whatever network it's connected to, which may be somet...

You may be hitting the operating system limit on the number of subdirectories in a directory. Think about cleaning up the project - delete unneeded jobs, or move some jobs to a different project.

WHEN do you want the count? It's available while the job is running as the system variable @INROWNUM.

Search DSXchange. You need to be connected to a network that can serve IP addresses or you need to use a loopback adapter. How to do the latter will be revealed in your search.

Use VARCHAR(65532) - UniVerse does not have a LONG VARCHAR data type.

The issue will likely recur next time you run this job on an overloaded server. It is not "solved".

Unicode/NLS setting?

There's no limit of which I'm aware in the PSDB, but there may be a limit in the viewer (client) that you're using.

That's not something that's under my control but, as I understand it, that price was purely an introductory offer and won't be repeated. The current price is still less than 30c per day.

Of course you can, and I said so. But there's nothing out of the box - either you write your own stage (probably a Build stage) or you use stage variables in a Transformer stage (bearing in mind all I've already said about handling tied ranks) to process sorted data. One of the difficulties of not h...

Because you can't do rank until all rows have been processed. That's why it's not an ETL function. ETL is best performed as a stream of data. A second reason is that there is no one standard for the handling of tied ranks. Nonparametric statistics text books devote many pages to alternative strategi...

RANK is a display function. It is not the purpose of an ETL tool to display anything. Therefore the answer is NO.

They are alerts, and they are OK. If you don't want them to be warnings use a message handler.

Code for the Transformer stage is in the RT_SCnnn directory on the server, where nnn is the job number.

Licence expires in July 2009. Good thought, thank you, but that's not it.