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.
select * from SYSCAT.PROCEDURES
where procname = ‘SP_MY_PROC’
gives back the right source code.
Example (end of the SP):
how it should be:
order by torder
SET OPSCHEMA = OPSCHEMA || v1.ta || chr(10);
how it is generated:
SET SCHEMA = ‘WORKFLOW’;
SET SCHEMA = ‘WORKFLOW’;;
The SP has around 3500 characters.