JimL,
Wouldn't the following "ON" syntax accomplish what you want especially
if you "CMD" file contains:
"RUN SELECT USING parmlist SELECT SYS_PROC_SRC FROM SYS_PROCEDURES
WHERE SYS_PROC_NAME = 'procedurename'
+----------------------------- ON CONNECT/PACK --------------------------------+
�
�
� Use the ON CONNECT/PACK command to execute a command file before
or �
� after connecting to or packing a database.
�
�
�
� _ BEFORE indicates the command file should be run before the
CONNECT/PACK. �
� _ CONNECT indicates the command file should be run when connecting
a �
� database.
�
� _ FIRST indicates the command file should be run on the first
connect �
� only.
�
� _ PACK indicates the command file should be run when packing
a database. �
� _ cmdfile specifies the name of the command file to execute.
�
�
�
+------------------------------------------------------------------------------+
+--------------------------------- SYNTAX -------------------------------------+
�
�
�
�
� +---------- CONNECT +
�
� �+ BEFORE � �
�
� ON �+ FIRST + + RUN cmdfile
�
� +------------ PACK -+
�
� + BEFORE +
�
�
�
+------------------------------------------------------------------------------+
--
Jim Bentley
American Celiac Society
[EMAIL PROTECTED] - email
(973) 325-8837 voice
(973) 669-8808 Fax
---- "Ben Petersen" <[EMAIL PROTECTED]> wrote:
> Jim,
>
> What if you called an rmd file that only had one line to call
> your
> procedure?
>
> Ben Petersen
>
>
>
> On 25 Jul 2002, at 7:52, Jim Limburg wrote:
>
> > G-Day all
> >
> > I submitted the following to the RDCC... would this be something
> > that you'all would like to see as well?
> >
> > We have the capability to run a filespec from the Command
> line like:
> > C:\RBTI\RBDOS65\RBASE65.EXE -oc:\rbd65\rbase.cfg -r file2run.rmd
> >
> > What I would like to see, and I have many purposes for this
> is to have another
> > switch like the -o above. Call it -p and it would run a stored
> procedure for
> > the name that follows it.
> > Example: C:\RBTI\RBDOS65\RBASE65.EXE -oc:\rbd65\rbase.cfg
> -r -pstoredprocname
> >
> > I'm not sure if you can get creative enough to let me pass
> parameters or not,
> > but that would a great feature as well. Maybe
> > C:\RBTI\RBDOS65\RBASE65.EXE -oc:\rbd65\rbase.cfg -r -pstoredprocname(par1,par2)
> >
> > I would also like to see another switch -s for what I call
> silent mode... RBase
> > would not come up in a window.. It would just run silent on
> the task bar and
> > run the stored procedure and exit. I don't think - haven't
> tried - that I can
> > use EXIT from a stored procedure to exit RBase.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Health - Feel better, live better
> > http://health.yahoo.com
> > ================================================
> > TO SEE MESSAGE POSTING GUIDELINES:
> > Send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: INTRO rbase-l
> > ================================================
> > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > In the message body, put just two words: UNSUBSCRIBE rbase-l
> > ================================================
> > TO SEARCH ARCHIVES:
> > http://www.mail-archive.com/rbase-l%40sonetmail.com/
> >
>
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
