All Forums Database
Krishan.R 7 posts Joined 01/06
01 Feb 2006
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

06 Feb 2006

Hi Kishaninstead of trying INSERT EXPLAIN INTO QCD AS QUERY_0001 SELECT SVC_ENTY_ID FROM DB_TX.SERVICING_ENTITYPlease 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

You must sign in to leave a comment.