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