[RBASE-L] - Re: Running 7.6 code from a batch?

[Emmitt Dove]

Karen,

 

I'd comment out the SET SORT MAX  near the end.  I presume that all this is
run prior to connecting the database, since several of the commands herein
will have no impact if you connect first.

 

I'd also reduce all of the commands relating to scratch to simply this:

 

SET SCRATCH TMP

 

If STATICDB is ON, then I'd also SET FASTLOCK ON.  These, too, need to be
executed prior to connecting the database.  Both require that all users run
with the same settings.

 

What about MANOPT?  I don't see it in the list.  For certain queries,
especially well-constructed multi-table SELECTs, it can speed things
tremendously.

 

SET FILES 25 might be a detriment.  That's an old DOS days setting.
Depending on what your process is doing, it might be a limitation.  RBG7x is
going to create more $$$ files than DOS.  Try 50 or 60.

 

Emmitt Dove

Manager, DairyPak Business Systems

Evergreen Packaging, Inc.

[EMAIL PROTECTED]

(203) 214-5683 m

(203) 643-8022 o

(203) 643-8086 f

[EMAIL PROTECTED]

 

From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Saturday, December 06, 2008 2:42 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Running 7.6 code from a batch?

 

Sure!   If someone wants to take a look at it, here's the code 


SET AUTOSYNC ON
SET ERROR VAR XERR
SET COLOR WHITE ON BLUE
SET ECHO OFF
OUTPUT SCREEN
RUN MESSON.CMD
SET QUOTES =""""
SET BLANK=" "
SET DELIMIT=","
SET IDQUOTES=`
SET NULL " "
SET MANY="*"
SET VAR XVMANY=(CVAL("MANY"))
SET SINGLE="?"
SET WHILEOPT OFF
SET WALKMENU ON
SET CASE OFF
SET FILES 25
SET LAYOUT ON
SET ROWLOCKS ON
SET LINES 20
SET ZERO ON
SET ANSI OFF
SET FEEDBACK ON
SET LINEEND ="^"
SET WALKMENU ON
SET EQNULL OFF
SET CURRENCY " " PREF 2 B
SET REVERSE ON
SET SEMI=";"
SET ZOOMEDIT OFF
SET SCRATCH ON
SET VAR vSCRATCH TEXT = NULL
SET VAR vSCRATCH = (ENVVAL("TEMP"))
IF vScratch IS NOT NULL THEN
  SET SCRATCH .vSCRATCH
ENDIF

SET TIME FORMAT "HH:MM AP"
SET TIME SEQ "HHMM"

SET DATE MM/DD/YY
SET DATE FORM MM/DD/YY
SET DATE CENTURY 19
SET DATE YEAR 80

SET WAIT 15
SET HEADINGS ON
SET SELMARGIN 1

SET AUTOSKIP OFF

SET TOLERANCE=0.
SET QUALCOLS 2

SET SORT MAX 64
SET CLEAR ON


Karen








Karen,
If you post a copy of the program code perhaps someone on the list can spot
the problem line(s).

Jim Bentley