INSERT EXPLAIN not working

Database
Enthusiast

INSERT EXPLAIN not working

Hi,

Can some explain to me why the following statement fails. I have a QCD database and I am trying to populate the QCD using the following query:

########################
INSERT EXPLAIN INTO QCD AS QUERY_0001 SELECT SVC_ENTY_ID FROM DB_TX.SERVICING_ENTITY;
########################

I am getting the following error

#######################
*** Failure 5542 Only Select, Insert, Delete or Update statements can be ca
ptured.
Statement# 1, Info =28
*** Total elapsed time was 1 second.
########################

Thanks,

Kishnan.R
1 REPLY
Enthusiast

Re: INSERT EXPLAIN not working

Hi Kishan

instead of trying

INSERT EXPLAIN INTO QCD AS QUERY_0001 SELECT SVC_ENTY_ID FROM DB_TX.SERVICING_ENTITY

Please try this

EXPLAIN INSERT INTO QCD AS QUERY_0001 SELECT SVC_ENTY_ID FROM DB_TX.SERVICING_ENTITY.

Explain key word should preceed the sql statement,

Regards