Insufficient memory for OPENXML query

Error constant SQLE_XQUERY_MEMORY_ERROR
ODBC 2 State ERROR
ODBC 3 State ERROR
Severity 17
SQLCODE –912
SQLSTATE WX016
Sybase error code 13572
Probable cause

The memory used by an OPENXML query may be proportional to the maximum distance between elements or attributes returned by a single row. For example, a query where some row uses the value from both the first and last element in the document may use memory proportional to the size of the document. One solution is to increase the cache size. Another is to break a query that refers to distant elements into several queries that refer to nearby elements and join the results.