[EMAIL PROTECTED] wrote: > This SQL COMMANDS such as follows > > "select concat(a.home_no,a.sample_id), a.station_cd, b.channel_cd, > b.program_name, a.start_day, a.end_day, a.start_time "VIEW_START", > a.end_time "VIEW_END", a.market_cd, a.weight, a.c_s, a.sec, > a.sex, a.age, > a.view_totdur, b.start_time "PROG_START", b.end_time "PROG_END", > timediff(b.stimestamp,b.etimestamp) "PROG_TOTDUR" from merged2 a, > program b, station c where (a.research_date = b.research_date and > a.station_cd = c.station_cd and c.channel_cd = b.channel_cd and > ((b.end_time >= a.start_time and b.end_time <= a.end_time) or > (a.start_time > >= b.start_time and a.start_time <= b.end_time) or > (b.start_time >= > a.start_time and b.end_time <= a.end_time)))" > > The Error is as follows > > "Database error occured : > > Native Error : -904 > Test : [SAPAG][SQLOD32.DLL][SAPDB]General error;-904 > POS(1) Space for result tables exhausted."
This error means that your databas is filled up with temporary pages. Those temporary pages are created for result sets and for intermediate results of join selects like in this case. First of all you should actualize the optimizer statistics with the update statistics command (http://www.sapdb.org/htmhelp/3b/86f067458411d3a98200a0c9449261/frameset.htm) or add some indexes on the join columns to improve the join strategy and create less temporary pages. If this won't solve your problem you should increase the database size to handle bigger temporary results. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
