/*
** synodbc.hss - SQL templates for UV/ODBC server
**
**              Copyright (c) 1995 by Ardent Software, Inc.
**                            All Rights Reserved
**                THIS IS UNPUBLISHED PROPRIETARY SOURCE CODE
**                           OF Ardent Software, Inc.
**         The copyright notice above does not evidence any actual or
**                    intended publication of source code.
*/

/* WARNING: This file is not meant to be modified by users.  Modifying it
** can cause unpredictable behavior.
*/

        /*SQL statements for the catalog functions of universe*/

/* Row 1 is the version number of Universe */
UniverseVersion,"SELECT F2 FROM VOC 'RELLEVEL'";
/* See page 2-9 */ 
TablesAssocs,
"SELECT TABLE_SCHEMA,TABLE_NAME,BASE_TABLE,NULL,NULL,TABLE_TYPE,NULL  FROM UV_TABLES"
;
TablesAssocsInSchema,
"SELECT TABLE_SCHEMA,TABLE_NAME,BASE_TABLE,NULL,NULL,TABLE_TYPE,NULL  FROM UV_TABLES WHERE TABLE_SCHEMA = ?"
;
TablesNAMVs,
"SELECT TABLE_SCHEMA,NULL,TABLE_NAME,COLUMN_NAME,NULL,NULL,NULL FROM UV_COLUMNS WHERE (IN_ASSOCIATION IS NULL OR IN_ASSOCIATION = '') AND MULTI_VALUE = 'M'"
;
TablesNAMVsInSchema,
"SELECT TABLE_SCHEMA,NULL,TABLE_NAME,COLUMN_NAME,NULL,NULL,NULL FROM UV_COLUMNS WHERE TABLE_SCHEMA = ? AND (IN_ASSOCIATION IS NULL OR IN_ASSOCIATION = '') AND MULTI_VALUE = 'M'"
;
CallHS_FINDIT,
"CALL *HS.FINDIT(?,?,?,?,?,?,?,?)"
;
CallHS_FILEINFO,
"CALL *HS.FILEINFO(?,'SQLTAB',0)"
;
TableSLists,
"SELECT F2 FROM DICT ? WHERE @ID = 'HS.ODBC.LISTS'"
;
SavedLists,
"SELECT @ID FROM &SAVEDLISTS&"
;