Retrieve Formatted Procedure DDL

[Former Member]

How would you retrieve formatted stored procedure source from the SQL Anywhere system tables. I use the following:

SELECT IsNull(source, proc_defn) as 'text' FROM SYSPROCEDURE
 where object_id = Object_Id('%1')

But it cuts of the source for anything that has more than 30,000 characters. syscomments doesn't seem to be much better.

[MCMartin · Accepted solution]

This seems to be a client problem (limitation). I have just done a small test with 11.0.1.2341 and I can't reproduce your observation. Try it with dbisql and set beforehand in the options the truncation length of the displayed value to a big number. (see http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1000/en/html/dbjten10/jt-isql-options...)