DSXchange

I usually prefer to do this looping in a controlling sequence.

Just out of curiosity:

• (1) What was it about these characters that made them "funny" or "special"?
  
  (2) With what authority are you removing characters from your client's data?

Solar flares?

Rebuild the indexes again making totally sure that you have exclusive access to the project.

Depends. Do other applications create rows in the database table?

Easily fixed. Get yourself a premium membership. Then you will be able to read the entirety of Premium Posters' contributions. It's not expensive, less than 30c (Rs12) per day.

Suddenly? What's changed? (Hint: "nothing" is not the correct answer.)

Describe the hardware of the three systems. Describe the workload on the three systems - not just the DataStage workload, the total workload. Describe the connectivity to databases of the three systems. Describe the workload on those database servers in the three environments.

You need -jobstatus option, not -wait, to have dsjob return the exit status of the job. The -wait option returns only the exit status of dsjob (0 = the job run request was successful).

I would not be using the default values file name - I'd be using the name specific to the particular environment in each case.

The suffixes are indicative of the contents only. Nothing is enforced by them. Provided you have good metadata, you should be able to read them with Sequential File stage (if the structure is simple enough) or Complex Flat File stage. EBCDIC is simply another way of encoding characters, as ASCII is....

Why are you seeking to bypass the fact that you do not have permission? Perhaps there's a reason they have not given you permission. To test this theory, request permission.

Your first step must be to specify: (a) what the function does (its algorithm) (b) what the function's input arguments are (c) what the result of the function should be (only one value is permitted) (d) how you plan to test the function Once you have all that documented, you code the function in C++...

This is in the manual, which I don't have on me at this time. The data are stored in XML in, if I recall correctly, a directory called Performance. It's a sibling of the PXEngine directory.

The model is, essentially: | | Dimension V -------------> SCD Stage ---------------> | Fact | | Dimension V The input has new data, including the business key. The business key is looked up against the Dimension table to return the corresponding surrogate key. This determines whether the dimension r...