DSXchange

(It was Colonel Mustard in the TCL with the mkdbfile command.)

By specifying precision and scale correctly. In the case of scenario 1, multiplication by a constant is required.

Execute this command to tell DS_STAGETYPES that it points to the correct indexes directory. SET.INDEX DS_STAGETYPES /full/pathname/of/I_DS_STAGETYPES Then execute this command to build the correct values into the index. DS.REINDEX DS_STAGETYPES These should be done with no other connected DataStage ...

EVAL expressions must be surrounded by double quotes.

No. DataStage is administered project by project.

Aha! The index seems to be the culprit. Try DS.REINDEX DS_STAGETYPES It may also be that the location of the index is incorrect. Does the name indicated in the error message actually exist? Ordinarily the index directory for DS_STAGETYPES would be called I_DS_STAGETYPES and it would not have OVER.30...

The tool will decrypt encrypted parameters; the decryption algorithm is not available to the likes of us (though can be determined if you are keen enough). Backups are your insurance against corruption. Within the secure UniVerse table, passwords would be stored in clear. You seem to have the techni...

Sorted data; twelve stage variables to record the twelve most recent values and a thirteenth to calculate the average of the twelve. Don't forget to handle nulls, either by excluding them or treating them as 0.

You could store them in a UniVerse table to which only one user, who is not able to login, has any privileges. Then you can create a server routine to select from that table, and use the AUTHORIZATION statement within the routine so that, whenever it runs, it impersonates that particular user. For m...

OK, it seems to be intact. The load discrepancy message can be disregarded for now. Can you insert a key into the table? Please post the result. If it was successful, please delete the record.

How are you getting a UniVerse stage into a parallel job? Presumably it is in a server shared container. The UniVerse stage uses ODBC protocols, even though it does not use an ODBC driver. The default maximum number of columns is 400 and the default maximum row size is 8192. These defaults can be ov...

With so many posts you should already know that we simply do not attempt to diagnose errors thrown by APT_CombinedOperatorController. Post back when you have more specific error information.

No.

However, if the Data Connection has an associated Parameter Set, and if the Parameter Set has values files, then you can access the parameter values from a values file. Note, however, that encrypted parameters will be encrypted within the values files, and probably not suitable for your purpose.

Sorted data; thirteen stage variables.

If you have Enterprise Edition, the parallel Aggregator stage supports moving sum and moving average calculations.

Why not ask U (one of our posters) directly? The second person personal pronoun in English is spelled "you", not "u". Please strive to maintain a professional standard of written English on DSXchange; to do so aids those whose first language is not English. There is no need for S...