>A while ago I saw a posting regarding creating procedures from
>procedures. Could somebody refresh my memory on this. Was it
>a two step process where a UNIX script invoked one proc that
>created a script, the the second was invoked?
>An example would be appreciated.
I've written procedures which generate trigger scripts as output.
The general approach is
Select "Select " + name + " From " + object_name(id)
From syscolumns where object_name(id) = "mytable"
But the procedure is of course lots more complicated.
my Compuserve account.