The following worked for me:

? sqlprepare(gnhandle, 'select * from dual', 'temp') && no cursor is created yet. the return value is 1
? sqlexec(gnhandle) && cursor Temp is created and 1 record is returned. the return value is 1