Re: Can use SQR to "update statistics on database" ?

["Korbel, Gordon E." <GEKORBEL@NORSTAN.COM>]

I have done this successfully in sybase -- just make sure the USERID runnign
the SQR has the needed permissions, and enclose the platfrom-specific syntax
in a begin-sql block!

Thanks,

-Gordon

-----Original Message-----
From: Steve Bergin [mailto:Steve.Bergin@KAISERAL.COM]
Sent: Thursday, April 08, 1999 9:50 PM
To: Multiple recipients of list SQR-USERS
Subject: Can use SQR to "update statistics on database" ?


Database is Centure 6.1.2 PTF-4 running on Windows NT 4.0; workstations are
Windows 95
HRizon is 7.x
SQRW is 3.x

Has anyone put the "update statistics on database" database command in an
SQR so
the user can run it just like they run their other reports?