Re: ????? Where are Stored Procedures kept ??????

Mike You can look at the system catalog tables sysprocedures and sysprocbody and for the permissions, sysprocauth. You cant see it from Table:Info from dbaccess but if you do a select * on them for instance, you will be able to get their contents. For details about the contents, look at the SQL manual - either reference or tutorial, dont remember which. And if all you want is a file containing the source, do a "dbschema -d databasename -f procedurename filename" at the unix prompt. HTH Sujit Mike Dewing <mdewing@crestbrook.com> on 04/07/99 01:48:53 PM Please respond to Mike Dewing <mdewing@crestbrook.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: ????? Where are Stored Procedures kept ?????? I am fairly new to the Informix environment and have what is probably a really stupid question.... I have created a stored procedure SQL command file using an editor like vi (UNIX environment) and have ran it using DBACCESS and had the stored procedure saved within in the Informix SE database. Now, I want to know where the stored procedure is physically located. For example, various tables and indexes have .dat and .idx extensions, do the stored procedures have a special extension and is located in a special directory or are the stored procedures buried someplace in one of the .dat or .idx files... Any assistance is appreciated. Please reply back to mdewing@crestbrook.com -- Mike Dewing Crestbrook Forest Industries