17.05 - Example: Non-Valid Use of PARTITION In VALUES Clause of INSERT Request - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)

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');