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 Chriss Miller 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
Joined
Jun 16, 2008
Messages
20
Location
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 Question
SQL1224N A database agent could not be started to service a request, or was terminated as a result
Replies
0
Views
574
ColeFern
ColeFern
Prince26
  • Locked
  • Question Question
Pagination - Limiting search results
Replies
4
Views
382
Prince26
Prince26
johnherman
  • Locked
  • Question Question
Dynamic SQL within cursor DB2
Replies
0
Views
223
johnherman
johnherman
eaglei22
  • Locked
  • Question Question
DB2 Update coolumn based off of results from join?
Replies
1
Views
403
eaglei22
eaglei22
bibulous
  • Locked
  • Question Question
Concatenate multiple cursor results Into one row using SPUFI
Replies
0
Views
285
bibulous
bibulous

Part and Inventory Search

Sponsor

Back
Top