Connecting Tech Pros Worldwide Forums | Help | Site Map

Problem in fetching procedure text

Newbie
 
Join Date: Jun 2008
Posts: 18
#1: Oct 12 '09
Hi I am trying fetch the text of procedure from unix propmt using the below command
Expand|Select|Wrap|Line Numbers
  1. db2 "select text from sysibm.sysprocedures where procname='<procedure name>'"
but if the size of procedure is big then this command is not fetching the complete text of the procedure. Even if I redirect the output to a file also the output is same.
Is there any other method to fetch the procedure text.

Reply