Teradata SQL Statements - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

Teradata SQL statements define and manipulate the data stored in the database.

Teradata MultiLoad supports a subset of Teradata SQL statements. As a result, other utilities do not have to be invoked to perform routine database maintenance functions before executing Teradata MultiLoad utility tasks. For example, the supported Teradata SQL statements can be used to:
  • Create the table to load
  • Establish a database as an explicit table name qualifier
  • Add checkpoint specifications to a journal table

The following table lists the Teradata SQL statements Teradata MultiLoad supports. To use any other Teradata SQL statements, exit Teradata MultiLoad and enter them from another application, such as Basic Teradata Query (BTEQ).

Teradata SQL Statements Supported in Teradata MultiLoad
Teradata SQL Statement Function
ALTER TABLE Changes the column configuration or options of an existing table
CHECKPOINT Adds a checkpoint entry to a journal table
COLLECT STATISTICS Collects statistical data for one or more columns of a table
COMMENT Stores or retrieves a comment string associated with a database object
CREATE DATABASE Creates a new database
CREATE MACRO Creates a new macro
CREATE TABLE Creates a new table
CREATE VIEW Creates a new view
DATABASE Specifies a new default database for the current session
DELETE Removes rows from a table
DELETE DATABASE Removes all tables, views, and macros from a database
DROP DATABASE Drops the definition for an empty database from the Data Dictionary
DROP TABLE Removes a table
GIVE Transfers ownership of a database to another user
GRANT Grants privileges to a database object
INSERT Inserts new rows to a table
MODIFY DATABASE Changes the options of an existing database
RELEASE MLOAD Removes the access locks from the target tables in the database.

This inhibits any attempts to restart the Teradata MultiLoad job when a Teradata MultiLoad task has been suspended or aborted.

A RELEASE MLOAD statement must be entered from another application such as BTEQ. A RELEASE MLOAD statement cannot be entered from Teradata MultiLoad.
RENAME Changes the name of an existing table, view, or macro
REPLACE MACRO

REPLACE VIEW

Redefines an existing macro or view
REVOKE Rescinds privileges to a database object
SET QUERY_BAND Identifies type and source of query to determine prioritization of queries
Teradata MultiLoad parses and prevents the sending of the “SET QUERY_BAND ... FOR TRANSACTION;” statement to the database.
SET SESSION COLLATION Overrides the collation specification for the current session
SET SESSION OVERRIDE REPLICATION ON/OFF Turns replication services on or off
UPDATE Changes the column values of an existing row in a table
Specifying any DML statements (insert/delete/update) before specifying the BEGIN MLOAD command will use the non-fast path and processing will be done in the Transient Journal (very slow and may exceed the maximum perm space). Specifying the DML statement after the BEGIN MLOAD command will use the fast path and processing will be done in the transaction phase (very fast).

For syntax and a complete description of each Teradata SQL statement, see Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184 and Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.