Teradata Database Message 9581 - 9581 - Analytics Database - Teradata Vantage

Analytics Database Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
15.xx,16.xx,17.xx
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-01-05
dita:mapPath
sfx1628096178347.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-1096
lifecycle
latest
Product Category
Teradata Vantageā„¢
Message
Warning: The work table %DBID.%TVMID specified in the MLOAD statement was not created for the MultiLoad job.
Explanation
This warning code, when included in the Success/OKs parcel for an MLOAD statement, tells the Client application that the work table specified in the statement was not created for the current MultiLoad job. There can be multiple MLOAD statements for a job; each is generated for a specific target table. Only the work table specified in the first MLOAD statement will be used to create the NoPI staging table for the job when Extended MultiLoad Protocol is used. This warning code tells the Client application that a work table was not created and therefore the Client application should not attempt to drop it at the end of the load.
Generated By
OPH module.
For Whom
Client Application.
Notes
None
Remedy
Do not drop the work table at the end of the load.