Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
Reality V15.2 Online Documentation (MoTW) Revision 3
Option 8: Verify Table(s) (SQL) (m691504+verify.htm)
SQLM menu option 8 is used to check that all columns and indexes defined in the SQLTABLES entry for a specified table also exist in the SQLCOLUMNS and SQLINDEXES files. The verify procedure is as follows:
Select option 6 from the SQLM main menu. You will be prompted:
Define Tablenames to be Processed.... Enter Tablename :
Enter the names of the SQL tables you wish to
verify. If you enter ?, a list of
tables is displayed, from which you can select. See
Using the SQLM Menu Options.
SQLCOLUMNS and SQLINDEXES entries are then checked and SQLM displays a screen similar to the following:
SQL MAINTENANCE - Verify Table
==============================
Processing Selected Tables....
GUESTS Validates OK
Do you wish to run "SQL VERIFY" on the table data (Y/N) :
Any errors will be displayed on the right-hand side of the screen. For example:
SQL MAINTENANCE - Verify Table
==============================
Processing Selected Tables....
GUESTS
Index KEY3 missing from GUESTS entry
Column ABS exists in WMDATA but is not
referenced in GUESTS
Validate FAILS
Do you wish to run "SQL VERIFY" on the table data (Y/N) :
N to return
to the main menu, or Y to perform
additional verification using the SQL
VERIFY statement.If you enter Y, the following screen is
displayed:
SQL MAINTENANCE - Verify Table
==============================
Verify table data matches column definitions...
1. Verify entire table (can take a long time)
2. Verify table with search conditions.
e.g. SQL VERIFY * FROM EMP WHERE DEPTNO = 12345
Enter selection ( 1,2 / null ) :
Enter 1 to verify
the complete table (verification starts immediately), or 2 to specify
search conditions.
Note: Specifying search conditions can greatly reduce the time taken to verify the table, but some errors may not be reported.
If you enter 2, you will be prompted to enter the
required SQL statement. For example:
Enter SQL VERIFY statement for table GUESTS
SQL VERIFY
Complete the SQL VERIFY statement provided and then press RETURN. For example:
Enter SQL VERIFY statement for table GUESTS
SQL VERIFY* FROM GUESTS WHERE ROOMNO = 123
When verification is complete, you will be asked if
you want to perform further verification on this table. If you enter
Y, you will
be returned to the screen shown in step 4. If you
enter N,
you will see the prompt:
Completed: Enter <CR>:
Press RETURN to display the main menu.