Re: Stored procedure from stored procedure

I brilliantly, ingeniously and redundantly re-invented the wheel by creating a storedprocedure which returns a string containing either the foreign key columns or the primary key columns of a table. However, it needs to call another stored procedure which will return the colname based on index part. If this latter SP isn't available, I want the PK/FK SP to be able to create it. Be happy to play open kimono and show you if you'd like. Using IDS 7.31-UC4 on Solaris 2.7/Intel (don't ask). Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<Y6ucb.2672$NX3.1594@newsread3.news.pas.earthlink.net>... > John Carlson wrote: > > > On 24 Sep 2003 11:47:09 -0700, red_valsen@yahoo.com (Red Valsen) > > wrote: > > > > > >>Is it possible to create a stored procedure from a stored procedure? > >>When I attempt this inanity, it doesn't blow up until syntax error at > >>the first "end procedure" statement of the SP I'm trying to create > >>within the outer SP. Can this be done? > >> > >>Using IDS 7.31-UC4 on Solaris 2.7/Intel (don't ask). > > > > > > Write it out to flatfile and execute the create from command line > > using dbaccess??? > > As John said, somewhat obliquely, there isn't a way to do it directly. > Why do you think you want to do it?