Precompiled Statements

The Mimer SQL explorer displays a view where all precompiled statements are shown. A precompiled statement is created with the SQL command CREATE STATEMENT. There are different Icons shown for different types of statements:

	Select statements.
	Insert statements.
	Update statements.
	Delete statements.
	Procedure statements.

A select, insert, update, or delete statement may optionally have a set of in parameters. A procedure statement can have both in, out, and/or inout parameters.

When a statement has parameters, the user is automatically prompted for these when the statement is executed.

Statements owned by other users that the current user has EXECUTE access on, are prefixed with the username of the statement owner. The SQL string corresponding to the statement shown in the detailed view is only shown for a user's own statements.