Hi,
I made a procedure that builds up a dynamic select.
The procedure works fine with 7.5.xx, but produces an error on version
7.6.00.32.
CREATE DBPROC PROC_STAT_ABGL (IN NUTZERID INT, IN SANR INT, IN SA_KF
CHAR(2),
IN TAG DATE, IN SCHULEN VARCHAR(1000))AS
VAR
SCHUL_SEL1 VARCHAR(1200); SEL_STM VARCHAR(5000);
....
/* Here I set values depending on parameter SCHULEN.
SCHULEN can be a list of numbers (as string) that are keys in table
T_SCHULE or can be an empty string if all keys from T_SCHULE for a
specific SCHULAMT_NR are wished */
IF LENGTH(SCHULEN) > 1 THEN
/* case 1*/
SET SCHUL_SEL1 = SCHULEN
ELSE
/* case 2 */
SET SCHUL_SEL1 = 'SELECT S.SCHUL_ID FROM DBA.T_SCHULE S WHERE
S.SCHULAMT_NR=' || SANR;
/* now the statement is build */
SET SEL_STM =
'INSERT INTO DBA.T_STAT_ABG' ||
'(NUTZER_ID, AB, PERS_NR, NNAME, VORNAME, AU_STD, URL_STD,
EINS_STD,' ||
'ABW_GRUND_SL, ABW_GRUND, SCHUL_ID, SCHUL_NR, SCHULNAME, ORT)
'||
'SELECT ' || CHR(NUTZERID) || ' AS NUTZER_ID,' ||
'''A'' AS AB,' ||
'P.PERS_NR +(10+' || CHR(SANR) || ')*1000000 AS PERS_NR,' ||
'P.NNAME, P.VORNAME, ' ||
'VALUE(A.STUNDEN,0) AS AU_STD,' ||
'VALUE(B.STUNDEN,0) AS URL_STD,' ||
'VALUE(E.STUNDEN,0) AS EINS_STD,' ||
'VALUE(ABWES.ABW_GRUND_SL,-1) AS ABW_GRUND_SL, ABWES.ABW_GRUND,
' ||
'P.SCHUL_ID, P.SCHUL_NR, P.SCHULNAME, P.ORT ' ||
'FROM DBA.VT_PERS_AND_DBV_' || SA_KF || ' P ' ||
*.
'WHERE P.BEGINN <= ' || STICHTAG || ' AND ' || STICHTAG || ' <= P.ENDE
' ||
'AND P.SCHUL_ID IN (' || SCHUL_SEL1 || ')';
TRY
EXECUTE SEL_STM;
CATCH
STOP ($RC, 'SEL1 ' & $ERRMSG );
In case 1 everything works perfect, case 2 produces only on version
7.6.00.32
The error
General error;-9206 POS(1) SEL1 System error: AK Duplicate catalog
information:FF000010021200200
Any help ?
Elke
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
