Re: Dynamic SQL question

[Phil Groschwitz <sublime78ska@xxxxxxxxx>]

Mark,

Check out this manual:

http://publib.boulder.ibm.com/html/as400/v5r1/ic2924/info/sqlp/rbafymst100.htm#HDRCURSORTYPE

Basically it allows the program to do a fetch on a row
it has already fetched.

Phil

--- "M. Lazarus" <mlazarus@ttec.com> wrote:
> 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
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries
> (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/rpg400-l.
>


__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/