An ‘environment’ is considered to be all the computing resources required to provide a given system. For an Agresso system, an environment consists of:

• A Database Management Server (DBMS) (e.g. Microsoft SQL Server)
• An Agresso database hosted on the DBMS
• An Agresso Business World (ABW) Server installation
• An Agresso …

Environments are considered to exist within ‘tiers.’ The tier to which a given environment belongs defines the function that it is intended to perform. A typical set of tiers is:

• Development - Allows an individual developer or a small team to work on a single development in isolation from other environments …

A ‘release’ is a process by which a change is promoted between tiers (e.g. from Staging to Production or Development to Staging).

A release package consists of a set of instructions to affect a change from a given system state. It might consist of a scripts or executables to …

Anyone working on a given environment is considered to be an ‘actor’ performing a defined ‘role.’ A typical set of roles is:

• Owner – determines the policy and process by which anyone else is assigned any other role
• Architect – defines the hardware and software platforms on which the environment is created …

‘Source Code’ is considered to be machine interpretable instructions to affect a change within the system or to provide the definition of some element within that system.

In the context of a tiered Agresso implementation, the following would all be considered as source code:

• SQL Script to define and create …

In the following scenarios, we assume the existence of a production environment and one staging environment (stg1) on separate hardware.

The purpose of these scenarios is simply to demonstrate how the principles described above might be applied to real situations.

Scenario 1

A new requirement has been defined for additional …

There are several methods in Oracle SQL to update records in one table based on the content of another table.

Here, I give some of those methods and some guidance on where they might be most appropriate.

The Basics

Oracle uses a 'correlated subquery' syntax which looks like this:

UPDATE …

You're probably here because you've received an email from me with an attachment called 'signature.asc' or with lines at the top similar to:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

and a section at the bottom which looks something like:

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
iEYEARECAAYFAkmr2UAACgkQmnCt8c1NQ98pcACdEpZpqJYifkH0NvE6krEjzA9T …