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