Menu

#7 Selectable stored procedures

open
nobody
None
5
2005-09-12
2005-09-12
No

The parser doesn't support IB/Fb's selectable stored
procedures, which may be regarded as parameterized tables.
Examples of typical constructions that use SSPs:

select ...
from ATABLE A
join ASTOREDPROC('PARAM1', 42) B on 1=1

select A.COLUMN1,
select ARESULT from ASTOREDPROC(A.COLUMN2)
from ATABLE A
where ...

select ...
from ATABLE A
join ASTOREDPROC('PARAM1', 42) B on A.COLUMN1=B.ARESULT

Would that be a complex task to add support for these?

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.