[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] Re-Indexing a Table in SQR
- Subject: RE: [sqr-users] Re-Indexing a Table in SQR
- From: "George Jansen" <GJANSEN@aflcio.org>
- Date: Thu, 11 May 2006 16:39:09 -0400
- Delivery-date: Thu, 11 May 2006 16:42:16 -0400
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Screen capture follows:
/tmp>more analyze_it.sqr
begin-program
begin-sql
begin
dbms_stats.gather_table_stats('scott', 'emp');;
end;;
end-sql
end-program
/tmp>sqr analyze_it.sqr
Enter Username: scott
Enter Password:
SQR V4.3.2.2
Copyright (C) SQRIBE Technologies, 1994-98. All Worldwide Rights Reserved.
SQR: End of Run.
/tmp>echo $?
0
/tmp>
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users