Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
I am creating a stored procedure (in IDS 9.40) which among other
others has a SELECT query. The flow of the procedure depends on the
number of results returned by the query.
Also the query populates some variables so I have to run a query and
not a count query.
Is there any way to get the number of results returned without having
to run a second query with a count in it?
Thank you,
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.