Hi all While trying to create a summary table, i get the following error message.
db2 " create table tmp as ( select * from claim_lags ) data initially deferred refresh immediate " DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL20058N The fullselect specified for the summary table "DB2.TMP" is not valid. SQLSTATE=428EC Any kind of help is appreciated. Tks! VJ __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
