|
-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Luis Rodriguez
Envoyé : jeudi 16 septembre 2010 20:32
À : Midrange Systems Technical Discussion
Objet : Re: Can I replace RPG with SQL?
David,
Maybe you could insert the UPDATE part of Charles's code in a
"BEFORE INSET"
trigger...
Regards,
Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--
On Thu, Sep 16, 2010 at 12:22 PM, Charles Wilt
<charles.wilt@xxxxxxxxx>wrote:
Good catch...guess I shouldn't answre posts quickly beforeleaving for
lunch! :)ClientVersion) (select
how about:
update ClientTable A
set ClientVersion = (select max(CilentVersion) + 1
from ClientTable B
where a.clientID = b.clientID) where
clientID in (select clientID from NewClientTable);
insert into ClientTable (ClientID, ClientName,
ClientID, ClientName, 0 from NewClientTable);table. Odd
Charles
On Thu, Sep 16, 2010 at 11:39 AM, Morgan, Paul
<Paul.Morgan@xxxxxxxxxxx>
wrote:
Charles,ClientVersion = 0 and the ClientID is in the transaction
He wants to set ClientVersion to 1 + Max(Clientversion) when
but that's what he wants. Your Update bumps up the clientversion in
all the records.client file
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Paul
Principal Programmer Analyst
IS Supply Chain/Replenishment
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
Sent: Thursday, September 16, 2010 11:28 AMwrote:
To: Midrange Systems Technical Discussion
Subject: Re: Can I replace RPG with SQL?
Assuming ClientID is unique in both tables....
update ClientTable
set ClientVersion = ClientVersion + 1 where clientID in (select
clientID from NewClientTable);
insert into ClientTable (ClientID, ClientName, ClientVersion)
(select ClientID, ClientName, 0 from NewClientTable);
HTH,
Charles
On Thu, Sep 16, 2010 at 9:44 AM, David FOXWELL
<David.FOXWELL@xxxxxxxxx>
maybe.....I don't think this is easy enough to make it worthwile with sql,
but,
clientId 15 becomes 'Smith'. But I can't just update the
Here's my client file that I want to update :
ClientId ClientName ClientVersion
15 Bigs 0
I receive a file containing clientId and the new name of the
client, eg,
from this work file. I need to archive the original name, so I havefew thousand
this kind of representation after the update :
updated to n+1 and a new line is written to the file. So, in the
ClientId ClientName ClientVersion
15 Smith 0
15 Bigs 1
There's a timestamp field among the other fields. Version 0 is
always
example, I've updated the line Bigs and I've written the line Smith.
now to 'Eggs', I want to see :
So, version 0 is the current version and 1 is the old one. If I
change
ClientId ClientName ClientVersion
15 Eggs 0
15 Bigs 1
15 Smith 2
I ask because I get this request now and again, for a
clients at a time. I'm having to use an RPG to write to the clientfor that RPG.
file, but I always end up using SQL to prepare a work file
(MIDRANGE-L) mailinglist
Thanks.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
listTo post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,--
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,list
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,--
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please
take a moment to review the archives at
http://archive.midrange.com/midrange-l.
This is the Midrange Systems Technical Discussion
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,please take
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
a moment to review the archives at--
http://archive.midrange.com/midrange-l.
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-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.