IBM Mainframe Forum

can anyone tell me is it mandatory to move initial values to host variables before declaring the cursor, why because am getting sqlcode 100 if value is not moved before declaration.

Hello,

It is mandantory to initialize the host variables used in the predicates of the cursor query before opening the cursor.

As the DECLARE is often done in working-storage, no, there is no requirement to initialize before the declare.