Dynamic statement to fill temp table in dbproc 2007-06-15 - By Elke Schmidtke
Back
Hi,
in my procedure I want to fill a temporary table with a select statement that
is dynamic build.
But executing the dynamic statement produces the error:
General error;-9111 ABGL1 Unknown table name:TT_STAT_ABGL
Using 7.5.0.19
CREATE DBPROC PROC_STATISTIK_ABGLEICH
(IN SANR INT, IN STICHTAG DATE, IN STATISTIK VARCHAR(255), IN BEARBEITER
VARCHAR(120),
IN NUTZERID INT, IN SCHULEN VARCHAR(800))
AS
VAR
SEL VARCHAR(1000);
...
DROP TABLE TEMP.TT_STAT_ABGL;
TRY
CREATE TABLE TEMP.TT_STAT_ABGL (
PERS_NR INT,
SCHULE INT,
STUNDEN FIXED(5,2));
CATCH
STOP ($RC, 'ABGL0 ' & $ERRMSG);
SET SEL = 'INSERT INTO TEMP.TT_STAT_ABGL (PERS_NR, SCHULE) ' ||
'SELECT PERS_NR, SCHUL_ID FROM T_DBV ' ||
'WHERE BEGINN <= ''' || STICHTAG || ''' AND ''' || STICHTAG || ''' <= ENDE '
||
'AND SCHUL_ID IN (';
IF SCHULEN = '' THEN
SET SEL = SEL || 'SELECT SCHUL_ID FROM DBA.T_SCHULE WHERE SCHULAMT_NR=' ||
SANR || ')'
ELSE
SET SEL = SEL || SCHULEN || ')';
TRY
EXECUTE SEL;
CATCH
STOP ($RC, 'ABGL1 ' & $ERRMSG);
Any help ?
Elke
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
