your query in the procedure or script's is Emptiness.

example use exeption's:


set no_found = 0;

select * into v_aux from table where xxx = null;

if no_found = 1 then
set no_found = 0;
end if;
.
.
.
.


Atte...
Daniel Manque P.
Analista de Sistemas.

________________________________

De: Fredrick Rustum [mailto:db2udbdba-ezmlmshield-x18881985.[Email address protected]
Enviado el: Mar 28-11-2006 17:04
Para: LazyDBA Discussion
Asunto: invalid after interupted reorg?




How should I interpret the following message? Can db2 lock free pages
for the reorg? How is it freed?

BR
Fredrick R

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x00000000".
PID:13209 TID:16384 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 100 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRIEXT^A
sqlerrd : (1) 0x80040001 (2) 0x00000001 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 02000




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page