The 5.5 manual says
4. When the FORCE clause is used, all sections associated with the
MODULE or PROCEDURE are revalidated regardless of whether they are
valid or invalid.
VALIDATE FORCE ALL MODULES WITH AUTOCOMMIT;
VALIDATE FORCE ALL PROCEDURES WITH AUTOCOMMIT;
Are you on Allbase G1.15 or above ??
----------
> From: Tony Furnivall <[log in to unmask]>
> To: [log in to unmask]
> Subject: Allbase/SQL quesiton about VALIDATE
> Date: 10 March 1998 15:31
>
> I have situation where HP is suggesting that I run a script
> (SQLINSTL.PUB.SYS) against some Allbase databases. The lst two lines in
this
> script contain the syntax:
>
> validate force all modules with autocommit;
> validate force all procedures with autocommit;
>
> When I try and do a help in ISQL on the vlidate command, it says nothing
> about validate force,
> and when I run the script, it errors out on these statements.
>
> Any Allbase gurus care to take a stab at this? I flummoxed, and need some
> guidance!
>
> Tony