Check Tables

-- |>===========================================================================================================<|
-- |                                                                                                             |
-- |     ((>>---   SQL to execute a check of all tables in the Terminal ID Manager operational data   ---<<))    |
-- |                                                                                                             |
-- |        Lines beginning with "--" are comments; all others must be valid SQL for Terminal ID Manager.        |
-- |                                                                                                             |
-- |>===========================================================================================================<|

-- |>===========================================================================================================<|
-- |                                                                                                             |
-- |  Do not modify or comment these statements - they obtain a connection to                                    |
-- |  the Terminal ID Manager Derby database, called DerbyIDM.                                                   |
-- |                                                                                                             |
-- |- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -|
SET SCHEMA IDM;

--  For a successful result, the utility will print out the following messages.
--  1
--  ----
--  1
--  1 row selected
--
--  If you obtain a different result, refer to the  
--     Derby Server and Administration Guide, Version 10.5.


--  SELECT tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(
--  'IDM', tablename)
--  FROM sys.sysschemas s, sys.systables t
--  WHERE s.schemaname = 'IDM' AND s.schemaid = t.schemaid;
--  TABLENAME
--                              |2
--  ----------------------------------------------------------------------------------------------------
--  
--  ASSOCIATIONSET
--                              |1
--  ID
--                              |1
--  IDM_VERSION
--                              |1
--  POOL
--                              |1
--
--  4 rows selected



SELECT tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE(
'IDM', tablename)
FROM sys.sysschemas s, sys.systables t
WHERE s.schemaname = 'IDM' AND s.schemaid = t.schemaid;

-- |>===========================================================================================================<|
-- |  Always the final statement - do not Modify or comment.  This terminates the 'ij' command processor         |
-- |- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -|
EXIT;