Mr R:> This is some real good information about how to do this correctly.. Have to admit, that I have doing it wrong, or so it looks..
What if on your end... You all actually use something like When I use: C:\RBTI\RBDOS65\RBASE65.EXE -oc:\rbd65\rbase.cfg -r -pdb2connect2(ownername),storedprocname(parameter1, parameter2) Then you all behind the scenes invoke CONNect db2connect2 IDENTIFIED BY ownername SELECT (CALL storedprocname(parameter1, parameter2)) + FROM SYS_TABLES WHERE(SELECT SYS_TABLE_ID FROM + SYS_TABLES WHERE SYS_TABLE_ID = 1) AND LIMIT=1 EXIT I'm still tryin' here... Jim --- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote: > At 07:52 AM 7/25/2002 -0700, Jim Limburg wrote: > > >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. > > > Jim, > > You can use CALL command to achieve your goals. > > Basically, you run a stored procedure using the CALL command, or a > procedure can be run automatically using database Triggers. Procedures > run with triggers must be stored with no parameters. > > A very simple example: > > 01. Create a startup DAT file with the following: > > -- CallSTP.DAT > CONNect dbname IDENTIFIED BY ownername > SELECT (CALL DBCheck()) FROM AnyTable WHERE LIMIT=1 > EXIT > > In the above example, an SQL select statement is used to invoke a > maintenance routine. The use of WHERE LIMIT=1 causes the procedure > to run once and only once. Without this clause the stored procedure > would execute once for every matching row in the table. The AnyTable > can be any table in the database in this case. The only requirement is > that we must use a table in order to have a "healthy" SELECT clause. > > For complete details on CALL, refer to http://www.RSyntax.com > > 02. Use the following parameters to start R:BASE as following: > > RBASE65 -R -C CallSTP.DAT > > You may want to modify above parameters accordingly. > > Have Fun! > > Very Best Regards, > > Razzak. > > > > ================================================ > 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/ __________________________________________________ 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/
