OI Question:

Is there a way to "batch compile" a group of Stored Procedures

from an active select list like:

1. Assume that an active select list contains the stored procedures

  desired (Name*Appname)

2. Sysprocs is opened

3. READNEXT @ID THEN

PROG=@ID

• if necessary, read the record??

• statement to compile PROG

  END ELSE

• Display Message for end of job

  END

It is the result of a large change to a series of reports. The change

was made in AREV 3.12 using a select clause on SYSPROCS and a utility

that I wrote which allows for an UPDATE / SET verb that allows

data to be modified. As part of this process, a final row is written

into the source record at the end that contains a Date / Time stamp.

The affected records can be found in OI using an RLIST call.

Any ideas??

Don Miller

C3 Inc.

You can use the Recompile_Proc() subroutine to batch compile procs.

You do not nead to read the record to compile, just pass the primary key of the procname ('*appname' is assumed).

Using your proc as an example:

DECLARE SUBROUTINE RECOMPILE_PROC

READNEXT @ID THEN

 PROG=@ID1, "*"

 RECOMPILE_PROC(PROG)

 IF GET_STATUS(ERRCODE) THEN

• Deal with compile errors

 END

END ELSE

* Display Message for end of job

END

---

Richard

Richard ..

Thanks. I knew there was something like that.

Don Miller

Richard ..

Thanks. I knew there was something like that.

Don Miller

But it seems one cannot compile inserts with Recompile_Proc. I just needed to compile inserts programmatically and had to use Repository( "COMPILE", … ) instead.

- Oystein -

Oystein ..

A valuable tip. Thanks. Hopefully, I don't need to separately compile Insert's .. just in the context of a Stored Procedure .. which works ok.

Thanks ..

Don

View this thread on the forum...