- Hi, everyone. -

- I'm trying to write an stored procedure which reads usernames from
an RDB table and creates these users in the OS VMS. -

- How can I call OS/DCL commands from an stored procedure passing
parameters (usernames) in the command-line? -

- Thanks in advance. -

- Kind regards. -

Javier Coego.

Javier Coego wrote:
Hi Javier,

I have setup an INSERT trigger with a LIB$SPAWN "External Function"
which performs a DCL SUBMIT command with parameters taken from fields of
the inserted record. You should be able to adapt an example which I
posted to the Rdb Logserver Mailing List a few years ago, assuming you
have the necessary DB privileges.

http://www.jcc.com/search/rdblistser...1/3bd9bd3d.htm


Cheers!

Keith Cayemberg