Welcome aboard. :D
Access violation is an attempt to use some memory you don't own. Common causes are trying to force too long a string into to small a buffer (for example "STRAWBERRY ICE CREAM" into a Char(16) field), and some operations with null values.
Is there an error code with the message? If so you might get more information out of the SYS.MESSAGE table. Or out of the Errors and Remedies manual reported to be part of Hawk.
Of course, any of these "dual-mode upserts" have a performance overhead, as each involves up to two operations (replace is delete then insert). It's much better to perform existence checking within the job design then have a stream for "insert only" and a stream for "update only".
DataStage is also object oriented, but it's not quite so obvious in the GUI. Each component you use in a design is instantiated from a class. For example a Transformer stage is an instance of the class of Transformer stages, as represented by a record in the DS_STAGETYPES table. When you "design" Da...
Neither of these approaches will work satisfactorily in the next ("Hawk") release, where a new concept - parameter sets - is introduced to make life much easier with dealing with the same sets of parameters across multiple jobs and across multiple environments (via a concept called "values files" th...
Are you using a lot of these? How many developers? How loaded is your development server? When you drag a stage onto the design canvas the stage type record (class, if you like) in DS_STAGETYPES is locked briefly while the inherited properties are copied into the new instance of the stage. If there ...
Are you running your QualityStage jobs independently or from DataStage. If the latter, why not have it split the source data into two streams for the separate QualityStage jobs? OK it's two copies of the data, but it's in memory rather than two physical files.
It's possibly not been made explicitly clear, but we do have the capacity to make "non premium" responses. I have added a few of these already, when a brief, non-technical response was adequate. All of the premium posters are honest enough not to hide the kind of message New2DS worries about as prem...
I've never seen uninstall instructions. I suspect "they" would take the view that unused stage types don't take up much room. You could try deleting the relevant records from DS_STAGETYPES (make sure you have a backup or export first).
This is going to be a very long, very slow way to learn ED, one command per post at a time. Why not download the UniVerse manuals from IBM website (track down manuals on line for version 9.6) and learn from those?
Isolation level none means that you CAN read uncommitted transactions. That's what I was trying to get at in my earlier post. If the database is being updated while your select is running, and you are not isolating those transactions, then you will get different results at different times. Another t...