Stored procedure from stored procedure

[Red Valsen]

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).

[John Carlson]

On 24 Sep 2003 11:47:09 -0700, [email]red_valsen@yahoo.com[/email] (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???

[Jonathan Leffler]

John Carlson wrote:

> On 24 Sep 2003 11:47:09 -0700, [email]red_valsen@yahoo.com[/email] (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?

--
Jonathan Leffler #include <disclaimer.h>
Email: [email]jleffler@earthlink.net[/email], [email]jleffler@us.ibm.com[/email]
Guardian of DBD::Informix v2003.04 -- [url]http://dbi.perl.org/[/url]

[Red Valsen]

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.earth link.net>...

> John Carlson wrote:
>

> > On 24 Sep 2003 11:47:09 -0700, [email]red_valsen@yahoo.com[/email] (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?