Re: ProC Dynamic SQL method 4 question

In article <1995Jan11.124718.18226_at_rsv.svskt.se>, larkar_at_u30005.rsv.svskt.se (Lars Karlsson) writes:
|> Hello!
|>
|> I am constructning a program that uses ProC dynamic sql method
|> 4 and I have one problem with this.
|> When I do the FETCH, how can I recognise how many rows the query
|> will give back after the first row. Is there someway I can get this
|> information? Is it possible to use a array with method 4?
|> My problem is that I have to now if the query will return more than
|> 500 rows. If it dont then I have to process each row but if more than
|> 500 rows then I should not do anything.
|>
|> Please help me!
|>
What's magic about 500? If you're worried about an array fetch and your array size, don't. It works like alot like a regular fetch return n rows (array size) until the number of rows returned is < n. Otherwise, you could do a count first (not necessarily efficient but effective).

--

Russ