<?xml version="1.0" encoding="utf-8"?>
<toc label="Infor ERP LN SQL">
   <topic label="SQL reserved words"
          href="help/html/progguide/functions_database_handling/sql_reserved_words.htm"/>
   <topic label="SQL data types"
          href="help/html/progguide/functions_database_handling/sql_data_types.htm"/>
   <topic label="Comparable data types in Infor ERP LN SQL"
          href="help/html/progguide/functions_database_handling/comparable_datatypes.htm"/>
   <topic label="SELECT statement"
          href="help/html/progguide/functions_database_handling/select_statement.htm">
      <a href="progguide/functions_database_handling/select_statement.htm">SELECT statement</a>
      <topic label="Query expression"
             href="help/html/progguide/functions_database_handling/query_expression.htm"/>
      <topic label="Query specification"
             href="help/html/progguide/functions_database_handling/query_specification.htm"/>
      <topic label="SELECT clause"
             href="help/html/progguide/functions_database_handling/select.htm"/>
      <topic label="FROM clause"
             href="help/html/progguide/functions_database_handling/from.htm"/>
      <topic label="WHERE clause"
             href="help/html/progguide/functions_database_handling/where.htm"/>
      <topic label="GROUP BY clause"
             href="help/html/progguide/functions_database_handling/group_by.htm"/>
      <topic label="HAVING clause"
             href="help/html/progguide/functions_database_handling/having.htm"/>
      <topic label="ORDER BY clause"
             href="help/html/progguide/functions_database_handling/order_by.htm"/>
      <topic label="WITH RETRY clause"
             href="help/html/progguide/functions_database_handling/with_retry.htm"/>
      <topic label="SET specification"
             href="help/html/progguide/functions_database_handling/set_specification.htm"/>
      <topic label="UNION operator"
             href="help/html/progguide/functions_database_handling/union.htm"/>
      <topic label="Value Expression"
             href="help/html/progguide/functions_database_handling/value_expression.htm">
         <a href="progguide/functions_database_handling/value_expression.htm">Value expression</a>
         <topic label="Identifier"
                href="help/html/progguide/functions_database_handling/identifier.htm"/>
         <topic label="Column reference"
                href="help/html/progguide/functions_database_handling/column_reference.htm"/>
         <topic label="Sub query"
                href="help/html/progguide/functions_database_handling/sub_query.htm"/>
         <topic label="Integer constant"
                href="help/html/progguide/functions_database_handling/integer_constant.htm"/>
         <topic label="Real constant"
                href="help/html/progguide/functions_database_handling/real_constant.htm"/>
         <topic label="String constant"
                href="help/html/progguide/functions_database_handling/string_constant.htm"/>
         <topic label="Raw constant"
                href="help/html/progguide/functions_database_handling/raw_constant.htm"/>
         <topic label="Date constant"
                href="help/html/progguide/functions_database_handling/date_constant.htm"/>
         <topic label="Timestamp constant"
                href="help/html/progguide/functions_database_handling/timestamp_constant.htm"/>
         <topic label="Enumerate constant"
                href="help/html/progguide/functions_database_handling/enumerate_constant.htm"/>
         <topic label="EMPTY constant"
                href="help/html/progguide/functions_database_handling/empty_constant.htm"/>
         <topic label="CURRENT_DATE"
                href="help/html/progguide/functions_database_handling/current_date.htm"/>
         <topic label="CURRENT_TIMESTAMP"
                href="help/html/progguide/functions_database_handling/current_timestamp.htm"/>
         <topic label="Operator + (add)"
                href="help/html/progguide/functions_database_handling/ve_add.htm"/>
         <topic label="Operator - (subtract)"
                href="help/html/progguide/functions_database_handling/ve_subtract.htm"/>
         <topic label="Operator * (multiply)"
                href="help/html/progguide/functions_database_handling/ve_multiply.htm"/>
         <topic label="Operator / (divide)"
                href="help/html/progguide/functions_database_handling/ve_divide.htm"/>
         <topic label="Operator \ (modulo)"
                href="help/html/progguide/functions_database_handling/ve_modulo.htm"/>
         <topic label="Operator &amp; (concatenation)"
                href="help/html/progguide/functions_database_handling/ve_concat.htm"/>
         <topic label="Parameter"
                href="help/html/progguide/functions_database_handling/parameter.htm"/>
         <topic label="CASE expression (searched)"
                href="help/html/progguide/functions_database_handling/searched_case.htm"/>
         <topic label="CASE expression (simple)"
                href="help/html/progguide/functions_database_handling/simple_case.htm"/>
         <topic label="CAST expression"
                href="help/html/progguide/functions_database_handling/cast_expression.htm"/>
         <topic label="Set function specification"
                href="help/html/progguide/functions_database_handling/set_function_specification.htm"/>
         <topic label="Substring and array indexing"
                href="help/html/progguide/functions_database_handling/substring_and_array_indexing.htm"/>
         <topic label="TRIM function"
                href="help/html/progguide/functions_database_handling/trim_function.htm"/>
         <topic label="ml_one_lang function"
                href="help/html/progguide/functions_database_handling/ml_one_lang_function.htm"/>
         <topic label="ENUM_DESCRIPTION function"
                href="help/html/progguide/functions_database_handling/enum_description_function.htm"/>
         <topic label="TEXT_CONTENT function"
                href="help/html/progguide/functions_database_handling/text_content_function.htm"/>
      </topic>
      <topic label="Search Condition"
             href="help/html/progguide/functions_database_handling/search_condition.htm">
         <a href="progguide/functions_database_handling/search_condition.htm">Search condition</a>
         <topic label="Comparison predicate"
                href="help/html/progguide/functions_database_handling/comparison_pred.htm"/>
         <topic label="Simplest comparison predicate"
                href="help/html/progguide/functions_database_handling/simplest_comparison_predicate.htm"/>
         <topic label="AND boolean operator"
                href="help/html/progguide/functions_database_handling/and_sc.htm"/>
         <topic label="OR boolean operator"
                href="help/html/progguide/functions_database_handling/or_sc.htm"/>
         <topic label="NOT boolean operator"
                href="help/html/progguide/functions_database_handling/not_sc.htm"/>
         <topic label="BETWEEN predicate"
                href="help/html/progguide/functions_database_handling/between_pred.htm"/>
         <topic label="INRANGE predicate"
                href="help/html/progguide/functions_database_handling/inrange_pred.htm"/>
         <topic label="IN predicate"
                href="help/html/progguide/functions_database_handling/in_pred.htm"/>
         <topic label="EXISTS predicate"
                href="help/html/progguide/functions_database_handling/exists_pred.htm"/>
         <topic label="IS NULL predicate"
                href="help/html/progguide/functions_database_handling/is_null_pred.htm"/>
         <topic label="LIKE predicate"
                href="help/html/progguide/functions_database_handling/like_pred.htm"/>
         <topic label="REFERS TO predicate"
                href="help/html/progguide/functions_database_handling/refers_to_pred.htm"/>
         <topic label="Row value constructor"
                href="help/html/progguide/functions_database_handling/row_value_constructor.htm"/>
         <topic label="_compnr predicate"
                href="help/html/progguide/functions_database_handling/compnr_pred.htm"/>
      </topic>
   </topic>
   <topic label="Using program variables"
          href="help/html/progguide/functions_database_handling/using_program_variables.htm"/>
   <topic label="References"
          href="help/html/progguide/functions_database_handling/references.htm"/>
   <topic label="Company numbers"
          href="help/html/progguide/functions_database_handling/company_numbers.htm"/>
   <topic label="Multi Language Data"
          href="help/html/progguide/functions_database_handling/multi_language_data.htm"/>
   <topic label="SQL and combined fields"
          href="help/html/progguide/functions_database_handling/sql_and_combined_fields.htm"/>
   <topic label="SQL subqueries"
          href="help/html/progguide/functions_database_handling/sql_subqueries.htm"/>
   <topic label="SQL programming"
          href="help/html/progguide/functions_database_handling/sql_programming.htm">
      <a href="progguide/functions_database_handling/sql_programming.htm">SQL programming</a>
      <topic label="Embedded SQL"
             href="help/html/progguide/functions_database_handling/embedded_sql.htm"/>
      <topic label="Dynamic SQL"
             href="help/html/progguide/functions_database_handling/dynamic_sql.htm"/>
   </topic>
   <topic label="SQL and delayed locks"
          href="help/html/progguide/functions_database_handling/sql_and_delayed_locks.htm"/>
   <topic label="SQL trace options"
          href="help/html/progguide/functions_database_handling/sql_trace_options.htm"/>
   <topic label="States and messages"
          href="help/html/progguide/sql_states_and_messages/help_sql_states_and_messages.htm">
      <a href="progguide/sql_states_and_messages/help_sql_states_and_messages.htm">SQL states and messages</a>
      <topic label="21000 - Cardinality violation"
             href="help/html/progguide/sql_states_and_messages/21000.htm"/>
      <topic label="22001 - String data right truncation"
             href="help/html/progguide/sql_states_and_messages/22001.htm"/>
      <topic label="22008 - Datetime value out of range"
             href="help/html/progguide/sql_states_and_messages/22008.htm"/>
      <topic label="22011 - Substring error"
             href="help/html/progguide/sql_states_and_messages/22011.htm"/>
      <topic label="22012 - Division by zero"
             href="help/html/progguide/sql_states_and_messages/22012.htm"/>
      <topic label="22019 - Invalid escape character"
             href="help/html/progguide/sql_states_and_messages/22019.htm"/>
      <topic label="22025 - Invalid escape sequence"
             href="help/html/progguide/sql_states_and_messages/22025.htm"/>
      <topic label="22026 - String data length mismatch"
             href="help/html/progguide/sql_states_and_messages/22026.htm"/>
      <topic label="42I01 - Duplicate table name or alias name"
             href="help/html/progguide/sql_states_and_messages/42I01.htm"/>
      <topic label="42I02 - Ambiguous column reference"
             href="help/html/progguide/sql_states_and_messages/42I02.htm"/>
      <topic label="42I03 - Unknown column"
             href="help/html/progguide/sql_states_and_messages/42I03.htm"/>
      <topic label="42I04 - Unknown table"
             href="help/html/progguide/sql_states_and_messages/42I04.htm"/>
      <topic label="42I05 - The value of the numeric literal is out of range"
             href="help/html/progguide/sql_states_and_messages/42I05.htm"/>
      <topic label="42I06 - Array indexing operator applied to non array column"
             href="help/html/progguide/sql_states_and_messages/42I06.htm"/>
      <topic label="42I08 - Combined expression in LIKE predicate"
             href="help/html/progguide/sql_states_and_messages/42I08.htm"/>
      <topic label="42I09 - Combined column in indexing or substring expression"
             href="help/html/progguide/sql_states_and_messages/42I09.htm"/>
      <topic label="42I10 - Combined column used in expression"
             href="help/html/progguide/sql_states_and_messages/42I10.htm"/>
      <topic label="42I11 - Combined column used in combined"
             href="help/html/progguide/sql_states_and_messages/42I11.htm"/>
      <topic label="42I12 - Combined reference operand must contain only constants or only columns"
             href="help/html/progguide/sql_states_and_messages/42I12.htm"/>
      <topic label="42I13 - Columns in combined reference operand cannot be of different tables"
             href="help/html/progguide/sql_states_and_messages/42I13.htm"/>
      <topic label="42I14 - Invalid reference path element"
             href="help/html/progguide/sql_states_and_messages/42I14.htm"/>
      <topic label="42I15 - REFERS TO predicate in OR condition"
             href="help/html/progguide/sql_states_and_messages/42I15.htm"/>
      <topic label="42I16 - REFERS TO predicate in NOT condition"
             href="help/html/progguide/sql_states_and_messages/42I16.htm"/>
      <topic label="42I17 - Cycle in REFERS TO predicates"
             href="help/html/progguide/sql_states_and_messages/42I17.htm"/>
      <topic label="42I18 - Table is referred to by different tables"
             href="help/html/progguide/sql_states_and_messages/42I18.htm"/>
      <topic label="42I19 - Column is not a grouping column"
             href="help/html/progguide/sql_states_and_messages/42I19.htm"/>
      <topic label="42I20 - Aggregate function on combined column"
             href="help/html/progguide/sql_states_and_messages/42I20.htm"/>
      <topic label="42I21 - Aggregate function applied to column which is not a column of a grouped table"
             href="help/html/progguide/sql_states_and_messages/42I21.htm"/>
      <topic label="42I22 - The ORDER BY number is an invalid number"
             href="help/html/progguide/sql_states_and_messages/42I22.htm"/>
      <topic label="42I23 - ORDER BY column is not in SELECT clause"
             href="help/html/progguide/sql_states_and_messages/42I23.htm"/>
      <topic label="42I24 - DATE.TO.NUM does not represent a valid date"
             href="help/html/progguide/sql_states_and_messages/42I24.htm"/>
      <topic label="42I25 - SELECT clause of subquery contains more than 1 item"
             href="help/html/progguide/sql_states_and_messages/42I25.htm"/>
      <topic label="42I26 - Combined expression in IN predicate"
             href="help/html/progguide/sql_states_and_messages/42I26.htm"/>
      <topic label="42I28 - Unknown enum value"
             href="help/html/progguide/sql_states_and_messages/42I28.htm"/>
      <topic label="42I29 - Compnr specification in NOT condition"
             href="help/html/progguide/sql_states_and_messages/42I29.htm"/>
      <topic label="42I30 - Compnr specification in OR condition"
             href="help/html/progguide/sql_states_and_messages/42I30.htm"/>
      <topic label="42I31 - Multiple compnr specifications on table"
             href="help/html/progguide/sql_states_and_messages/42I31.htm"/>
      <topic label="42I32 - Compnr specification in HAVING clause"
             href="help/html/progguide/sql_states_and_messages/42I32.htm"/>
      <topic label="42I33 - REFERS TO predicate in HAVING clause"
             href="help/html/progguide/sql_states_and_messages/42I33.htm"/>
      <topic label="42I34 - Multiple row mode hints specified"
             href="help/html/progguide/sql_states_and_messages/42I34.htm"/>
      <topic label="42I35 - Multiple array fetching hints specified"
             href="help/html/progguide/sql_states_and_messages/42I35.htm"/>
      <topic label="42I36 - Multiple array size hints specified"
             href="help/html/progguide/sql_states_and_messages/42I36.htm"/>
      <topic label="42I37 - Invalid array size"
             href="help/html/progguide/sql_states_and_messages/42I37.htm"/>
      <topic label="42I38 - Multiple buffer size hints specified"
             href="help/html/progguide/sql_states_and_messages/42I38.htm"/>
      <topic label="42I39 - Invalid buffer size"
             href="help/html/progguide/sql_states_and_messages/42I39.htm"/>
      <topic label="42I40 - Multiple string hints specified"
             href="help/html/progguide/sql_states_and_messages/42I40.htm"/>
      <topic label="42I41 - Multiple ordered hints specified"
             href="help/html/progguide/sql_states_and_messages/42I41.htm"/>
      <topic label="42I42 - Multiple 'no hints' hints specified"
             href="help/html/progguide/sql_states_and_messages/42I42.htm"/>
      <topic label="42I43 - Maximum number of index hints per table exceeded"
             href="help/html/progguide/sql_states_and_messages/42I43.htm"/>
      <topic label="42I44 - Invalid index number"
             href="help/html/progguide/sql_states_and_messages/42I44.htm"/>
      <topic label="42I45 - Multiple index hints specified on table"
             href="help/html/progguide/sql_states_and_messages/42I45.htm"/>
      <topic label="42I46 - Unexpected end of statement"
             href="help/html/progguide/sql_states_and_messages/42I46.htm"/>
      <topic label="42I47 - Order by on array column"
             href="help/html/progguide/sql_states_and_messages/42I47.htm"/>
      <topic label="42I48 - Cannot compare array values with non-array values or array values of different depth"
             href="help/html/progguide/sql_states_and_messages/42I48.htm"/>
      <topic label="42I49 - Array values can only be compared for equality"
             href="help/html/progguide/sql_states_and_messages/42I49.htm"/>
      <topic label="42I50 - Invalid use of array value in expression"
             href="help/html/progguide/sql_states_and_messages/42I50.htm"/>
      <topic label="42I51 - Aggregate function applied to array column"
             href="help/html/progguide/sql_states_and_messages/42I51.htm"/>
      <topic label="42I52 - Result parameter defined on multi part combined column"
             href="help/html/progguide/sql_states_and_messages/42I52.htm"/>
      <topic label="42I56 - Subquery table selected for update"
             href="help/html/progguide/sql_states_and_messages/42I56.htm"/>
      <topic label="42I57 - Table selected for update in grouped query"
             href="help/html/progguide/sql_states_and_messages/42I57.htm"/>
      <topic label="42I58 - Statement exceeds maximum number of subqueries"
             href="help/html/progguide/sql_states_and_messages/42I58.htm"/>
      <topic label="42I60 - FROM clause not found where expected"
             href="help/html/progguide/sql_states_and_messages/42I60.htm"/>
      <topic label="42I61 - REFERS TO predicate in WHERE clause of DELETE statement"
             href="help/html/progguide/sql_states_and_messages/42I61.htm"/>
      <topic label="42I62 - REFERS TO predicate in WHERE clause of UPDATE statement"
             href="help/html/progguide/sql_states_and_messages/42I62.htm"/>
      <topic label="42I63 - Combined column used in SET clause"
             href="help/html/progguide/sql_states_and_messages/42I63.htm"/>
      <topic label="42I64 - Array column used in SET clause"
             href="help/html/progguide/sql_states_and_messages/42I64.htm"/>
      <topic label="42I65 - Table has child tables"
             href="help/html/progguide/sql_states_and_messages/42I65.htm"/>
      <topic label="42I66 - Table has a parent table that needs to be updated on delete"
             href="help/html/progguide/sql_states_and_messages/42I66.htm"/>
      <topic label="42I67 - Update on primary key column"
             href="help/html/progguide/sql_states_and_messages/42I67.htm"/>
      <topic label="42I68 - Update on foreign key column"
             href="help/html/progguide/sql_states_and_messages/42I68.htm"/>
      <topic label="42I70 - Reference FROM clause used with non-constant reference"
             href="help/html/progguide/sql_states_and_messages/42I70.htm"/>
      <topic label="42I71 - Queries in UNION have different number of result columns"
             href="help/html/progguide/sql_states_and_messages/42I71.htm"/>
      <topic label="42I72 - A query in a UNION cannot be a FOR UPDATE query"
             href="help/html/progguide/sql_states_and_messages/42I72.htm"/>
      <topic label="42I73 - Unexpected select target"
             href="help/html/progguide/sql_states_and_messages/42I73.htm"/>
      <topic label="42I74 - A RETRY clause cannot be used in a UNION query"
             href="help/html/progguide/sql_states_and_messages/42I74.htm"/>
      <topic label="42I75 - RETRY clause cannot be used in an ORDER BY clause that references a generic value expression"
             href="help/html/progguide/sql_states_and_messages/42I75.htm"/>
      <topic label="42I76 - Index hint specified on UNION query"
             href="help/html/progguide/sql_states_and_messages/42I76.htm"/>
      <topic label="42I77 - Invalid timestamp"
             href="help/html/progguide/sql_states_and_messages/42I77.htm"/>
      <topic label="42I78 - Invalid timestamp string"
             href="help/html/progguide/sql_states_and_messages/42I78.htm"/>
      <topic label="42I79 - Invalid company number"
             href="help/html/progguide/sql_states_and_messages/42I79.htm"/>
      <topic label="42I81 - Row value constructor in IS NULL"
             href="help/html/progguide/sql_states_and_messages/42I81.htm"/>
      <topic label="42I82 - Syntax conflicts with Parse mode"
             href="help/html/progguide/sql_states_and_messages/42I82.htm"/>
      <topic label="42I83 - RETRY clause not allowed in grouped query"
             href="help/html/progguide/sql_states_and_messages/42I83.htm"/>
      <topic label="42I84 - Invalid date literal"
             href="help/html/progguide/sql_states_and_messages/42I84.htm"/>
      <topic label="42I85 - Invalid CASE expression"
             href="help/html/progguide/sql_states_and_messages/42I85.htm"/>
      <topic label="42I86 - Invalid enum description"
             href="help/html/progguide/sql_states_and_messages/42I86.htm"/>
      <topic label="42I87 - Invalid text content function"
             href="help/html/progguide/sql_states_and_messages/42I87.htm"/>
      <topic label="42I89 - Invalid company number expression"
             href="help/html/progguide/sql_states_and_messages/42I89.htm"/>
      <topic label="42I90 - Invalid set function specification"
             href="help/html/progguide/sql_states_and_messages/42I90.htm"/>
      <topic label="42I91 - Invalid function argument value"
             href="help/html/progguide/sql_states_and_messages/42I91.htm"/>
      <topic label="42I92 - Invalid interval string"
             href="help/html/progguide/sql_states_and_messages/42I92.htm"/>
      <topic label="42I93 - Invalid SQL delete"
             href="help/html/progguide/sql_states_and_messages/42I93.htm"/>
      <topic label="42T01 - Incompatible types for comparison operator"
             href="help/html/progguide/sql_states_and_messages/42T01.htm"/>
      <topic label="42T02 - Incompatible types for BETWEEN"
             href="help/html/progguide/sql_states_and_messages/42T02.htm"/>
      <topic label="42T03 - Incompatible types for IN operator"
             href="help/html/progguide/sql_states_and_messages/42T03.htm"/>
      <topic label="42T05 - Invalid type for operand of LIKE operator"
             href="help/html/progguide/sql_states_and_messages/42T05.htm"/>
      <topic label="42T06 - Invalid type for operand of substring operator"
             href="help/html/progguide/sql_states_and_messages/42T06.htm"/>
      <topic label="42T07 - Invalid type for array index"
             href="help/html/progguide/sql_states_and_messages/42T07.htm"/>
      <topic label="42T08 - Incorrect operand types for operator"
             href="help/html/progguide/sql_states_and_messages/42T08.htm"/>
      <topic label="42T13 - Type conflict on parameter"
             href="help/html/progguide/sql_states_and_messages/42T13.htm"/>
      <topic label="42T20 - Invalid argument type for AVG/SUM function"
             href="help/html/progguide/sql_states_and_messages/42T20.htm"/>
      <topic label="42T21 - Incompatible types for UNION column"
             href="help/html/progguide/sql_states_and_messages/42T21.htm"/>
      <topic label="42T22 - Incompatible array depth for UNION column"
             href="help/html/progguide/sql_states_and_messages/42T22.htm"/>
      <topic label="42T23 - Incompatible types for INRANGE"
             href="help/html/progguide/sql_states_and_messages/42T23.htm"/>
      <topic label="42T30 - Invalid type for TRIM operand"
             href="help/html/progguide/sql_states_and_messages/42T30.htm"/>
      <topic label="42T31 - Invalid type for set function specification"
             href="help/html/progguide/sql_states_and_messages/42T31.htm"/>
      <topic label="42T32 - Invalid type for operand"
             href="help/html/progguide/sql_states_and_messages/42T32.htm"/>
      <topic label="HY010 - Function sequence error"
             href="help/html/progguide/sql_states_and_messages/HY010.htm"/>
   </topic>
   <topic label="SQL glossary"
          href="help/html/progguide/functions_database_handling/sql_glossary.htm"/>
</toc>