SQL SET  (SQLSET)
		Standard Verb     SQL Access Operation

Executes an SQL query and does not expect any data back. 

You can use it for instance with the SQL query INSERT or UPDATE. 

Format: 

SQL SET sql query SQL QUERY

SQL QUERY is an expression or a noun containing the SQL query that will be sent to the PostgreSQL server.  

Example:

COPY     "INSERT INTO addresses (number, name) VALUES ('6', 'Hotz Paul')" to SQL QUERY

SQL SET sql query SQL QUERY

SQL QUERY contains the expression that will be sent to the server.  It must conform to the SQL commands syntax or it will generate an error that can be seen in the target nouns EXTERNAL ECHO and FILE STATUS.

Discussion:

Target Noun:

EXTERNAL ECHO (XE), FILE STATUS (FST)

Technical:

SQLSET standard # 428, verb # 365, msg # 773

2006-01-09
vb_sql_op.gif, t_p6.jpg
sqlset.htm