DSXchange

Ask this of Ascential/IBM. In particular ask whether rows are necessarily buffered in the order they are received.

No, they're not necessarily orphan processes, and probably aren't. The "unavailable" simply means that there is no "last command" that was preserved. For example, in DataStage BASIC terminology, the application itself would need to invoke DSExecute() or similar to stack a "last command". This report...

Verify that you are a member of the Administrators group for that machine (i.e. not from the domain).

Beware that the uvodbc.config file requires a space either side of the "=" character, while these are forbidden in the .odbc.ini file. Ah, consistency!

In the comparison for field1, is the constant on the right hand side two characters long (that is, compliant with PIC X(2))? That is, are you comparing field1 against a string containing two space characters. Clutching at straws a little here. Can you also try surrounding the second expression with ...

Welcome aboard, arn73. :D What you are seeking to do is called a "horizontal pivot", so the suggestion made by logic won't help. The good news is that what you're trying to do is exactly what the Pivot stage does. Read about it in the Pivot.pdf manual (this is in the Docs folder where your DataStage...

The answer is no. This is because all objects of the same type are stored in a single database (Repository) table; CATEGORY is an attribute (indexed for speedy retrieval). There is no scope in the repository database for row-level security. I presume you mean RT rather than RL. Yes, these numbers re...

Welcome aboard! :D Are field1 and field2 columns from an upstream stage, stage variables, or what? What is the data type of field1? How does it get its value assigned? Are you confident that field2 is being calculated correctly? Have you checked - perhaps by dumping a copy of the input stream into a...

What you're seeking to do is called a "vertical pivot". When you check out the manual for the Pivot stage, you will find that it does not do vertical pivots. But, without reading the manual, you would not have discovered this. Search the forum for "vertical pivot". There are at least three technique...

Only the ODBC and UV stage types support multiple row returns from lookups in server jobs.

That is, of course, what dslictool should give. You could also try analyze.shm -x (also known as smat -x), in which there's a "login count". Within the dssh environment (in the UV account) you can issue CONFIG BRIEF to determine how many licences you have. In this environment you also have the ANALY...

If you have NLS installed, there is a menu-driven system on the server for editing NLS maps and locales. It is invoked with the command NLS.ADMIN. However, edits are performed with the UniVerse line editor, with which you are probably not familiar. The NLS manual describes this utility, as well as t...

Only the schema name is restricted to 18 characters (and to what those characters can be). Key values in tables (and therefore job names, routine names, etc.) are restricted to the value set by the MAXKEYLENGTH parameter in the uvconfig file - by default in recent versions this is 768 characters, bu...

That's why I prefer the term DataStage Engine - it's only a server to its own clients.

But who am I to gainsay the technical expertise of the marketing types?

I believe that there is no such scheduler. Imports remain purely manual; while MetaStage supports moderated updates (for example you can email anyone interested after the administrator accepts an update), there's no mechanism of which I'm aware to automate the actual import process itself. It would ...