Toad World® Forums

SP code incomplete.

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.

Hi,

I haven’t been able to recreate this issue with a 3,500 or 35,000 character SP.

Will you please send me the DDL to recreate the procedure. You can send it to adam.ririe@quest.com.

Also, tell me which version of DB2 you’re using.

Thanks,
Adam

Hi Adam,

you’ve got mail :stuck_out_tongue:

Hi Radu,

This issue is fixed on the latest beta, and will be available on the 5.0 release.

Thanks for your help,
Adam

Thank you, I’ll wait for the v5 release