Re: STORED PROCEDURE CONTROL
Within an SP, you treat the EXECUTE PROCEDURE statement as if it was a
SELECT statement, using the implicit FETCH which is part of the FOREACHloop to retrieve each record in turn.
In ESQL/C (or other external-to-database program), you treat the EXEC PROC
like a SELECT statement, declaring a cursor for it, etc.
Yours,
Jonathan Leffler (johnl@informix.com) #include <witticism.h>
}From informix-list-owner@rmy.emory.edu Thu Dec 19 19:48 PST 1996
}From: rnath@wrbc.com
}Subject: STORED PROCEDURE CONTROL
}Date: Fri, 20 Dec 1996 01:39:36 GMT
}To: informix-list@rmy.emory.edu
}X-Informix-List-To: johnl@informix.com
}X-Informix-List-Id: <news.31872>
}
}I am trying to write a stored procedure that will return multiple rows
}of data to either a program (delphi) or another stored procedure.
}With this multiple return I need to use the FOREACH functionality
}along with 'WITH RESUME'. What is the controlling mechanism to get
}another record. In other words does it act like a cursor with get
}next type capabilities etc. Thank you in advance for your help with
}this issue.
}
}Rick Nath
}rnath@wrbc.com
}rnath@dakota.net
}
}