Hi:

Brain dead. See below.

However,

SELECT COUNT (*) FROM CASSADD
INTO TotCount;

returns null from IBConsole.

What are the transaction parameters that IBConsole uses?

Can it read uncommitted?


Should be:

SET TERM ## ;
CREATE PROCEDURE GENERATECASSCERTIFICATIONDATA
RETURNS (TotCount INT) <--------------------------
AS
BEGIN
DELETE FROM CASSADD;
INSERT INTO CASSADD (ID, STATUS_MEM, POBOX, NUMBER,
STREET, CITY, STATE, ZIP, DPBC_2, DPBC_CHK)
SELECT M.ID, M.STATUS_MEM, M.POBOX, M.NUMBER, M.STREET,
M.CITY, M.STATE, M.ZIP, M.DPBC_2, M.DPBC_CHK
FROM MEMBERS M
WHERE M.STATUS_REC <> 'ARCHIVE' AND ((M.POBOX IS NOT NULL AND
M.POBOX <> 0) OR
(M.NUMBER IS NOT NULL AND
M.NUMBER <> 0));
INSERT INTO CASSADD (ID, STATUS_MEM, POBOX, NUMBER,
STREET, CITY, STATE, ZIP, DPBC_2, DPBC_CHK)
SELECT I.ID, I.STATUS_MEM, I.POBOX, I.NUMBER, I.STREET,
I.CITY, I.STATE, I.ZIP, I.DPBC_2, I.DPBC_CHK
FROM INFOLIST I
WHERE I.STATUS_REC <> 'ARCHIVE' AND ((I.POBOX IS NOT NULL AND
I.POBOX <> 0) OR
(I.NUMBER IS NOT NULL AND
I.NUMBER <> 0));
INSERT INTO CASSADD (ID, STATUS_MEM, POBOX, NUMBER,
STREET, CITY, STATE, ZIP, DPBC_2, DPBC_CHK)
SELECT A.ID, A.STATUS_MEM, A.POBOX, A.NUMBER, A.STREET,
A.CITY, A.STATE, A.ZIP, A.DPBC_2, A.DPBC_CHK
FROM ADVERS A
WHERE A.STATUS_REC <> 'CANCELLED' AND ((A.POBOX IS NOT NULL AND
A.POBOX <> 0) OR
(A.NUMBER IS NOT NULL AND
A.NUMBER <> 0));
INSERT INTO CASSADD (ID, STATUS_MEM, POBOX, NUMBER,
STREET, CITY, STATE, ZIP, DPBC_2, DPBC_CHK)
SELECT AC.ID, AC.STATUS_MEM, AC.POBOX, AC.NUMBER, AC.STREET,
AC.CITY, AC.STATE, AC.ZIP, AC.DPBC_2, AC.DPBC_CHK
FROM ASSOC_C AC
WHERE AC.STATUS_MEM <> 'CANCELLED' AND ((AC.POBOX IS NOT NULL AND
AC.POBOX <> 0) OR
(AC.NUMBER IS NOT NULL AND
AC.NUMBER <> 0));
UPDATE CASSADD
SET ADDRESS = 'P O BOX ' || CAST(CAST(POBOX AS INTEGER) AS CHAR(7))
WHERE (POBOX IS NOT NULL AND POBOX <> 0);
UPDATE CASSADD
SET ADDRESS = RTRIM(CAST(CAST(NUMBER AS INTEGER) AS CHAR(7))) || ' '
|| STREET
WHERE (NUMBER IS NOT NULL AND NUMBER <> 0);
SELECT COUNT (*) FROM CASSADD <-----------------
INTO TotCount;
END ##
SET TERM ; ##