RE: Embedded SQL question

Also with all the different development techniques in use today....F
spec search alone is meaningless when checking for file usage.

Especially if lots of embedded SQL is in place....  


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces+tommy.holden=hcahealthcare.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+tommy.holden=hcahealthcare.com@xxxxxxxxxxxx] On
Behalf Of rick baird
Sent: Monday, September 19, 2005 10:58 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Embedded SQL question

Mike,

the NC clause is much like"  SET OPTION COMMIT = *NONE

NC meens 'no commitment control'

if you're going to leave in the F spec, make it USROPN so that it won't
waste time opening it.

if the compiler balks at never opening the file, put something like:

if    1 <> 1
open filename
close filename
end

as always, comment the code as to not confuse the next poor shlub that
comes along to figure it out.

hth, 

Rick

On 9/19/05, Michael Jacobsen <MJacobsen@xxxxxxxxxxxxxxxx> wrote:
> Rick,
> 
> Thanks for the help!  Adding "With NC" fixed the problem.   Now I'm
going
> to go look into that more so I understand what it means!  :)
> 
> It never occurred to me to remove the F spec.  Of course if I ever 
> wrote a larger program with embedded SQL, I can see how leaving out 
> the f-spec could cause some problems.  I can imagine another 
> programmer looking only at the F-Specs to ensure no files get updated
before running it.
> 
> 
> Thanks!
> 
> Mike
> 
> 
> rpg400-l-bounces@xxxxxxxxxxxx wrote on 09/19/2005 10:36:02 AM:
> 
> > btw, don't know if that's your problem.
> >
> > if it still doesn't work, try adding WITH NC as the last predicate 
> > of your sql statement.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
> list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, 
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a 
> moment to review the archives at http://archive.midrange.com/rpg400-l.
> 
>

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.