topic Re: sql/mp error -8412 in HPE NonStop Compute

sql/mp error -8412

Hireme — Wed, 03 Jun 2026 17:41:09 GMT

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!

Re: sql/mp error -8412

Hireme — Tue, 09 Jun 2026 16:26:00 GMT

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.

Re: sql/mp error -8412

Thaufique_Mod — Wed, 10 Jun 2026 05:45:19 GMT

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.