EXECUTE

Description

Executes a prepared statement. Because a prepared statement exists only in the lifetime of the session, the prepared statement must be created earlier in the current session by using the PREPARE statement.

Syntax

EXECUTE name;

Parameters

name

Specifies the name of the prepared statement to be executed.

Examples

-- Create a schema.
m_db=# CREATE SCHEMA tpcds;

-- Create the reason table.
m_db=# CREATE TABLE tpcds.reason ( 
    CD_DEMO_SK          INTEGER          NOT NULL,
    CD_GENDER           character(16)            ,
    CD_MARITAL_STATUS   character(100)
);

-- Insert data.
m_db=# INSERT INTO tpcds.reason VALUES(51, 'AAAAAAAADDAAAAAA', 'reason 51');

-- Create the reason_t1 table.
m_db=# CREATE TABLE tpcds.reason_t1 LIKE tpcds.reason;

-- Create a prepared statement for an INSERT statement and execute the prepared statement.
m_db=# PREPARE insert_reason FROM 'INSERT INTO tpcds.reason_t1 VALUES(52,''AAAAAAAADDAAAAAA'',''reason 52'')';

m_db=# EXECUTE insert_reason;

-- Delete the reason and reason_t1 tables.
m_db=# DROP TABLE tpcds.reason;
m_db=# DROP TABLE tpcds.reason_t1;

-- Delete the schema.
m_db=# DROP SCHEMA tpcds;