The error "Response exceeds 64K bytes and alternate parcel header was not requested" might occur when you drop a Teradata table


When you attempt to drop a Teradata table using the SQL procedure, you might receive the following error:

ERROR: Teradata prepare: Response exceeds 64K bytes and alternate parcel header was not requested. SQL statement was: SELECT * FROM database."tableName".
WARNING: Table libref.tableName has not been dropped.
 

This problem occurs because there is no fully qualified system name in the HOSTS file or names database and, consequently, the Teradata server is not able to process Alternate Parcel Header (APH) packets.

To work around this problem, specify the unqualified short Teradata server NAME as an entry in the HOSTS file or the names database, as is normally done in production systems. (For example, use SERVER=foo rather than SERVER=foo.my.unx.com.)