Subject RE: [IB-Architect] A few more suggestions
Author David Schnepper
re: Dynamic SQL from within an SP.

I don't think that is asking for a "bit much" -- Oracle supports this. My
head has been churning the last
few weeks about how this could be added within IB.

Along the lines of "defining the problem" -- Louis, can you define some DDL
operations that
you've wanted to do in a SP, but haven't been able to?


-----Original Message-----
From: Louis van Alphen [mailto:lja@...]
Sent: Monday, June 05, 2000 4:24 AM
Subject: [IB-Architect] A few more suggestions

I apologise for using this list to voice my wish list...but

I find that there is a lack in IB to execute DDL statements from within
SPs. This is something that we have needed many times, but had to resort to
performing these operations from a client. MS SQL Server provides these

Something else that we have needed was the ability to have dynamic SQL from
within a SP. I know that this may be asking a bit much. Think of the
ability to have a table of selection criteria (WHERE clauses) and being
able to, in a SP 'FOR SELECT' statement perform a query for each of the
stored selection criteria. I hope this abbreviated example is clear.

Hope this sets some minds churning even faster... ;-)


L.J. van Alphen
Managing Director
Basix Automation

E-mail: lja@...
Tel: (+27) (0)21-683 5490
Fax: (+27) (0)21-683 5435

P.O. Box 171
South Africa




To unsubscribe from this group, send an email to:

[Non-text portions of this message have been removed]