Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to use cursors

  1. #1
    Join Date
    Apr 2007
    Posts
    12

    Default How to use cursors

    Hi,

    I have following problem:

    -> A Stored Procedure, which is declaring and fetching from a cursor. For every fetched row, there are some operations are being performed. Inside that cursor, we have another stored procedure call.

    Any can suggest on how to implement the cursor please. We are using SQL Server as database.


    Thanks in advance
    Santosh

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Explicit cursors not supported by any step. So you're out of luck there for the moment.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.