sql/mp error -8412

[Hireme]

I get a sqlcode -8412 on a FETCH in a COBOL program.  Manual is not a help; manual says there is a type incompatability.
I define a cursor to select all columns.  I use an INVOKE AS statement to create a buffer for retrieved rows.  I use a FETCH INTO operation.  The OPEN is successful.  The FETCH fails on the first execution.

I used an INVOKE statement (with some editing, of course) to create both the SELECT list of columns and the buffer into which the FETCH will deposit each row. 

I don't see what is wrong.

Any thoughts to send my way?

Thanks!

[Hireme · Accepted solution]

Problem resolved. I experimented and found the following:  I used the group level expecting that each column would be moved into each field.  SQL doesn't work that way, I discovered.  Each column must be identified in a FETCH.

[Thaufique_Mod]

Hello @Hireme,

Thanks for posting in HPE Community.

We are glad to know that the issue is resolved, thanks for sharing the solution with community.