> My question is: is there any way in SapDB to call a external program > (command line) passing some info as command line parameters > from a Trigger? > Something like "xp_cmdshell" in MS SQL Server?
1. There is no statement in the stored procedure language which allows you to spawn an external program 2. I'm not sure that it would work because the indexer would run in a separate transaction and the row is still locked from the original transaction. But you could use the trigger to insert the key of the inserted/changed row into a second table. A second program could then poll for new entries and reindex the changed rows. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
