If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > CLOB.reset error

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-28-03, 10:43
Dagon Dagon is offline
Registered User
 
Join Date: Feb 2003
Posts: 7
CLOB.reset error

Has anyone seen the following error:

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "Found zero CLOB.reset".)
SQLSTATE=58004

I get it when trying to build a summary table with a fairly complex definition. The SQL for the summary table works when put into a view.
Reply With Quote
  #2 (permalink)  
Old 11-14-03, 14:00
mlpge mlpge is offline
Registered User
 
Join Date: Nov 2003
Posts: 1
I don't have the answer to this problem since the creation of the AST is running well but, I do experience the same error message when I issue the command:

REFRESH TABLE my_ast_table

I also would like to know what going on!!!

Thanks.

M. Lepage
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On