At 08:02 AM 2/12/2008, Lawrence Lustig wrote:
Uh oh! Have multi-block procedure files been deprecated?
No. Have you tested and verified it yourself?
BTW, this syntax is in the latest help file that I checked:
RUN SELECT USING parmlist SELECT VARCHAR clause
I think the connecting dots and lines need a little adjustment
for the syntax.
In reference to running stored command from a "table" using
the RUN SELECT command, try the following example:
Table Name: StoredCommands
No. Column Name Attributes
--- ------------------ ------------------------------------------
1 CommandID Type : INTEGER
Comment: Command ID
2 CommandFile Type : LONG VARCHAR
Comment: Actual Command File
Typical Syntax:
RUN SELECT CommandFile FROM StoredCommands WHERE CommandID = nnnn
Have fun!
Very Best R:egards,
Razzak.