DSXchange

You have not specified either a default time format or an explicit time format. Do either or both of these things.

Of course, your users could access the files using an ODBC driver for text files and never know that the results were other than in tables!

Space: the final frontier.

There probably are, but there's not much sense in naming one that is on a different continent from where you are. You can change your profile to include your location.

If I recall correctly, the default limit is 400 columns or 8000 bytes, whichever comes first.

As a short term fix, would it be possible to switch WAS back to using internal registry or operating system registry and perform the export as dsadm (while awaiting the repair to WAS)?

By default there is an upper limit on the number of columns and on the number of bytes per row that can be returned through ODBC.

These values can be altered either globally or for a particular DSN in the uvodbc.config file, using MAXFETCHBUFF and MAXFETCHCOLS parameters.

DataStage/SQL does report N records deleted when a DELETE statement is executed interactively. Does not this report appear in the job log? It is not possible to take a count of the records that "will be" deleted without counting beforehand. DataStage ("UniVerse") tables are relat...

Actually you could do it with one uint8 stage variable whose initial value is not 100.

I think you mean "alternating" rather than "simultaneous". If the Transformer stage is operating in Sequential mode, then all you need are two stage variables, one to remember the previous row and the other to toggle the value. Once you get to parallel operation you have to answe...

Set the Change Mode property to Explicit Keys, All Values

Use a Difference stage with All non-Key Columns are Values or a Compare stage (depending precisely on the form of output you need)

There should be a file called patchlist on the server - from memory it's in the DSEngine directory.

Wherever you like. Store the current date somewhere. Next month read it from there, add one month, store that date and use it as "current". A routine activity is probably easiest.

Not really, because there is some information stored in XMETA that is also required. There is no tool that can create an export file without the services running. Perhaps there should be, but there isn't. It would be possible - but a lot of work - to create one.

The tool to use is not Information Server Manager but, rather, DataStage and QualityStage Designer. Within Designer open the Repository toolbar, select the component or folder in which you are interested, then slide out the details window (the right arrow on the right-hand side of the Repository too...