Micro FocusĀ Enterprise DeveloperĀ 3.0 for Visual Studio 2017
>
Programming
>
Mainframe Programming
>
SQL Option for DB2
>
Reference
>
Error Messages
>
L - Link Error Messages
>
L150 - L199
L150 - L199
Lists the Link error messages from L150 through L199.
L150: The INSERT, DELETE or UPDATE object is a view and is not permitted.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -150, for information.
L151: Update is invalid because the descr of column name cannot be updated.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -151, for information.
L152: THE DROP clause CLAUSE IN THE ALTER STATEMENT IS INVALID BECAUSE constraint-name IS A constraint-type
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -152, for information.
L153: The CREATE VIEW statement does not include a required column list.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -153, for information.
L154: CREATE VIEW failed because definition with union, union all, or remote object.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -154, for information.
L156: The statement does not identify a table.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -156, for information.
L157: name is not the name of a table needed for a foreign key clause.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -157, for information.
L158: Number of columns specified for view is not equal to number of columns in select.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -158, for information.
L159: DROP or COMMENT ON token identifies a(n) token.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -159, for information.
L160: The WITH CHECK OPTION cannot be used for the specified view.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -160, for information.
L161: INSERT or UPDATE not allowed because result row does not satisfy view definition.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -161, for information.
L164: authid does not have privilege to create a view with qualification authorization.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -164, for information.
L170: The number of arguments specified for function is invalid.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -170, for information.
L171: The data type, length, or value of argument argument of function is invalid.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -171, for information.
L173: UR IS SPECIFIED ON THE WITH CLAUSE BUT THE CURSOR IS NOT READ-ONLY
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -173, for information.
L180: The string representation of a datetime value has invalid syntax.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -180, for information.
L181: The string representation of a datetime value is not a valid datetime value.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -181, for information.
L182: An arithmetic expression with a datetime value is invalid.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -182, for information.
L183: Arithmetic operation on date or timestamp has result not in valid range.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -183, for information.
L184: Arithmetic expression with a datetime value contains a parameter marker.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -184, for information.
L185: Local format option was used with date or time with no local exit.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -185, for information.
L186: Local date or time length was increased and the execute program uses old length.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -186, for information.
L187: Reference to a current date/time special register is invalid.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -187, for information.
L188: The string representation of a name is invalid.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -188, for information.
L189: CCSID ccsid is unknown or invalid for the data type or subtype.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -189, for information.
L190: ATTRIBUTES OF column-name IN table-name ARE NOT COMPATIBLE WITH EXISTING COLUMN
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -190, for information.
L191: A string cannot be used because it is invalid mixed data.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -191, for information.
L197: QUALIFIED NAMES IN ORDER BY NOT PERMITTED WITH UNION OR UNION ALL
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -197, for information.
L198: Operand of the PREPARE or EXECUTE IMMEDIATE statement is blank or empty.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -198, for information.
L199: Illegal use of keyword keyword. Token token was expected.
See the section Error SQLCODES in your IBM Database Messages and Codes manual, message -199, for information.
Parent topic:
L - Link Error Messages