Getting ready

A user requires the following privileges/rights in order to execute the MultiLoad:

  • SELECT and INSERT (CREATE and DROP or DELETE) access to the target or loading table
  • SELECT, INSERT, UPDATE, and DELETE are required privileges for the user PUBLIC on the log table

Identify the table on which you need to execute the delete statement. In this recipe, we will delete rows from <table name> and <pic>.

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.