DSXchange

Yes.

There are already posted answers to this question, as well as some example queries. Try Search to find some/all of them.

DataStage only takes as much as it requires. Some of the parameters in uvconfig determine how much that is. However, there is no way within DataStage to set the maximum amount of memory that DataStage is permitted to allocate. All memory allocated by DataStage is freed. This is an enforced standard ...

Welcome aboard. :D A job sequence is a graphical means for creating a job control routine; having created and compiled a job sequence you can inspect the job control code in the sequence's job properties (on the Job Control tab). A batch (created in Director) is also a way of creating a job control ...

You don't have to declare them anywhere. If you want the information that one contains, then use that somewhere downstream, for example to supply an argument in a Routine activity. What do you need to achieve? The variables are available in any activity that is downstream of the activity on which yo...

RTI (now called SOAP edition) is about publishing DataStage jobs as web services. It is not about calling web services from DataStage. RTI has been in DataStage since at least version 7.0, if not earlier.

You do exactly what is explained in books such as The Data Warehouse Life Cycle and Toolkit by Kimball et al. You first need to make some decisions, primarily what type of SCD you wish to implement. Then you use appropriate stage types, such as Surrogate Key Generator stage, combined with appropriat...

Not a Teradata person, but it seems to me that to change a password you will need an old password and a new password, and "they" may have imposed rules that prevent the same password being re-used.

UtilityHashLookup does not work with pathed hashed files; a VOC entry for the hashed file must exist. If you look at the code for UtilityHashLookup (category Routines\sdk\Utility) you will see that it uses the Open statement to open the hashed file. You will also see that this routine is the source...

Beat me to it!! All you need to do then is delete those few jobs, if any, that are not in the new build. You will be able to generate a list of these from VSS. I continue to recommend a manual process, or hire an expert (who is cognizant of the dangers) to create your script. Your support provider w...

What routine is being called by the Routine activity, and with what argument values?

Check with oerr ORA 1008 what this code is telling you. Learn about locking mechanisms; whether Oracle will permit you to delete the same records you are selecting. Does it seem plausible? Re-think your approach.

I would like to have seen an up-front statement of objectives (headlines?) and a summary at the end of what had been covered. Long pauses between parts - I thought a preview had ended and surfed away at the end of part #1. This may be because my speed is "only" ADSL - maybe I'll test on a dialup li...

Which part of "Table Not Found" is unclear? Is it the Hashed File stage that is generating this message? If so is the hashed file declared as being in an account or in a directory? In either case which one? Do you have a VOC pointer to the hashed file? If it is the ODBC stage that is generating the ...

I very much doubt that it's the Oracle stage that's causing the problem; it's far more likely that it's how you've constructed the SQL query. Are you using generated SQL, user-defined SQL or a stored procedure to extract your rows? Can you post the SQL so we can suggest how it might be improved?

You may have more luck posting on a DB2 user forum.