v. 4.7.2
lic: comercial
If I check the source code of relative long stored procedure (right click -> send to -> editor or properties -> code) the code is truncated. For the small stored procedures are not.
The truncated stored procedure is still executing ok , or if I view the code with IBM data studio or with the free version of TOAD for DB2 (4.6) the code appears correct.
running the:
select * from SYSCAT.PROCEDURES
where procname = ‘SP_MY_PROC’
gives back the right source code.
Example (end of the SP):
how it should be:
…
from sysibm.sysdummy1
)
order by torder
do
SET OPSCHEMA = OPSCHEMA || v1.ta || chr(10);
END FOR;
END;
how it is generated:
…
from sysibm.sysdummy1
)
order by;
SET SCHEMA = ‘WORKFLOW’;
SET SCHEMA = ‘WORKFLOW’;;
The SP has around 3500 characters.