4. Data Manipulation SQL

This chapter describes the functions, rules, and specification formats of data manipulation SQL statements.

Organization of this chapter

• 4.1 COPY (output search results to a file)

• 4.2 DELETE (delete rows)

• 4.3 INSERT (insert rows)

• 4.4 PURGE CHUNK (delete all rows in a chunk)

• 4.5 SELECT (retrieve rows)

• 4.6 TRUNCATE TABLE (delete all rows in a base table)

• 4.7 UPDATE (update rows)

To Page Top