Mimer SQL

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta name="GENERATOR" content="Quadralay WebWorks Publisher Professional Edition 7.0.6.1058"> <meta name="TEMPLATEBASE" content="Mimer_SQL_Engine"> <meta name="LASTUPDATED" content="04/09/18 15:11:45"> <link rel="StyleSheet" href="standard.css" type="text/css" media="screen"> <title>Master Contents </title> </head> <body background="images/backgrnd.gif"> <table width="300" border="0" align="right" cellpadding="0" cellspacing="0"> <tr> <td><a href="http://developer.mimer.com/documentation" target="_top"> <img src="images/navhome.gif" width="60" height="23" border="0" alt="Mimer SQL Documentation"> </a></td> <td><a href="MasterEngineNetTOC.html"><img src="images/navtoc.gif" width="90" height="23" border="0" alt="TOC"> </a></td> <td><a href=""><img src="images/navprev.gif" width="60" height="23" border="0" alt="PREV"> </a></td> <td><a href="MasterEngineCovNet.html"><img src="images/navnext.gif" width="60" height="23" border="0" alt="NEXT"> </a></td> <td><a href="MasterEngineNetIX.html"><img src="images/navidx.gif" width="90" height="23" border="0" alt="INDEX"> </a></td> </tr> </table> <p><a href="http://developer.mimer.com" target="_top"><img src="images/spider.gif" alt="Mimer SQL Developer Site" border="0" WIDTH="124" HEIGHT="82"></a></p> <p><font face="arial, helvetica, sans-serif" size="2"><a href="http://developer.mimer.com" target="_top">http://developer.mimer.com</a></font></p> <hr align="left"> <blockquote> <h5 class="Heading4"> <a name="wp864031"> </a>Master Contents </h5> <h2 class="TOC1"> <a name="wp1141732"> </a><a href="MasterEngineCovNet.html#1012077">Documentation</a></h2> <h2 class="TOC1"> <a name="wp1141734"> </a><a href="RefEngineCovNet.html#1012077">SQL Reference</a></h2> <dl> <dd class="TOC2"> <a name="wp1141736"> </a><a href="Introref.html#1112101"> Introduction</a> <dl> <dd class="TOC3"> <a name="wp1141738"> </a><a href="Introref2.html#1115376">About this Manual</a> </dl> <dd class="TOC2"> <a name="wp1141740"> </a><a href="reading_diagrams.html#1112101"> Reading SQL Syntax Diagrams</a> <dl> <dd class="TOC3"> <a name="wp1141742"> </a><a href="reading_diagrams2.html#1112252">Key to Syntax Diagrams</a> <dd class="TOC3"> <a name="wp1141744"> </a><a href="reading_diagrams3.html#1112338">Reading Standard Compliance Tables</a> </dl> <dd class="TOC2"> <a name="wp1141746"> </a><a href="Intro_SQL_Stds.html#1112101"> Introduction to SQL Standards</a> <dd class="TOC2"> <a name="wp1141748"> </a><a href="Mimer_Concepts.html#1112101"> Mimer SQL Database Objects</a> <dl> <dd class="TOC3"> <a name="wp1141750"> </a><a href="Mimer_Concepts2.html#1112307">The Data Dictionary</a> <dd class="TOC3"> <a name="wp1141752"> </a><a href="Mimer_Concepts3.html#1112524">Databanks</a> <dd class="TOC3"> <a name="wp1141754"> </a><a href="Mimer_Concepts4.html#1112626">Idents</a> <dd class="TOC3"> <a name="wp1141756"> </a><a href="Mimer_Concepts5.html#1112725">Schemas</a> <dd class="TOC3"> <a name="wp1141758"> </a><a href="Mimer_Concepts6.html#1112730">Tables</a> <dd class="TOC3"> <a name="wp1141760"> </a><a href="Mimer_Concepts7.html#1112814">Primary Keys and Indexes</a> <dd class="TOC3"> <a name="wp1141762"> </a><a href="Mimer_Concepts8.html#1180975">Stored Procedures</a> <dd class="TOC3"> <a name="wp1141764"> </a><a href="Mimer_Concepts9.html#1112871">Synonyms</a> <dd class="TOC3"> <a name="wp1141766"> </a><a href="Mimer_Concepts10.html#1112878">Shadows</a> <dd class="TOC3"> <a name="wp1141768"> </a><a href="Mimer_Concepts11.html#1112880">Triggers</a> <dd class="TOC3"> <a name="wp1141770"> </a><a href="Mimer_Concepts12.html#1112884">Sequences</a> <dd class="TOC3"> <a name="wp1141772"> </a><a href="Mimer_Concepts13.html#1152384">Precompiled Statements</a> <dd class="TOC3"> <a name="wp1141774"> </a><a href="Mimer_Concepts14.html#1125776">Mimer SQL Character Sets</a> <dd class="TOC3"> <a name="wp1141776"> </a><a href="Mimer_Concepts15.html#1133976">Collations</a> <dd class="TOC3"> <a name="wp1141778"> </a><a href="Mimer_Concepts16.html#1154127">Data Integrity</a> <dd class="TOC3"> <a name="wp1141780"> </a><a href="Mimer_Concepts17.html#1113023">Privileges</a> </dl> <dd class="TOC2"> <a name="wp1141782"> </a><a href="collref.html#1112101"> Collations and Linguistic Sorting</a> <dd class="TOC2"> <a name="wp1141784"> </a><a href="Syntax_Rules.html#1112101"> SQL Syntax Elements</a> <dl> <dd class="TOC3"> <a name="wp1141786"> </a><a href="Syntax_Rules2.html#1261018">Separators</a> <dd class="TOC3"> <a name="wp1141788"> </a><a href="Syntax_Rules3.html#1261304">Special Characters</a> <dd class="TOC3"> <a name="wp1141790"> </a><a href="Syntax_Rules4.html#1112633">Identifiers</a> <dd class="TOC3"> <a name="wp1141792"> </a><a href="Syntax_Rules5.html#1117169">Data Types in SQL Statements</a> <dd class="TOC3"> <a name="wp1141794"> </a><a href="Syntax_Rules6.html#1113767">Literals</a> </dl> <dd class="TOC2"> <a name="wp1141796"> </a><a href="ops_values.html#1132824"> Operators and Values</a> <dl> <dd class="TOC3"> <a name="wp1141798"> </a><a href="ops_values2.html#1113668">Operators</a> <dd class="TOC3"> <a name="wp1141800"> </a><a href="ops_values3.html#1113897">Value Specifications</a> <dd class="TOC3"> <a name="wp1141802"> </a><a href="ops_values4.html#1114517">Default Values</a> <dd class="TOC3"> <a name="wp1141804"> </a><a href="ops_values5.html#1116205">Assignments</a> <dd class="TOC3"> <a name="wp1141806"> </a><a href="ops_values6.html#1116291">Comparisons</a> <dd class="TOC3"> <a name="wp1141808"> </a><a href="ops_values7.html#1116385">Result Data Types</a> </dl> <dd class="TOC2"> <a name="wp1141810"> </a><a href="functions.html#1151265"> Functions</a> <dl> <dd class="TOC3"> <a name="wp1141812"> </a><a href="functions2.html#1289024">Set Functions</a> </dl> <dd class="TOC2"> <a name="wp1141814"> </a><a href="express_pred.html#1137694"> Expressions and Predicates</a> <dl> <dd class="TOC3"> <a name="wp1141816"> </a><a href="express_pred2.html#1114558">Expressions</a> <dd class="TOC3"> <a name="wp1141818"> </a><a href="express_pred3.html#1133000">CASE Expression</a> <dd class="TOC3"> <a name="wp1141820"> </a><a href="express_pred4.html#1113929">CAST Specification</a> <dd class="TOC3"> <a name="wp1141822"> </a><a href="express_pred5.html#1212479">User-Defined Function</a> <dd class="TOC3"> <a name="wp1141824"> </a><a href="express_pred6.html#1114116">Predicates</a> </dl> <dd class="TOC2"> <a name="wp1141826"> </a><a href="search_join.html#1217309"> Search Conditions and Joins</a> <dl> <dd class="TOC3"> <a name="wp1141828"> </a><a href="search_join2.html#1115592">Search Conditions</a> <dd class="TOC3"> <a name="wp1141830"> </a><a href="search_join3.html#1183484">Joined Tables</a> <dd class="TOC3"> <a name="wp1141832"> </a><a href="search_join4.html#1115957">INNER JOINs</a> <dd class="TOC3"> <a name="wp1141834"> </a><a href="search_join5.html#1194308">OUTER JOINs</a> <dd class="TOC3"> <a name="wp1141836"> </a><a href="search_join6.html#1232624">CROSS JOINs</a> <dd class="TOC3"> <a name="wp1141838"> </a><a href="search_join7.html#1232628">Standard Compliance</a> </dl> <dd class="TOC2"> <a name="wp1141840"> </a><a href="select_spec.html#1119803"> The SELECT Expression</a> <dd class="TOC2"> <a name="wp1141842"> </a><a href="SQL_Statements.html#1698298"> SQL Statement Descriptions</a> <dl> <dd class="TOC3"> <a name="wp1141844"> </a><a href="SQL_Statements2.html#1112540">Usage Modes</a> <dd class="TOC3"> <a name="wp1141846"> </a><a href="SQL_Statements3.html#1112562">ALLOCATE CURSOR</a> <dd class="TOC3"> <a name="wp1141848"> </a><a href="SQL_Statements4.html#1112628">ALLOCATE DESCRIPTOR</a> <dd class="TOC3"> <a name="wp1141850"> </a><a href="SQL_Statements5.html#1112692">ALTER DATABANK</a> <dd class="TOC3"> <a name="wp1141852"> </a><a href="SQL_Statements6.html#1112766">ALTER DATABANK RESTORE</a> <dd class="TOC3"> <a name="wp1141854"> </a><a href="SQL_Statements7.html#2480196">ALTER DATABASE</a> <dd class="TOC3"> <a name="wp1141856"> </a><a href="SQL_Statements8.html#3274400">ALTER FUNCTION</a> <dd class="TOC3"> <a name="wp1141858"> </a><a href="SQL_Statements9.html#3271725">ALTER IDENT</a> <dd class="TOC3"> <a name="wp1141860"> </a><a href="SQL_Statements10.html#3286259">ALTER PROCEDURE</a> <dd class="TOC3"> <a name="wp1141862"> </a><a href="SQL_Statements11.html#3255474">ALTER ROUTINE</a> <dd class="TOC3"> <a name="wp1141864"> </a><a href="SQL_Statements12.html#2513750">ALTER SEQUENCE</a> <dd class="TOC3"> <a name="wp1141866"> </a><a href="SQL_Statements13.html#2513195">ALTER SHADOW</a> <dd class="TOC3"> <a name="wp1141868"> </a><a href="SQL_Statements14.html#2552481">ALTER STATEMENT</a> <dd class="TOC3"> <a name="wp1141870"> </a><a href="SQL_Statements15.html#2552473">ALTER TABLE</a> <dd class="TOC3"> <a name="wp1141872"> </a><a href="SQL_Statements16.html#3238693">CALL</a> <dd class="TOC3"> <a name="wp1141874"> </a><a href="SQL_Statements17.html#1315305">CASE</a> <dd class="TOC3"> <a name="wp1141876"> </a><a href="SQL_Statements18.html#1113136">CLOSE</a> <dd class="TOC3"> <a name="wp1141878"> </a><a href="SQL_Statements19.html#1319297">COMMENT</a> <dd class="TOC3"> <a name="wp1141880"> </a><a href="SQL_Statements20.html#1113256">COMMIT</a> <dd class="TOC3"> <a name="wp1141882"> </a><a href="SQL_Statements21.html#1113306">COMPOUND STATEMENT</a> <dd class="TOC3"> <a name="wp1141884"> </a><a href="SQL_Statements22.html#1113381">CONNECT</a> <dd class="TOC3"> <a name="wp1141886"> </a><a href="SQL_Statements23.html#1113437">CREATE BACKUP</a> <dd class="TOC3"> <a name="wp1141888"> </a><a href="SQL_Statements24.html#2034940">CREATE COLLATION</a> <dd class="TOC3"> <a name="wp1141890"> </a><a href="SQL_Statements25.html#2025210">CREATE DATABANK</a> <dd class="TOC3"> <a name="wp1141892"> </a><a href="SQL_Statements26.html#1113574">CREATE DOMAIN</a> <dd class="TOC3"> <a name="wp1141894"> </a><a href="SQL_Statements27.html#1113661">CREATE FUNCTION</a> <dd class="TOC3"> <a name="wp1141896"> </a><a href="SQL_Statements28.html#1323084">CREATE IDENT</a> <dd class="TOC3"> <a name="wp1141898"> </a><a href="SQL_Statements29.html#1327036">CREATE INDEX</a> <dd class="TOC3"> <a name="wp1141900"> </a><a href="SQL_Statements30.html#2706572">CREATE MODULE</a> <dd class="TOC3"> <a name="wp1141902"> </a><a href="SQL_Statements31.html#1330985">CREATE PROCEDURE</a> <dd class="TOC3"> <a name="wp1141904"> </a><a href="SQL_Statements32.html#1114125">CREATE SCHEMA</a> <dd class="TOC3"> <a name="wp1141906"> </a><a href="SQL_Statements33.html#1331162">CREATE SEQUENCE</a> <dd class="TOC3"> <a name="wp1141908"> </a><a href="SQL_Statements34.html#1114311">CREATE SHADOW</a> <dd class="TOC3"> <a name="wp1141910"> </a><a href="SQL_Statements35.html#1114356">CREATE STATEMENT</a> <dd class="TOC3"> <a name="wp1141912"> </a><a href="SQL_Statements36.html#1385910">CREATE SYNONYM</a> <dd class="TOC3"> <a name="wp1141914"> </a><a href="SQL_Statements37.html#1331220">CREATE TABLE</a> <dd class="TOC3"> <a name="wp1141916"> </a><a href="SQL_Statements38.html#1114635">CREATE TRIGGER</a> <dd class="TOC3"> <a name="wp1141918"> </a><a href="SQL_Statements39.html#1334192">CREATE VIEW</a> <dd class="TOC3"> <a name="wp1141920"> </a><a href="SQL_Statements40.html#1114810">DEALLOCATE DESCRIPTOR</a> <dd class="TOC3"> <a name="wp1141922"> </a><a href="SQL_Statements41.html#1114847">DEALLOCATE PREPARE</a> <dd class="TOC3"> <a name="wp1141924"> </a><a href="SQL_Statements42.html#1334501">DECLARE CONDITION</a> <dd class="TOC3"> <a name="wp1141926"> </a><a href="SQL_Statements43.html#1114943">DECLARE CURSOR</a> <dd class="TOC3"> <a name="wp1141928"> </a><a href="SQL_Statements44.html#1115023">DECLARE HANDLER</a> <dd class="TOC3"> <a name="wp1141930"> </a><a href="SQL_Statements45.html#1115102">DECLARE SECTION</a> <dd class="TOC3"> <a name="wp1141932"> </a><a href="SQL_Statements46.html#1115156">DECLARE VARIABLE</a> <dd class="TOC3"> <a name="wp1141934"> </a><a href="SQL_Statements47.html#1115212">DELETE</a> <dd class="TOC3"> <a name="wp1141936"> </a><a href="SQL_Statements48.html#1115265">DELETE CURRENT</a> <dd class="TOC3"> <a name="wp1141938"> </a><a href="SQL_Statements49.html#2516417">DELETE STATISTICS</a> <dd class="TOC3"> <a name="wp1141940"> </a><a href="SQL_Statements50.html#2516381">DESCRIBE</a> <dd class="TOC3"> <a name="wp1141942"> </a><a href="SQL_Statements51.html#1115369">DISCONNECT</a> <dd class="TOC3"> <a name="wp1141944"> </a><a href="SQL_Statements52.html#1115404">DROP</a> <dd class="TOC3"> <a name="wp1141946"> </a><a href="SQL_Statements53.html#1115509">ENTER</a> <dd class="TOC3"> <a name="wp1141948"> </a><a href="SQL_Statements54.html#1115550">EXECUTE</a> <dd class="TOC3"> <a name="wp1141950"> </a><a href="SQL_Statements55.html#1115618">EXECUTE IMMEDIATE</a> <dd class="TOC3"> <a name="wp1141952"> </a><a href="SQL_Statements56.html#1401882">EXECUTE STATEMENT</a> <dd class="TOC3"> <a name="wp1141954"> </a><a href="SQL_Statements57.html#3381656">EXPLAIN</a> <dd class="TOC3"> <a name="wp1141956"> </a><a href="SQL_Statements58.html#3381625">FETCH</a> <dd class="TOC3"> <a name="wp1141958"> </a><a href="SQL_Statements59.html#2523965">FOR</a> <dd class="TOC3"> <a name="wp1141960"> </a><a href="SQL_Statements60.html#1335189">GET DESCRIPTOR</a> <dd class="TOC3"> <a name="wp1141962"> </a><a href="SQL_Statements61.html#1116353">GET DIAGNOSTICS</a> <dd class="TOC3"> <a name="wp1141964"> </a><a href="SQL_Statements62.html#1667256">GRANT ACCESS PRIVILEGE</a> <dd class="TOC3"> <a name="wp1141966"> </a><a href="SQL_Statements63.html#1337236">GRANT OBJECT PRIVILEGE</a> <dd class="TOC3"> <a name="wp1141968"> </a><a href="SQL_Statements64.html#1117056">GRANT SYSTEM PRIVILEGE</a> <dd class="TOC3"> <a name="wp1141970"> </a><a href="SQL_Statements65.html#1338858">IF</a> <dd class="TOC3"> <a name="wp1141972"> </a><a href="SQL_Statements66.html#1117187">INSERT</a> <dd class="TOC3"> <a name="wp1141974"> </a><a href="SQL_Statements67.html#1117264">ITERATE</a> <dd class="TOC3"> <a name="wp1141976"> </a><a href="SQL_Statements68.html#1517266">LEAVE</a> <dd class="TOC3"> <a name="wp1141978"> </a><a href="SQL_Statements69.html#3314042">LEAVE (PROGRAM ident)</a> <dd class="TOC3"> <a name="wp1141980"> </a><a href="SQL_Statements70.html#1339005">LOOP</a> <dd class="TOC3"> <a name="wp1141982"> </a><a href="SQL_Statements71.html#1117397">OPEN</a> <dd class="TOC3"> <a name="wp1141984"> </a><a href="SQL_Statements72.html#1117460">PREPARE</a> <dd class="TOC3"> <a name="wp1141986"> </a><a href="SQL_Statements73.html#1117601">REPEAT</a> <dd class="TOC3"> <a name="wp1141988"> </a><a href="SQL_Statements74.html#1117650">RESIGNAL</a> <dd class="TOC3"> <a name="wp1141990"> </a><a href="SQL_Statements75.html#1339084">RETURN</a> <dd class="TOC3"> <a name="wp1141992"> </a><a href="SQL_Statements76.html#1117744">REVOKE ACCESS PRIVILEGE</a> <dd class="TOC3"> <a name="wp1141994"> </a><a href="SQL_Statements77.html#1339199">REVOKE OBJECT PRIVILEGE</a> <dd class="TOC3"> <a name="wp1141996"> </a><a href="SQL_Statements78.html#1340390">REVOKE SYSTEM PRIVILEGE</a> <dd class="TOC3"> <a name="wp1141998"> </a><a href="SQL_Statements79.html#1117986">ROLLBACK</a> <dd class="TOC3"> <a name="wp1142000"> </a><a href="SQL_Statements80.html#1366424">SELECT</a> <dd class="TOC3"> <a name="wp1142002"> </a><a href="SQL_Statements81.html#1341307">SELECT INTO</a> <dd class="TOC3"> <a name="wp1142004"> </a><a href="SQL_Statements82.html#1118232">SET</a> <dd class="TOC3"> <a name="wp1142006"> </a><a href="SQL_Statements83.html#1341526">SET CONNECTION</a> <dd class="TOC3"> <a name="wp1142008"> </a><a href="SQL_Statements84.html#1118310">SET DATABANK</a> <dd class="TOC3"> <a name="wp1142010"> </a><a href="SQL_Statements85.html#1341718">SET DATABASE</a> <dd class="TOC3"> <a name="wp1142012"> </a><a href="SQL_Statements86.html#1341865">SET DESCRIPTOR</a> <dd class="TOC3"> <a name="wp1142014"> </a><a href="SQL_Statements87.html#1118526">SET SESSION</a> <dd class="TOC3"> <a name="wp1142016"> </a><a href="SQL_Statements88.html#1342461">SET SHADOW</a> <dd class="TOC3"> <a name="wp1142018"> </a><a href="SQL_Statements89.html#1118635">SET TRANSACTION</a> <dd class="TOC3"> <a name="wp1142020"> </a><a href="SQL_Statements90.html#1118778">SIGNAL</a> <dd class="TOC3"> <a name="wp1142022"> </a><a href="SQL_Statements91.html#1342650">START</a> <dd class="TOC3"> <a name="wp1142024"> </a><a href="SQL_Statements92.html#1342754">UPDATE</a> <dd class="TOC3"> <a name="wp1142026"> </a><a href="SQL_Statements93.html#1342838">UPDATE CURRENT</a> <dd class="TOC3"> <a name="wp1142028"> </a><a href="SQL_Statements94.html#1342921">UPDATE STATISTICS</a> <dd class="TOC3"> <a name="wp1142030"> </a><a href="SQL_Statements95.html#1119055">WHENEVER</a> <dd class="TOC3"> <a name="wp1142032"> </a><a href="SQL_Statements96.html#1119107">WHILE</a> </dl> <dd class="TOC2"> <a name="wp1142034"> </a><a href="Data_dic_views.html#1112101"> Data Dictionary Views</a> <dl> <dd class="TOC3"> <a name="wp1142036"> </a><a href="Data_dic_views2.html#1118541">INFORMATION_SCHEMA</a> </dl> <dd class="TOC2"> <a name="wp1142038"> </a><a href="App_reserved_words.html#1110283">Appendix A Reserved Words</a> <dd class="TOC2"> <a name="wp1142040"> </a><a href="App_char_set.html#1111952">Appendix B Character Sets</a> <dd class="TOC2"> <a name="wp1142042"> </a><a href="App_Limits.html#1104660">Appendix C Limits</a> <dd class="TOC2"> <a name="wp1142044"> </a><a href="App_deprecated.html#1104660">Appendix D Deprecated Features</a> <dl> <dd class="TOC3"> <a name="wp1142046"> </a><a href="App_deprecated2.html#1110385">Indicator Variables</a> <dd class="TOC3"> <a name="wp1142048"> </a><a href="App_deprecated3.html#1110399">Operators</a> <dd class="TOC3"> <a name="wp1142050"> </a><a href="App_deprecated4.html#1110445">Statements</a> <dd class="TOC3"> <a name="wp1142052"> </a><a href="App_deprecated5.html#1110542">Program Idents</a> <dd class="TOC3"> <a name="wp1142054"> </a><a href="App_deprecated6.html#1110553">Functions</a> <dd class="TOC3"> <a name="wp1142056"> </a><a href="App_deprecated7.html#1130956">Datetime Scalar Functions</a> <dd class="TOC3"> <a name="wp1142058"> </a><a href="App_deprecated8.html#1110562">Data Dictionary Views</a> <dd class="TOC3"> <a name="wp1142060"> </a><a href="App_deprecated9.html#1115892">Host Variable Types</a> <dd class="TOC3"> <a name="wp1142062"> </a><a href="App_deprecated10.html#1131655">SQL Data Types</a> </dl> <dd class="TOC2"> <a name="wp1142064"> </a><a href="App_return_status.html#1116120">Appendix E Return Status and Conditions</a> <dl> <dd class="TOC3"> <a name="wp1142066"> </a><a href="App_return_status2.html#1110406">SQLSTATE Return Codes</a> <dd class="TOC3"> <a name="wp1142068"> </a><a href="App_return_status3.html#1120337">SQLCODE Return Codes</a> </dl> <dd class="TOC2"> <a name="wp1142070"> </a><a href="App_SQL_compliance.html#1126197">Appendix F SQL-2016 Compliance</a> <dl> <dd class="TOC3"> <a name="wp1142072"> </a><a href="App_SQL_compliance2.html#1119348">Features Outside Core Supported by Mimer SQL</a> </dl> <dd class="TOC2"> <a name="wp1142074"> </a><a href="App_comp_funcs.html#1126197">Appendix G Compatibility Functions</a> <dd class="TOC2"> <a name="wp1142076"> </a><a href="App_languages.html#1113259">Appendix H Languages</a> <dd class="TOC2"> <a name="wp1142078"> </a><a href="App_param_precedence.html#1111952">Appendix I Type Precedence Lists</a> </dl> <h2 class="TOC1"> <a name="wp1142080"> </a><a href="ProgEngineCovNet.html#1012077">Programmer's</a></h2> <dl> <dd class="TOC2"> <a name="wp1142082"> </a><a href="Introprog.html#1136353"> Introduction</a> <dl> <dd class="TOC3"> <a name="wp1142084"> </a><a href="Introprog2.html#1121857">About this Manual</a> <dd class="TOC3"> <a name="wp1142086"> </a><a href="Introprog3.html#1121839">Database APIs</a> </dl> <dd class="TOC2"> <a name="wp1142088"> </a><a href="ODBC_API.html#1127566"> Mimer SQL and the ODBC API</a> <dl> <dd class="TOC3"> <a name="wp1142090"> </a><a href="ODBC_API2.html#1114675">The Mimer ODBC Driver</a> <dd class="TOC3"> <a name="wp1142092"> </a><a href="ODBC_API3.html#1116038">Required Files</a> <dd class="TOC3"> <a name="wp1142094"> </a><a href="ODBC_API4.html#1117904">Unicode and ANSI Interfaces</a> <dd class="TOC3"> <a name="wp1142096"> </a><a href="ODBC_API5.html#1126273">Mimer Specific Descriptor Fields</a> <dd class="TOC3"> <a name="wp1142098"> </a><a href="ODBC_API6.html#1113686">Operating Systems</a> <dd class="TOC3"> <a name="wp1142100"> </a><a href="ODBC_API7.html#1113714">Declarations</a> <dd class="TOC3"> <a name="wp1142102"> </a><a href="ODBC_API8.html#1113730">Initializing the ODBC Environment</a> <dd class="TOC3"> <a name="wp1142104"> </a><a href="ODBC_API9.html#1119327">Error Handling</a> <dd class="TOC3"> <a name="wp1142106"> </a><a href="ODBC_API10.html#1113909">Transaction Processing</a> <dd class="TOC3"> <a name="wp1142108"> </a><a href="ODBC_API11.html#1113971">Executing a Command</a> <dd class="TOC3"> <a name="wp1142110"> </a><a href="ODBC_API12.html#1113988">Repeating - Prepared Execution</a> <dd class="TOC3"> <a name="wp1142112"> </a><a href="ODBC_API13.html#1114095">Result Set Processing</a> <dd class="TOC3"> <a name="wp1142114"> </a><a href="ODBC_API14.html#1114171">Updating Data</a> </dl> <dd class="TOC2"> <a name="wp1142116"> </a><a href="JDBC_API.html#1118980"> Mimer SQL and the JDBC API</a> <dl> <dd class="TOC3"> <a name="wp1142118"> </a><a href="JDBC_API2.html#1113689">The Mimer JDBC Driver</a> </dl> <dd class="TOC2"> <a name="wp1142120"> </a><a href="Embedded_SQL.html#1112101"> Embedded SQL</a> <dl> <dd class="TOC3"> <a name="wp1142122"> </a><a href="Embedded_SQL2.html#1112642">General Principles for Embedding SQL Statements</a> <dd class="TOC3"> <a name="wp1142124"> </a><a href="Embedded_SQL3.html#1112714">Processing ESQL</a> <dd class="TOC3"> <a name="wp1142126"> </a><a href="Embedded_SQL4.html#1112906">Essential Program Structure</a> <dd class="TOC3"> <a name="wp1142128"> </a><a href="Embedded_SQL5.html#1112976">Linking Applications</a> <dd class="TOC3"> <a name="wp1142130"> </a><a href="Embedded_SQL6.html#1151979">Connecting to a Database</a> <dd class="TOC3"> <a name="wp1142132"> </a><a href="Embedded_SQL7.html#1152248">Communicating with the Application Program</a> <dd class="TOC3"> <a name="wp1142134"> </a><a href="Embedded_SQL8.html#1152923">Accessing Data</a> <dd class="TOC3"> <a name="wp1142136"> </a><a href="Embedded_SQL9.html#1153779">Dynamic SQL</a> <dd class="TOC3"> <a name="wp1142138"> </a><a href="Embedded_SQL10.html#1154035">Handling Errors and Exceptions</a> </dl> <dd class="TOC2"> <a name="wp1142140"> </a><a href="mimercapi.html#1118980"> Mimer SQL C API</a> <dl> <dd class="TOC3"> <a name="wp1142142"> </a><a href="mimercapi2.html#1260795">Architecture</a> <dd class="TOC3"> <a name="wp1142144"> </a><a href="mimercapi3.html#1190901">Array Operations</a> <dd class="TOC3"> <a name="wp1142146"> </a><a href="mimercapi4.html#1277087">Transactions</a> <dd class="TOC3"> <a name="wp1142148"> </a><a href="mimercapi5.html#1239379">Data Types</a> <dd class="TOC3"> <a name="wp1142150"> </a><a href="mimercapi6.html#1119450">Error Handling</a> <dd class="TOC3"> <a name="wp1142152"> </a><a href="mimercapi7.html#1209525">Memory Management</a> <dd class="TOC3"> <a name="wp1142154"> </a><a href="mimercapi8.html#1256104">Header Files Provided</a> <dd class="TOC3"> <a name="wp1142156"> </a><a href="mimercapi9.html#1119518">Mimer API Examples</a> <dd class="TOC3"> <a name="wp1142158"> </a><a href="mimercapi10.html#1122449">Mimer API Specification</a> </dl> <dd class="TOC2"> <a name="wp1142160"> </a><a href="rtapi.html#1118980"> Mimer SQL Real-Time</a> <dl> <dd class="TOC3"> <a name="wp1142162"> </a><a href="rtapi2.html#1257002">Real-Time Users Guide</a> <dd class="TOC3"> <a name="wp1142164"> </a><a href="rtapi3.html#1257573">Real-Time Error Handling</a> <dd class="TOC3"> <a name="wp1142166"> </a><a href="rtapi4.html#1257652">Real-Time API Specification</a> </dl> <dd class="TOC2"> <a name="wp1142168"> </a><a href="Idents_and_Dbase_connections.html#1119246"> Idents and Privileges</a> <dl> <dd class="TOC3"> <a name="wp1142170"> </a><a href="Idents_and_Dbase_connections2.html#1119285">Mimer SQL Idents</a> <dd class="TOC3"> <a name="wp1142172"> </a><a href="Idents_and_Dbase_connections3.html#1112496">Database Privileges</a> </dl> <dd class="TOC2"> <a name="wp1142174"> </a><a href="transactions_and_security.html#1112504"> Transaction Handling and Database Security</a> <dl> <dd class="TOC3"> <a name="wp1142176"> </a><a href="transactions_and_security2.html#1114122">Transaction Principles</a> <dd class="TOC3"> <a name="wp1142178"> </a><a href="transactions_and_security3.html#1130869">Transactions and Logging</a> <dd class="TOC3"> <a name="wp1142180"> </a><a href="transactions_and_security4.html#1130883">Protecting Against Data Loss</a> <dd class="TOC3"> <a name="wp1142182"> </a><a href="transactions_and_security5.html#1112586">Transaction Control Statements</a> </dl> <dd class="TOC2"> <a name="wp1142184"> </a><a href="XA.html#1112101"> Distributed Transactions</a> <dl> <dd class="TOC3"> <a name="wp1142186"> </a><a href="XA2.html#1113666">Terms and Abbreviations</a> <dd class="TOC3"> <a name="wp1142188"> </a><a href="XA3.html#1114399">How Does it Work?</a> <dd class="TOC3"> <a name="wp1142190"> </a><a href="XA4.html#1114406">Handling failures</a> <dd class="TOC3"> <a name="wp1142192"> </a><a href="XA5.html#1114474">Mimer SQL Support For Microsoft DTC on Windows</a> <dd class="TOC3"> <a name="wp1142194"> </a><a href="XA6.html#1115883">Mimer SQL Support for Java Enterprise Edition</a> </dl> <dd class="TOC2"> <a name="wp1142196"> </a><a href="PSM.html#1112101"> Mimer SQL Stored Procedures</a> <dl> <dd class="TOC3"> <a name="wp1142198"> </a><a href="PSM2.html#1112563">About Routines</a> <dd class="TOC3"> <a name="wp1142200"> </a><a href="PSM3.html#1112745">Syntactic Components of a Routine Definition</a> <dd class="TOC3"> <a name="wp1142202"> </a><a href="PSM4.html#1113003">Modules</a> <dd class="TOC3"> <a name="wp1142204"> </a><a href="PSM5.html#1140976">SQL Constructs in Routines</a> <dd class="TOC3"> <a name="wp1142206"> </a><a href="PSM6.html#1113243">Manipulating Data</a> <dd class="TOC3"> <a name="wp1142208"> </a><a href="PSM7.html#1113343">Result Set Procedures</a> <dd class="TOC3"> <a name="wp1142210"> </a><a href="PSM8.html#1155355">Managing Exception Conditions</a> <dd class="TOC3"> <a name="wp1142212"> </a><a href="PSM9.html#1113551">Access Rights</a> <dd class="TOC3"> <a name="wp1142214"> </a><a href="PSM10.html#1113563">Using DROP and REVOKE</a> <dd class="TOC3"> <a name="wp1142216"> </a><a href="PSM11.html#1128493">The Mimer SQL PSM Debugger</a> </dl> <dd class="TOC2"> <a name="wp1142218"> </a><a href="Triggers.html#1119009"> Triggers</a> <dl> <dd class="TOC3"> <a name="wp1142220"> </a><a href="Triggers2.html#1112602">Creating a Trigger</a> <dd class="TOC3"> <a name="wp1142222"> </a><a href="Triggers3.html#1112632">Trigger Time</a> <dd class="TOC3"> <a name="wp1142224"> </a><a href="Triggers4.html#1112642">Trigger Event</a> <dd class="TOC3"> <a name="wp1142226"> </a><a href="Triggers5.html#1112649">Trigger Action</a> <dd class="TOC3"> <a name="wp1142228"> </a><a href="Triggers6.html#1137905">Comments on Triggers</a> <dd class="TOC3"> <a name="wp1142230"> </a><a href="Triggers7.html#1112693">Using DROP and REVOKE</a> </dl> <dd class="TOC2"> <a name="wp1142232"> </a><a href="mimer_gis.html#1137896"> Spatial Data</a> <dl> <dd class="TOC3"> <a name="wp1142234"> </a><a href="mimer_gis2.html#1137957">Geographical Data</a> <dd class="TOC3"> <a name="wp1142236"> </a><a href="mimer_gis3.html#1139905">Coordinate System Data</a> </dl> <dd class="TOC2"> <a name="wp1142238"> </a><a href="App_Host_lang.html#1104660">Appendix A Host Language Dependent Aspects</a> <dl> <dd class="TOC3"> <a name="wp1142240"> </a><a href="App_Host_lang2.html#1110388">ESQL in C/C++ Programs</a> <dd class="TOC3"> <a name="wp1142242"> </a><a href="App_Host_lang3.html#1110567">ESQL in COBOL Programs</a> <dd class="TOC3"> <a name="wp1142244"> </a><a href="App_Host_lang4.html#1110718">ESQL in FORTRAN Programs</a> </dl> <dd class="TOC2"> <a name="wp1142246"> </a><a href="App_Return_Codes.html#1104660">Appendix B Return Codes</a> <dl> <dd class="TOC3"> <a name="wp1142248"> </a><a href="App_Return_Codes2.html#1112282">SQLSTATE Return Codes</a> <dd class="TOC3"> <a name="wp1142250"> </a><a href="App_Return_Codes3.html#1149204">Native Mimer SQL Return Codes</a> </dl> <dd class="TOC2"> <a name="wp1142252"> </a><a href="App_deprecateda.html#1104660">Appendix C Deprecated Features</a> <dl> <dd class="TOC3"> <a name="wp1142254"> </a><a href="App_deprecateda2.html#1110421">INCLUDE SQLCA</a> <dd class="TOC3"> <a name="wp1142256"> </a><a href="App_deprecateda3.html#1110432">SQLDA</a> <dd class="TOC3"> <a name="wp1142258"> </a><a href="App_deprecateda4.html#1110441">VARCHAR(size)</a> <dd class="TOC3"> <a name="wp1142260"> </a><a href="App_deprecateda5.html#1110452">SET TRANSACTION</a> <dd class="TOC3"> <a name="wp1142262"> </a><a href="App_deprecateda6.html#1110463">DBERM4</a> </dl> </dl> <h2 class="TOC1"> <a name="wp1142264"> </a><a href="UserEngineCovNet.html#1012077">User's</a></h2> <dl> <dd class="TOC2"> <a name="wp1142266"> </a><a href="Introuser.html#1112101"> Introduction</a> <dl> <dd class="TOC3"> <a name="wp1142268"> </a><a href="Introuser2.html#1115131">About this Manual</a> </dl> <dd class="TOC2"> <a name="wp1142270"> </a><a href="Basic_concepts.html#1112659"> Basic Concepts of Mimer SQL</a> <dl> <dd class="TOC3"> <a name="wp1142272"> </a><a href="Basic_concepts2.html#1134947">Tables</a> <dd class="TOC3"> <a name="wp1142274"> </a><a href="Basic_concepts3.html#1139373">Primary Keys and Indexes</a> <dd class="TOC3"> <a name="wp1142276"> </a><a href="Basic_concepts4.html#1136443">Data Integrity</a> <dd class="TOC3"> <a name="wp1142278"> </a><a href="Basic_concepts5.html#1136274">Sequences</a> <dd class="TOC3"> <a name="wp1142280"> </a><a href="Basic_concepts6.html#1168563">Synonyms</a> <dd class="TOC3"> <a name="wp1142282"> </a><a href="Basic_concepts7.html#1136104">Databanks</a> <dd class="TOC3"> <a name="wp1142284"> </a><a href="Basic_concepts8.html#1136672">Shadows</a> <dd class="TOC3"> <a name="wp1142286"> </a><a href="Basic_concepts9.html#1136730">Mimer SQL Character Sets</a> <dd class="TOC3"> <a name="wp1142288"> </a><a href="Basic_concepts10.html#1136740">Collations and Linguistic Sorting</a> <dd class="TOC3"> <a name="wp1142290"> </a><a href="Basic_concepts11.html#1136788">Stored Procedures</a> <dd class="TOC3"> <a name="wp1142292"> </a><a href="Basic_concepts12.html#1135893">Idents</a> <dd class="TOC3"> <a name="wp1142294"> </a><a href="Basic_concepts13.html#1135920">Schemas</a> <dd class="TOC3"> <a name="wp1142296"> </a><a href="Basic_concepts14.html#1113196">Access Rights and Privileges</a> <dd class="TOC3"> <a name="wp1142298"> </a><a href="Basic_concepts15.html#1135494">The Data Dictionary</a> <dd class="TOC3"> <a name="wp1142300"> </a><a href="Basic_concepts16.html#1113217">Mimer SQL Statements</a> </dl> <dd class="TOC2"> <a name="wp1142302"> </a><a href="Retreiving_Data.html#1112101"> Retrieving Data</a> <dl> <dd class="TOC3"> <a name="wp1142304"> </a><a href="Retreiving_Data2.html#1119240">Simple Retrieval</a> <dd class="TOC3"> <a name="wp1142306"> </a><a href="Retreiving_Data3.html#1119313">Result Order</a> <dd class="TOC3"> <a name="wp1142308"> </a><a href="Retreiving_Data4.html#1119345">Table Names</a> <dd class="TOC3"> <a name="wp1142310"> </a><a href="Retreiving_Data5.html#1112817">Setting Column Labels</a> <dd class="TOC3"> <a name="wp1142312"> </a><a href="Retreiving_Data6.html#1112863">Eliminating Duplicate Values</a> <dd class="TOC3"> <a name="wp1142314"> </a><a href="Retreiving_Data7.html#1112968">Selecting Specific Rows</a> <dd class="TOC3"> <a name="wp1142316"> </a><a href="Retreiving_Data8.html#1201486">Retrieving Computed Values</a> <dd class="TOC3"> <a name="wp1142318"> </a><a href="Retreiving_Data9.html#1190887">Using Scalar Functions</a> <dd class="TOC3"> <a name="wp1142320"> </a><a href="Retreiving_Data10.html#1114236">Using the CASE Expression</a> <dd class="TOC3"> <a name="wp1142322"> </a><a href="Retreiving_Data11.html#1114357">Using the CAST Specification</a> <dd class="TOC3"> <a name="wp1142324"> </a><a href="Retreiving_Data12.html#1203145">Datetime Arithmetic and Functions</a> <dd class="TOC3"> <a name="wp1142326"> </a><a href="Retreiving_Data13.html#1179385">Using Set Functions</a> <dd class="TOC3"> <a name="wp1142328"> </a><a href="Retreiving_Data14.html#1179487">Grouped Set Functions - the GROUP BY Clause</a> <dd class="TOC3"> <a name="wp1142330"> </a><a href="Retreiving_Data15.html#1179583">Selecting Groups - the HAVING Clause</a> <dd class="TOC3"> <a name="wp1142332"> </a><a href="Retreiving_Data16.html#1179624">Ordering the Result Table</a> <dd class="TOC3"> <a name="wp1142334"> </a><a href="Retreiving_Data17.html#1179377">Retrieving Data From More Than One Table</a> <dd class="TOC3"> <a name="wp1142336"> </a><a href="Retreiving_Data18.html#1216524">Handling Null Values</a> <dd class="TOC3"> <a name="wp1142338"> </a><a href="Retreiving_Data19.html#1118641">Conceptual Description of the Selection Process</a> </dl> <dd class="TOC2"> <a name="wp1142340"> </a><a href="Collations.html#1133449"> Collations</a> <dl> <dd class="TOC3"> <a name="wp1142342"> </a><a href="Collations2.html#1131662">Character Sets and Collations</a> <dd class="TOC3"> <a name="wp1142344"> </a><a href="Collations3.html#1115099">Using Collations</a> <dd class="TOC3"> <a name="wp1142346"> </a><a href="Collations4.html#1122444">Using Collations - Examples</a> </dl> <dd class="TOC2"> <a name="wp1142348"> </a><a href="Data_manipulation.html#1112101"> Working With Data</a> <dl> <dd class="TOC3"> <a name="wp1142350"> </a><a href="Data_manipulation2.html#1112753">Inserting Data</a> <dd class="TOC3"> <a name="wp1142352"> </a><a href="Data_manipulation3.html#1112885">Updating Tables</a> <dd class="TOC3"> <a name="wp1142354"> </a><a href="Data_manipulation4.html#1112912">Deleting Rows from Tables</a> <dd class="TOC3"> <a name="wp1142356"> </a><a href="Data_manipulation5.html#1112935">Calling Procedures</a> <dd class="TOC3"> <a name="wp1142358"> </a><a href="Data_manipulation6.html#1112948">Updatable Views</a> </dl> <dd class="TOC2"> <a name="wp1142360"> </a><a href="Managing_transactions.html#1112101"> Managing Transactions</a> <dl> <dd class="TOC3"> <a name="wp1142362"> </a><a href="Managing_transactions2.html#1113847">Transaction Principles</a> <dd class="TOC3"> <a name="wp1142364"> </a><a href="Managing_transactions3.html#1112759">Logging Transactions</a> <dd class="TOC3"> <a name="wp1142366"> </a><a href="Managing_transactions4.html#1112778">Handling Transactions</a> </dl> <dd class="TOC2"> <a name="wp1142368"> </a><a href="Defining_Database.html#1183658"> Creating a Database</a> <dl> <dd class="TOC3"> <a name="wp1142370"> </a><a href="Defining_Database2.html#1112759">Creating Idents and Schemas</a> <dd class="TOC3"> <a name="wp1142372"> </a><a href="Defining_Database3.html#1112802">Creating Databanks</a> <dd class="TOC3"> <a name="wp1142374"> </a><a href="Defining_Database4.html#1116219">Creating Tables</a> <dd class="TOC3"> <a name="wp1142376"> </a><a href="Defining_Database5.html#1157889">Creating Sequences</a> <dd class="TOC3"> <a name="wp1142378"> </a><a href="Defining_Database6.html#1112840">Creating Domains</a> <dd class="TOC3"> <a name="wp1142380"> </a><a href="Defining_Database7.html#1113061">Creating Functions, Procedures, Triggers and Modules</a> <dd class="TOC3"> <a name="wp1142382"> </a><a href="Defining_Database8.html#1113130">Creating Views</a> <dd class="TOC3"> <a name="wp1142384"> </a><a href="Defining_Database9.html#1113460">Creating Secondary Indexes</a> <dd class="TOC3"> <a name="wp1142386"> </a><a href="Defining_Database10.html#1113482">Creating Synonyms</a> <dd class="TOC3"> <a name="wp1142388"> </a><a href="Defining_Database11.html#1113502">Commenting Objects</a> <dd class="TOC3"> <a name="wp1142390"> </a><a href="Defining_Database12.html#1113520">Altering Databanks, Tables and Idents</a> <dd class="TOC3"> <a name="wp1142392"> </a><a href="Defining_Database13.html#1113600">Dropping Objects from the Database</a> </dl> <dd class="TOC2"> <a name="wp1142394"> </a><a href="Defining_Privileges.html#1112101"> Defining Privileges</a> <dl> <dd class="TOC3"> <a name="wp1142396"> </a><a href="Defining_Privileges2.html#1112758">Ident Structure</a> <dd class="TOC3"> <a name="wp1142398"> </a><a href="Defining_Privileges3.html#1112775">Granting Privileges</a> <dd class="TOC3"> <a name="wp1142400"> </a><a href="Defining_Privileges4.html#1112867">Revoking Privileges</a> </dl> <dd class="TOC2"> <a name="wp1142402"> </a><a href="BSQL_commands.html#1112101"> Mimer BSQL</a> <dl> <dd class="TOC3"> <a name="wp1142404"> </a><a href="BSQL_commands2.html#1112874">Running BSQL</a> <dd class="TOC3"> <a name="wp1142406"> </a><a href="BSQL_commands3.html#1116651">BSQL Commands</a> <dd class="TOC3"> <a name="wp1142408"> </a><a href="BSQL_commands4.html#1135216">Variables in BSQL</a> <dd class="TOC3"> <a name="wp1142410"> </a><a href="BSQL_commands5.html#1193091">BSQL and Multiple Connections</a> <dd class="TOC3"> <a name="wp1142412"> </a><a href="BSQL_commands6.html#1193071">Transaction Handling in Mimer BSQL</a> <dd class="TOC3"> <a name="wp1142414"> </a><a href="BSQL_commands7.html#1159139">LOBs in BSQL</a> <dd class="TOC3"> <a name="wp1142416"> </a><a href="BSQL_commands8.html#1149590">Errors in BSQL</a> <dd class="TOC3"> <a name="wp1142418"> </a><a href="BSQL_commands9.html#1135416">Error Messages</a> </dl> <dd class="TOC2"> <a name="wp1142420"> </a><a href="explain.html#1112101">Appendix A Mimer SQL Explain</a> <dd class="TOC2"> <a name="wp1142422"> </a><a href="App_ex_database.html#1104660">Appendix B The Example Environment</a> <dl> <dd class="TOC3"> <a name="wp1142424"> </a><a href="App_ex_database2.html#1138315">The EXLOAD program</a> <dd class="TOC3"> <a name="wp1142426"> </a><a href="App_ex_database3.html#1138976">The MIMER_STORE Schema</a> <dd class="TOC3"> <a name="wp1142428"> </a><a href="App_ex_database4.html#1133509">Procedures</a> <dd class="TOC3"> <a name="wp1142430"> </a><a href="App_ex_database5.html#1133510">Views</a> <dd class="TOC3"> <a name="wp1142432"> </a><a href="App_ex_database6.html#1133543">Triggers</a> <dd class="TOC3"> <a name="wp1142434"> </a><a href="App_ex_database7.html#1133549">Idents</a> <dd class="TOC3"> <a name="wp1142436"> </a><a href="App_ex_database8.html#1133557">The MIMER_STORE_MUSIC Schema</a> <dd class="TOC3"> <a name="wp1142438"> </a><a href="App_ex_database9.html#1133670">The MIMER_STORE_BOOK Schema</a> <dd class="TOC3"> <a name="wp1142440"> </a><a href="App_ex_database10.html#1133763">The MIMER_STORE Schema Revisited</a> <dd class="TOC3"> <a name="wp1142442"> </a><a href="App_ex_database11.html#1133778">The MIMER_STORE_WEB Schema</a> <dd class="TOC3"> <a name="wp1142444"> </a><a href="App_ex_database12.html#1133851">Synonyms</a> </dl> <dd class="TOC2"> <a name="wp1142446"> </a><a href="App_deprecatedb.html#1104660">Appendix C Deprecated Features</a> <dl> <dd class="TOC3"> <a name="wp1142448"> </a><a href="App_deprecatedb2.html#1111601">BSQL Commands</a> </dl> </dl> <h2 class="TOC1"> <a name="wp1142450"> </a><a href="SysEngineCovNet.html#1012077">System Management</a></h2> <dl> <dd class="TOC2"> <a name="wp1142452"> </a><a href="Introsys.html#1139437"> Introduction</a> <dl> <dd class="TOC3"> <a name="wp1142454"> </a><a href="Introsys2.html#1154001">About this Manual</a> <dd class="TOC3"> <a name="wp1142456"> </a><a href="Introsys3.html#1146642">System Management Responsibilities</a> </dl> <dd class="TOC2"> <a name="wp1142458"> </a><a href="DB_environment.html#1106355"> The Database Environment</a> <dl> <dd class="TOC3"> <a name="wp1142460"> </a><a href="DB_environment2.html#1106782">The Data Dictionary</a> <dd class="TOC3"> <a name="wp1142462"> </a><a href="DB_environment3.html#1106789">Idents</a> <dd class="TOC3"> <a name="wp1142464"> </a><a href="DB_environment4.html#1106806">Schemas</a> <dd class="TOC3"> <a name="wp1142466"> </a><a href="DB_environment5.html#1106812">Databanks</a> <dd class="TOC3"> <a name="wp1142468"> </a><a href="DB_environment6.html#1106842">Databank Options</a> <dd class="TOC3"> <a name="wp1142470"> </a><a href="DB_environment7.html#1106857">Locating Databank Files</a> <dd class="TOC3"> <a name="wp1142472"> </a><a href="DB_environment8.html#1106892">Organizing Databank Files</a> <dd class="TOC3"> <a name="wp1142474"> </a><a href="DB_environment9.html#1106979">Altering Databank Locations</a> <dd class="TOC3"> <a name="wp1142476"> </a><a href="DB_environment10.html#1215515">Accessing Databank Files</a> <dd class="TOC3"> <a name="wp1142478"> </a><a href="DB_environment11.html#1107014">Databank File Deletion</a> <dd class="TOC3"> <a name="wp1142480"> </a><a href="DB_environment12.html#1107020">Transaction Control</a> <dd class="TOC3"> <a name="wp1142482"> </a><a href="DB_environment13.html#1107038">Database Security</a> <dd class="TOC3"> <a name="wp1142484"> </a><a href="DB_environment14.html#1107150">Data Integrity</a> </dl> <dd class="TOC2"> <a name="wp1142486"> </a><a href="Estab_DB.html#1143239"> Creating a Mimer SQL Database</a> <dl> <dd class="TOC3"> <a name="wp1142488"> </a><a href="Estab_DB2.html#1143248">Registering the Database</a> <dd class="TOC3"> <a name="wp1142490"> </a><a href="Estab_DB3.html#1143270">The Local Database</a> <dd class="TOC3"> <a name="wp1142492"> </a><a href="Estab_DB4.html#1143298">Accessing a Database Remotely</a> <dd class="TOC3"> <a name="wp1142494"> </a><a href="Estab_DB5.html#1143344">Mimer SQL License Key</a> <dd class="TOC3"> <a name="wp1142496"> </a><a href="Estab_DB6.html#1143410">MIMLICENSE - Managing the license key</a> <dd class="TOC3"> <a name="wp1142498"> </a><a href="Estab_DB7.html#1190768">SDBGEN - Generating the System Databanks</a> <dd class="TOC3"> <a name="wp1142500"> </a><a href="Estab_DB8.html#1143706">Establishing the Ident and Data Structure</a> <dd class="TOC3"> <a name="wp1142502"> </a><a href="Estab_DB9.html#1197973">Managing Database Connections</a> <dd class="TOC3"> <a name="wp1142504"> </a><a href="Estab_DB10.html#1143844">Executing SQL Statements</a> </dl> <dd class="TOC2"> <a name="wp1142506"> </a><a href="Managing_DB_server.html#1104660"> Managing a Database Server</a> <dl> <dd class="TOC3"> <a name="wp1142508"> </a><a href="Managing_DB_server2.html#1107481">Database Server Memory Areas</a> <dd class="TOC3"> <a name="wp1142510"> </a><a href="Managing_DB_server3.html#1115745">Threads</a> <dd class="TOC3"> <a name="wp1142512"> </a><a href="Managing_DB_server4.html#1106443">Database Server System Requirements</a> <dd class="TOC3"> <a name="wp1142514"> </a><a href="Managing_DB_server5.html#1106497">MIMCONTROL - Controlling the Database Server</a> <dd class="TOC3"> <a name="wp1142516"> </a><a href="Managing_DB_server6.html#1139441">MIMINFO - System Information</a> <dd class="TOC3"> <a name="wp1142518"> </a><a href="Managing_DB_server7.html#1107112">Database Server Log</a> <dd class="TOC3"> <a name="wp1142520"> </a><a href="Managing_DB_server8.html#1107144">Several Installations on One Machine</a> </dl> <dd class="TOC2"> <a name="wp1142522"> </a><a href="Backup_Restore.html#1107027"> Backing-up and Restoring Data</a> <dl> <dd class="TOC3"> <a name="wp1142524"> </a><a href="Backup_Restore2.html#1112215">Database Consistency</a> <dd class="TOC3"> <a name="wp1142526"> </a><a href="Backup_Restore3.html#1106443">Databank Backups</a> <dd class="TOC3"> <a name="wp1142528"> </a><a href="Backup_Restore4.html#1106485">Backing-up Databanks</a> <dd class="TOC3"> <a name="wp1142530"> </a><a href="Backup_Restore5.html#1106549">Restoring a Databank</a> <dd class="TOC3"> <a name="wp1142532"> </a><a href="Backup_Restore6.html#1141378">Audit trail with READLOG</a> </dl> <dd class="TOC2"> <a name="wp1142534"> </a><a href="DB_check_functionality.html#1104660"> Databank Check Functionality</a> <dl> <dd class="TOC3"> <a name="wp1142536"> </a><a href="DB_check_functionality2.html#1106385">DBC - Databank Check</a> <dd class="TOC3"> <a name="wp1142538"> </a><a href="DB_check_functionality3.html#1106434">Result File Contents</a> <dd class="TOC3"> <a name="wp1142540"> </a><a href="DB_check_functionality4.html#1130959">Internal Databank Check</a> </dl> <dd class="TOC2"> <a name="wp1142542"> </a><a href="DB_Open.html#1104660"> Databank Open Function</a> <dl> <dd class="TOC3"> <a name="wp1142544"> </a><a href="DB_Open2.html#1120039">DBOPEN - Databank Open functionality</a> <dd class="TOC3"> <a name="wp1142546"> </a><a href="DB_Open3.html#1106452">Functions</a> </dl> <dd class="TOC2"> <a name="wp1142548"> </a><a href="Load.html#1135036"> Loading and Unloading Data and Definitions</a> <dl> <dd class="TOC3"> <a name="wp1142550"> </a><a href="Load2.html#1151496">MIMLOAD - Data Load and Unload</a> <dd class="TOC3"> <a name="wp1142552"> </a><a href="Load3.html#1114767">LOAD - Loading Data</a> <dd class="TOC3"> <a name="wp1142554"> </a><a href="Load4.html#1115966">UNLOAD - Unloading Data</a> </dl> <dd class="TOC2"> <a name="wp1142556"> </a><a href="introlrepl.html#1132848"> Replication</a> <dl> <dd class="TOC3"> <a name="wp1142558"> </a><a href="introlrepl2.html#1134444">MIMREPADM - Replication Administration</a> <dd class="TOC3"> <a name="wp1142560"> </a><a href="introlrepl3.html#1135653">REPSERVER - Replicating the Data</a> <dd class="TOC3"> <a name="wp1142562"> </a><a href="introlrepl4.html#1134238">MIMSYNC - Synchronizing Tables</a> </dl> <dd class="TOC2"> <a name="wp1142564"> </a><a href="Shadowing.html#1104660"> Mimer SQL Shadowing</a> <dl> <dd class="TOC3"> <a name="wp1142566"> </a><a href="Shadowing2.html#1106382">About Databank Shadowing</a> <dd class="TOC3"> <a name="wp1142568"> </a><a href="Shadowing3.html#1106395">Levels of Data Protection</a> <dd class="TOC3"> <a name="wp1142570"> </a><a href="Shadowing4.html#1106428">Creating and Managing Shadows</a> <dd class="TOC3"> <a name="wp1142572"> </a><a href="Shadowing5.html#1147593">SQL Shadowing Commands - an Example Session</a> <dd class="TOC3"> <a name="wp1142574"> </a><a href="Shadowing6.html#1106712">Shadowing System Databanks</a> <dd class="TOC3"> <a name="wp1142576"> </a><a href="Shadowing7.html#1106816">Data Protection Strategy</a> <dd class="TOC3"> <a name="wp1142578"> </a><a href="Shadowing8.html#1106819">Configuring Your System</a> <dd class="TOC3"> <a name="wp1142580"> </a><a href="Shadowing9.html#1106831">Performance Aspects of Shadowing</a> <dd class="TOC3"> <a name="wp1142582"> </a><a href="Shadowing10.html#1106835">Troubleshooting</a> </dl> <dd class="TOC2"> <a name="wp1142584"> </a><a href="Statistics.html#1104660"> Database Statistics</a> <dl> <dd class="TOC3"> <a name="wp1142586"> </a><a href="Statistics2.html#1106407">Authorization</a> <dd class="TOC3"> <a name="wp1142588"> </a><a href="Statistics3.html#1106413">The SQL Statistics Statements</a> <dd class="TOC3"> <a name="wp1142590"> </a><a href="Statistics4.html#1106445">When to Use the SQL Statistics Statements</a> </dl> <dd class="TOC2"> <a name="wp1142592"> </a><a href="sqlmonitor.html#1125436"> SQL Monitoring on the Database Server</a> <dl> <dd class="TOC3"> <a name="wp1142594"> </a><a href="sqlmonitor2.html#1125602">Authorization</a> </dl> <dd class="TOC2"> <a name="wp1142596"> </a><a href="App_A_single_mode.html#1104660">Appendix A Executing in Single-user Mode</a> <dl> <dd class="TOC3"> <a name="wp1142598"> </a><a href="App_A_single_mode2.html#1107021">File Protection in Single- and Multi-user Mode</a> <dd class="TOC3"> <a name="wp1142600"> </a><a href="App_A_single_mode3.html#1107428">Specifying Single-user Mode Access</a> <dd class="TOC3"> <a name="wp1142602"> </a><a href="App_A_single_mode4.html#1107036">Accessing in Single-user Mode</a> <dd class="TOC3"> <a name="wp1142604"> </a><a href="App_A_single_mode5.html#1124122">The SINGLEDEFS Parameter File</a> </dl> <dd class="TOC2"> <a name="wp1142606"> </a><a href="App_B_SQLHOSTS_on_VMS_Unix.html#1104660">Appendix B The SQLHOSTS File on VMS and Linux</a> <dl> <dd class="TOC3"> <a name="wp1142608"> </a><a href="App_B_SQLHOSTS_on_VMS_Unix2.html#1118737">The SQLHOSTS File</a> </dl> <dd class="TOC2"> <a name="wp1142610"> </a><a href="App_Multidef.html#1104660">Appendix C The MULTIDEFS File on VMS and UNIX</a> <dl> <dd class="TOC3"> <a name="wp1142612"> </a><a href="App_Multidef2.html#1107047">The MULTIDEFS Parameter File</a> <dd class="TOC3"> <a name="wp1142614"> </a><a href="App_Multidef3.html#1121762">MULTIDEFS Parameters</a> </dl> <dd class="TOC2"> <a name="wp1142616"> </a><a href="App_C_unix.html#1104660">Appendix D Linux Specifics</a> <dl> <dd class="TOC3"> <a name="wp1142618"> </a><a href="App_C_unix2.html#1107040">Man Pages</a> <dd class="TOC3"> <a name="wp1142620"> </a><a href="App_C_unix3.html#1117971">Automatic Database Start and Stop</a> <dd class="TOC3"> <a name="wp1142622"> </a><a href="App_C_unix4.html#1119418">MIMTCP -Database TCP/IP connect dispatcher</a> <dd class="TOC3"> <a name="wp1142624"> </a><a href="App_C_unix5.html#1119439">Services setup</a> <dd class="TOC3"> <a name="wp1142626"> </a><a href="App_C_unix6.html#1119451">Networking Setup</a> <dd class="TOC3"> <a name="wp1142628"> </a><a href="App_C_unix7.html#1114401">Environment Variables</a> <dd class="TOC3"> <a name="wp1142630"> </a><a href="App_C_unix8.html#1123852">Linux Commands</a> <dd class="TOC3"> <a name="wp1142632"> </a><a href="App_C_unix9.html#1124209">Linux Link Libraries</a> </dl> <dd class="TOC2"> <a name="wp1142634"> </a><a href="App_D_Dic_tables.html#1104660">Appendix E Data Dictionary Tables</a> <dl> <dd class="TOC3"> <a name="wp1142636"> </a><a href="App_D_Dic_tables2.html#1107050">Summary of Data Dictionary Tables</a> </dl> <dd class="TOC2"> <a name="wp1142638"> </a><a href="App_deprecatedc.html#1112101">Appendix F Deprecated Features</a> <dl> <dd class="TOC3"> <a name="wp1142640"> </a><a href="App_deprecatedc2.html#1113763">Export/Import</a> <dd class="TOC3"> <a name="wp1142642"> </a><a href="App_deprecatedb3.html#1113768">Load/Unload</a> <dd class="TOC3"> <a name="wp1142644"> </a><a href="App_deprecatedb4.html#1113856">Readlog from UTIL</a> <dd class="TOC3"> <a name="wp1142646"> </a><a href="App_deprecatedb5.html#1113866">Backup/Restore from UTIL</a> <dd class="TOC3"> <a name="wp1142648"> </a><a href="App_deprecatedb6.html#1113881">Statistics from UTIL</a> <dd class="TOC3"> <a name="wp1142650"> </a><a href="App_deprecatedb7.html#1113896">Shadowing Management from UTIL</a> </dl> </dl> </blockquote> <hr> <table align="right" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="right"><font size="1"> <a href="http://www.mimer.com" target="_top"> <img src="images/mimerlogo.gif" width="108" height="21" border="0" alt="Mimer"></a><br> <a href="http://www.mimer.com" target="_top">Mimer Information Technology AB</a><br> Phone: +46 18 780 92 00<br> <a href="mailto:info@mimer.com">info@mimer.com</a><br> </font></td> </tr> </table> <table width="300" border="0" cellpadding="0" cellspacing="0"> <tr> <td><a href="http://developer.mimer.com/documentation" target="_top"> <img src="images/navhome.gif" width="60" height="23" border="0" alt="Mimer SQL Documentation"> </a></td> <td><a href="MasterEngineNetTOC.html"><img src="images/navtoc.gif" width="90" height="23" border="0" alt="TOC"> </a></td> <td><a href=""><img src="images/navprev.gif" width="60" height="23" border="0" alt="PREV"> </a></td> <td><a href="MasterEngineCovNet.html"><img src="images/navnext.gif" width="60" height="23" border="0" alt="NEXT"> </a></td> <td><a href="MasterEngineNetIX.html"><img src="images/navidx.gif" width="90" height="23" border="0" alt="INDEX"> </a></td> </tr> </table> </body> </html>