Procedural Language

For defining virtual procedures, the Data Virtuality Server supports a special procedural language. You can use this language to define the transformation logic for decomposing INSERT, UPDATE, and DELETE commands against views.

One important thing to remember is that using the procedural language requires to place all statements inside a single procedure within a BEGIN-END block, and only single semicolons (';') are valid statement separators within this block. To separate two procedures, use double semicolon (;;).

On the subpages, we describe various statements and commands in more detail and give some examples of how to use them.