Process Request (QmyProcessRequest) API

The Process Request (QmyProcessRequest) API is used to notify the storage engine that a request is pending.

Authorities and Locks

QMYSE authority

*USE

API Public Authority

*USE

Required Parameter Group

Return Code

OUTPUT; BINARY(4)

The return code from processing the request. Possible values are:

Code	Reason
0	Successful.
2016	Thread ID cannot be used.
2021	Refer to error message in joblog.
2022	Unlock SQL synchronization token failed during close.
2023	Invalid object lock operation.
2024	Invalid savepoint operation.
2025	Partial key used against ICU sort sequence.
2026	Could not retrieve sort key.
2027	Could not convert sort sequence.
2028	Invalid sort sequence used.
2029	Invalid parent table for constraint.
2030	Could not extract table information.
2031	Could not extract parent table information.
2032	Invalid commitment control operation.
2033	Invalid commit level specified on open.
2034	Invalid object handle specified.
2035	The constraint space was not large enough.
2036	Invalid return data option.
2037	Invalid read orientation.
2038	Read blocking requested for orientation that does not support blocking.
2039	Invalid commitment control level requested.
2040	Unlock SQL synchronization token failed during allocate share.
2041	Space too small for row format to be returned.
2042	XA request unsupported.
2043	SQL server job was ended externally.
2044	Unlock SQL synchronization token failed during SQL execute immediate.
2045	Unlock SQL synchronization token failed during SQL prepare/open cursor.
2046	Invalid CCSID specified.
2047	Open attempted against SQL cursor.
2048	No associated EBCDIC CCSID.
2049	Unable to convert SQL statement.
2050	Unable to unlock MY synchronization token.
2051	Unable to destroy MY synchronization token.
2052	Unable to lock MY synchronization token.
2053	Unable to recreate MY synchronization token.
2054	Invalid constraint space handle.
2055	Delete attempted against SQL cursor.
2056	Storage engine interface cannot be used within job using other SQL interfaces.
2057	Object instance not opened for delete.
2058	Object init attempted against SQL cursor.
2059	Override attempted against SQL cursor.
2060	Invalid override space handle.
2061	Info attempted against SQL cursor.
2062	Lock attempted against SQL cursor or object share handle.
2063	Optimize attempted against SQL cursor.
2064	Invalid read data space handle.
2065	Invalid relative row space handle.
2066	Invalid key space handle.
2067	Describe range attempted against SQL cursor.
2068	Invalid describe range space handle.
2069	Release row attempted against SQL cursor.
2070	Invalid statement space handle.
2071	Invalid statement space handle.
2072	Update attempted against SQL cursor.
2073	Table not opened when I/O attempted.
2074	Object instance not open for update.
2075	Invalid update space handle.
2076	Write attempted against SQL cursor.
2077	Invalid write space handle.
2078	Unknown storage engine request.
2079	Invalid share definition space handle.
2080	Invalid share handle space handle.
2081	Invalid in use space handle.
2082	Invalid rows per key space handle.
2083	Invalid LOB space handle.
2084	LOB space too small for request.
2085	Invalid SQL server job request.
2086	Unable to initialize SQL.
2088	Unable to lock SQL server job synchronization token.
2089	Unable to unlock SQL server job synchronization token.
2090	Relational database not found.
2091	Failure creating SQL server job synchronization token.
2094	Unable to unlock SQL server job synchronization token.
2095	Unable to connect to SQL server job.
2096	Maximum SQL server jobs started.
2101	Block full for read request.
2102	Table definition may have changed underneath storage engine.
2103	Could not give asynchronous pipe descriptor.
2104	There are pending object locks on the object instance.
2105	Object instance was not locked and thus could not be unlocked.
2106	Could not send request to SQL server job.
2107	Could not receive reply from SQL server job.
2108	Identity value exceeded.
2109	Could not close asynchronous pipe descriptor.
2110	Could not take asynchronous pipe descriptor.
2111	Could not write to asynchronous pipe descriptor.
2112	Asynchronous read was interrupted.
2113	No prior pipe descriptor to be reused.
2116	Row not found.
2117	Duplicate key found.
2118	End of table encountered.
2119	Lock request timed out.
2120	Foreign key constraint violation.
2121	Object not found.
2122	Unknown read error.
2123	Create index failed due to duplicate key.

[ Back to top | Database APIs | APIs by category ]