Example: Non-Valid Use of PARTITION In VALUES Clause of INSERT Request - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

Example: Non-Valid Use of PARTITION In VALUES Clause of INSERT Request

This example is not valid because PARTITION cannot be referenced in the VALUES clause of an INSERT request.

     INSERT INTO Orders VALUES (PARTITION, 10, 'A', 599.99, 
       DATE '2001-02-07','HIGH', 'Jack', 3,'Invalid insert');