Hi:

SELECT TOTCOUNT FROM GENERATECASSCERTIFICATIONDATA returns null.

EXECUTE PROCEDURE GENERATECASSCERTIFICATIONDATA returns correct
result.

Why wouldn't the SELECT return the result?

> 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 ; ##
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/