Re: Dynamic SQL question

Phil,

  What does "DYNAMIC SCROLL CURSOR" do (as opposed to a regular prepare) in
the PREPARE statement?

  -mark

At 3/19/02 11:21 AM, you wrote:
      P SQL_PrpStmt     b
       /FREE
        SQLStmt =
            'select * from prmorg +
            where companyNumber = ' + %editc(cpy:'X') +
            ' order by companyNumber, organizationName';

       /END-FREE
      C/exec sql
      C+ PREPARE @SELECT FROM :SQLStmt
      C/end-exec
      C
      C/exec sql
      C+ DECLARE @CURSOR DYNAMIC SCROLL CURSOR FOR @SELECT
      C/end-exec
      C
      C/exec sql
      C+ open @cursor
      C/end-exec
      P SQL_PrpStmt     e