Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DYNAMIC RESULT SETS

Status
Not open for further replies.
diggermf

diggermf

Programmer
Jun 16, 2008
20
US
Hi All,

In one of the stored procedures, we have a statement as "DYNAMIC RESULT SETS 1" .

Could some one please let me know what this indicates about? and

how DYNAMIC is useful.

Its SUN Solaris - UDB
 
Sort by date Sort by votes
It's your output. This procudure will (optionally) return 1 "table"/"result set" as output.

And yes, very usefull. Look in the source of the procedure and see what it returnes to you.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ColeFern
  • Locked
  • Question
SQL1224N A database agent could not be started to service a request, or was terminated as a result
Replies
0
Views
136
ColeFern
ColeFern
Prince26
  • Locked
  • Question
Pagination - Limiting search results
Replies
4
Views
88
Prince26
Prince26
johnherman
  • Locked
  • Question
Dynamic SQL within cursor DB2
Replies
0
Views
65
johnherman
johnherman
eaglei22
  • Locked
  • Question
DB2 Update coolumn based off of results from join?
Replies
1
Views
110
eaglei22
eaglei22
bibulous
  • Locked
  • Question
Concatenate multiple cursor results Into one row using SPUFI
Replies
0
Views
100
bibulous
bibulous

Part and Inventory Search

Sponsor

Back
Top