Well that wasn't so tough..
SQLEXEC(cxnhandle,sql,tempcursor)
CREATE CURSOR realcursor (;
field1 b,;
field2 c(254),;
field3 c(254)...)
INSERT INTO realcursor ;
SELECT field1,allt(field2),allt(field3)... ;
FROM tempcursor
This is my solution. Thanks again AndyKR.