what is *** Null statement accepted.

UDA
Teradata Employee

what is *** Null statement accepted.

AS THE TITLE.

I submit an insert statement. and I get the message:
*** Null statement accepted.
*** Total elapsed time was 5 minutes and 8 seconds.

*** Insert completed. 83509 rows added.

so I wonder what is "Null statement accepted. "

I appreciate your response!!!!
1 REPLY
Enthusiast

Re: what is *** Null statement accepted.

You probably have a semi colon before the insert statement with nothing preceeding it.
eg.

SELECT * FROM DB.TBL;
[highlight=#ffff11] ; [/highlight]
INSERT INTO .....

The empty statement terminiated by the semi colon will be parsed by the Optimizer and the result returned will be NULL STATEMENT.

Other alternatives would include you adding a DIAGNOTIC statement preceeding the insert (from memory this also returns a null statement accepted message).
eg.

DIAGNOSTIC HELPSTATS ON FOR SESSION;
Insert into ....