DECLARE DATABASE

Syntax

>>---EXEC SQL---DECLARE db_name---DATABASE---END-EXEC---->

Parameters

db_name A name associated with a database. It must be an identifier and not a host variable. It cannot contain quotation marks.

Purpose

The DECLARE DATABASE statement declares the name of a database. You must DECLARE db_name before using a CONNECT ... AT db_name statement.

Note:

You cannot use DECLARE DATABASE with EXECUTE IMMEDIATE or with PREPARE and EXECUTE.