redhat man page for close

Query: close

OS: redhat

Section: 7

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

CLOSE(7)							   SQL Commands 							  CLOSE(7)

NAME
CLOSE - close a cursor
SYNOPSIS
CLOSE cursor INPUTS cursor The name of an open cursor to close. OUTPUTS CLOSE CURSOR Message returned if the cursor is successfully closed. WARNING: PerformPortalClose: portal "cursor" not found This warning is given if cursor is not declared or has already been closed.
DESCRIPTION
CLOSE frees the resources associated with an open cursor. After the cursor is closed, no subsequent operations are allowed on it. A cursor should be closed when it is no longer needed. An implicit close is executed for every open cursor when a transaction is terminated by COMMIT or ROLLBACK. NOTES PostgreSQL does not have an explicit OPEN cursor statement; a cursor is considered open when it is declared. Use the DECLARE statement to declare a cursor.
USAGE
Close the cursor liahona: CLOSE liahona;
COMPATIBILITY
SQL92 CLOSE is fully compatible with SQL92. SQL - Language Statements 2002-11-22 CLOSE(7)
Related Man Pages
close(7) - centos
declare(7) - centos
declare(7) - redhat
fetch(7) - redhat
move(7) - redhat
Similar Topics in the Unix Linux Community
ALERT!!! ALERT!!! I messed up the UNIX!!!
Bash menu opens and closes
awk script: need help
Split file by column value, each with header
Script Works But Need It to Exit Upon Closing Program