Recommendation taken, and yes, there's a 'declare cursor' in there.
Karen, thank you. Bruce From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Monday, July 08, 2013 3:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DROP TABLE Confusion I would never turn error message 380 off. That's an "important" error message to me because it means that the drop did not work and needs to be investigated. Error message 2038 simply means the table wasn't there to begin with, so you don't need that error message to show. In my experience, "resource unavailable" usually means there is a "declare cursor" on the table karen -----Original Message----- From: Bruce A. Chitiea <[email protected] <mailto:[email protected]> > To: RBASE-L Mailing List <[email protected] <mailto:[email protected]> > Sent: Mon, Jul 8, 2013 5:10 pm Subject: [RBASE-L] - Re: DROP TABLE Confusion Thank you very much. In a fluid testing session, I established error message '380' in response to this error when dropping the temp table: 'Drop aborted, resource unavailable (380)' The actual error message stack looks like this: SET ERROR MESSAGE 2038 OFF SET ERROR MESSAGE 705 OFF SET ERROR MESSAGE 677 OFF SET ERROR MESSAGE 380 OFF SET ERROR MESSAGE 46 OFF DROP INDEX tt_glTree1 DROP INDEX tt_glTree2 DROP TABLE tt_glTree DROP VIEW tv_glLevel1 DROP VIEW tv_glLevel2 DROP VIEW tv_glLevel3 DROP VIEW tv_glLevel4 DROP CURSOR c1 SET ERROR MESSAGE 46 ON SET ERROR MESSAGE 380 ON SET ERROR MESSAGE 677 ON SET ERROR MESSAGE 705 ON SET ERROR MESSAGE 2038 ON Bruce -----Original Message----- From: [email protected] <mailto:[email protected]> [mailto:[email protected] <mailto:[email protected]?> ] On Behalf Of A. Razzak Memon Sent: Monday, July 08, 2013 2:53 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DROP TABLE Confusion At 05:38 PM 7/8/2013, Bruce A. Chitiea wrote: >At the top of a routine, I drop a TEMP table: > >SET ERROR MESSAGE 380 OFF >DROP TABLE tt_glTree >SET ERROR MESSAGE 380 ON > >Later, when I attempt to create the table: > >CREATE TEMP TABLE tt_glTree + >(blah blah ....) > >... I receive the error message: > >'-ERROR- New table is a duplicate. (2758)' > >... and proceed to successfully create the table. > >I've verified that at the time of table creation, the DROPped table HAS >been dropped. Bruce, Actually, 2038 is the message number for TABLE and 677 for VIEW, when using suppressing the -ERROR- message. -- Example 01 SET ERROR MESSAGE 2038 OFF DROP TABLE tablename SET ERROR MESSAGE 2038 ON -- Example 02 SET ERROR MESSAGE 677 OFF DROP VIEW viewname SET ERROR MESSAGE 677 ON Very Best R:egards, Razzak. www.rbase.com <http://www.rbase.com> www.facebook.com/rbase <http://www.facebook.com/rbase> -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
