Return
-
Title
Error using Load command to load cursor: ERROR [42601] [IBM][DB2/AIX64] SQL0104N -
Description
Following error occurs when using LOAD FROM ... OF CURSOR command in Editor to load a cursor:
Load From C1 of Cursor Replace into <tablename>
statistics yes and indexes all nonrecoverable lock with force;"ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token "load" was found following "".
Expected tokens may include: "<psm_loop>". SQLSTATE=42601 -
Cause
The Editor with the CLP option has not been selected -
Resolution
WORKAROUND:
When running a LOAD FROM .... CURSOR, use CLP option