× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I agree, or just get rid of the SQL stuff.

Michael Schutte
Work 614-492-7419
email  michael_schutte@xxxxxxxxxxxx


                                                                           
             "Holden Tommy"                                                
             <Tommy.Holden@hca                                             
             healthcare.com>                                            To 
             Sent by:                  "RPG programming on the AS400 /     
             rpg400-l-bounces@         iSeries" <rpg400-l@xxxxxxxxxxxx>    
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             03/30/2006 03:18          RE: SQL Update in RPGLE.            
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




Hehe then why have an F spec....just do this:

     C/EXEC SQL
     C+ UPDATE TESTING/CUST SET CUSSTA = 'TX'
     C+ WHERE CUSSTA = 'TN' with nc
     C/END-EXEC
      /free
       *inlr = *on;
      /end-free

That's the whole program....

Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Michael_Schutte@xxxxxxxxxxxx
Sent: Thursday, March 30, 2006 2:11 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: SQL Update in RPGLE.

Everyone, please look again, this isn't a commitment issue,  He already
has
a LOCK on the record when he does the read.  So the Update will not work
when there is already a lock on the file.  James, see my previous email.

Michael Schutte
Work 614-492-7419
email  michael_schutte@xxxxxxxxxxxx




             FrankKany@unipres

             .com

             Sent by:
To
             rpg400-l-bounces@         RPG programming on the AS400 /

             midrange.com              iSeries <rpg400-l@xxxxxxxxxxxx>


cc


             03/30/2006 03:07
Subject
             PM                        Re: SQL Update in RPGLE.





             Please respond to

              RPG programming

              on the AS400 /

                  iSeries

             <rpg400-l@midrang

                  e.com>









Give this a try, put this portion of code in your *INZSR:(pulled from
this
list)
C/EXEC SQL
C+ Set Option
C+     Naming    = *Sys,
C+     Commit    = *None,
C+     UsrPrf    = *User,
C+     DynUsrPrf = *User,
C+     Datfmt    = *iso,
C+     CloSqlCsr = *EndMod,
C+     Commit    = *NONE
C/END-EXEC

Compile your program with COMMIT(*NONE).

I hope this helps.

Frank W. Kany IV
Senior Programmer/Analyst
Unipres USA, Inc.
http://www.unipres.com

"Work to LIVE, not live to work."



"Mike Troxclaire" <mike_troxclaire@xxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
03/30/2006 01:58 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Subject
SQL Update in RPGLE.






Pros,

I am trying to execute this simple update statement. The program
compiles
and it runs and gives the dsply message but the file is not updated. Am
I
doing something wrong here? I would really appreciate it if somebody can
point me in the right direction.

=============================================================
     FCUST      UF   E             DISK    RENAME(CUSTR:CSREC)

      /FREE
       DoW not  %eof(CUST);
         Read CUST;
         If not %eof(CUST);
           Exsr UpdateCSREC;
         EndIf;
       EndDo;
       dsply 'UPDATE SUCCESSFUL';
      /END-FREE



      /FREE
       BegSR UpdateCSREC;
      /END-FREE


     C/EXEC SQL
     C+ UPDATE TESTING/CUST SET CUSSTA = 'TX'
     C+ WHERE CUSSTA = 'TN'
     C/END-EXEC
      /FREE
       *inlr = *on;
       EndSR;


      /END-FREE
=============================================================

Cheers,

Mike.

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
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.


--
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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.