Re: Embedded SQL, sub-procedures and activation groups

From: Kent Milligan <kmill@xxxxxxxxxxxxxxxx>
Date: Tue, 27 Sep 2005 12:36:02 -0500

Jonathan Ball wrote:

Kent Milligan wrote:

CLOSQLCSR(*ENDMOD) only works if the program is the last program with SQL in the
call stack.

As far as I know, it is.

I also found that compiling the program with actgrp(*new) results in
the cursor being closed when the program ends.  My exposure to ILE
suggests that this causes more overhead to be incurred when the program
is called, but the program isn't called frequently anyway, and probably
only by a few users.

Can you suggest anything else?

Thanks in advance.

The other job could use the ALCOBJ command on the file and specify CONFLICT(*RQSRLS)


--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
kmill@xxxxxxxxxxxxxxxx (spam trick)   GO HAWKEYES!!
>>> www.iseries.ibm.com/db2
(opinions stated are not necessarily those of my employer)
.

References:
- Embedded SQL, sub-procedures and activation groups
  - From: Jonathan Ball
- Re: Embedded SQL, sub-procedures and activation groups
  - From: Bradley V. Stone
- Re: Embedded SQL, sub-procedures and activation groups
  - From: Jonathan Ball
- Re: Embedded SQL, sub-procedures and activation groups
  - From: Kent Milligan
- Re: Embedded SQL, sub-procedures and activation groups
  - From: Jonathan Ball

Prev by Date: Re: Sending variable length files via FTP
Next by Date: Old QUSRSYS library restored on new system ....! Help
Previous by thread: Re: Embedded SQL, sub-procedures and activation groups
Next by thread: Re: Embedded SQL, sub-procedures and activation groups
Index(es):
- Date
- Thread

Relevant Pages

Re: SP Question
... less overhead than a cursor. ... > Hi, Hari ... >> First record you can retrive using TOP clause in select statement. ... You need to use cursor with FETCH LAST. ...
(microsoft.public.sqlserver.server)
Re: Rational for not making cursor tagged in Containers
... However, when it comes to Containers, I can not use this notation ... on cursor because it is not tagged. ... And yet, overhead was already paid. ...
(comp.lang.ada)
Re: Is Copying multiple tables possible without cursors?
... > Would this be more overhead than a cursor, since it would have to do that ... > select in each pass through loop to get the current parent to be copied. ... can't think of anything you could do with a cursor that would improve upon ... Then you can use my first suggestion: two INSERT statements instead of a ...
(microsoft.public.sqlserver.programming)
Re: Set based solution
... it has more overhead. ... > certain situations where the cursor out performs but again....it is about ... > this loop, i will promise you the loop performs and handles better. ... temp table. ...
(microsoft.public.sqlserver.programming)