Problem:

Stored procedure closes and should receive a 466 sqlcode but receives a 0

Resolution:

This occurs because the declare cursor is defined with hold and should be defined with return.

Once this is changed the 466 sqlcode is received correctly.