Dear Sir,
I am Pavan from Mindshare Bangalore (India), working as a Data
Analysit and iam using the Sapdb for my analysis, and I have been facing
and error when I run a large sql statement which I am sending u through an
attachment with this mail. I have also changed the size of the result
window which was initally 1024 bytes to 4096 bytes in the setting tab in
the view menu in SQL STUDIO Application but i fail to get the output.
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."
I request you to consider my problem as one of your and give me a
solution as soon as possible.
Thanking You,
Pavan
Mindshare(Bangalore,India)
PS: -
SYSTEM CONFIGURATION
PROCESSOR - PENTIUM 4 (IBM Netvista)
OS - WINDOWS XP Professional/ 512Mb/ 40GB
SAPDB DATAVOLUME - 2 GB
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
