RE: SQL question

Hi Jack,

While I don't pretend to understand exactly what this SQL is doing (the semantics, if you like), I can tell you that whse100 is being used in 3 ways, and apart from correlation ids I'm not sure how else you would distinguish between the roles:

being updated as itself (no correlation id)
as the 1st file in the subselect (e945)
as the 2nd join file in the subselect (e997)

Maybe the correlation ids (e945, e997) mean something "in the system", hopefully somewhere other than inside the original coder's head.

Regards,

Kevin Wright

LongReach - <http://www.lansa.com/longreach/> Share Files and Folders between IBM i Servers and iPhones/iPads <http://www.lansa.com/longreach/> - Download it for FREE today <http://www.lansa.com/longreach/> from the App Store <http://www.lansa.com/longreach/>

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Jack Tucky
Sent: Wednesday, 8 February 2012 4:15 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL question


Like I said I don't use embedded SQL much.

Is this code par for the course? Why name an alias? To save
keystrokes?

Do embedded SQL dudes not normally put in comments? At least
tell me what
they are trying to do?

Jack

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
paultherrien@xxxxxxxxxxxxxxxxxx
Sent: Tuesday, February 07, 2012 8:42 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL question

E997 is the alias name he assigned for file whsel00.

"left join whsel00 e997"

So e997.snd is field snd in whsel00.

left join whsel00 e997
Paul Therrien
Andeco Software, LLC
2233 St. Charles Ave
# 704
New Orleans, LA 70130
225-229-2491
paultherrien@xxxxxxxxxxxxxxxxxx
www.andecosoftware.com

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jack Tucky
Sent: Tuesday, February 07, 2012 6:09 PM
To: 'Midrange Systems Technical Discussion'
Subject: SQL question

I'm trying to figure out a program with no documentation and
I haven't used
embedded SQL.



Given this code snippet from an SQLRPGLE source, can you tell me where
e997.snd is coming from? I also can't find e945.logid. Is
there a way to
determine from the compile listing?



I can't find a file on the system that contains 997 in the name.



exec sql

update whsel00

set aux6='ALERT NOW'

where logid in (

select e945.logid from whsel00 e945

left join whssd00 sd on sdmanbl#=cast(substring(e945.aux1,9,8) as

decimal(8,0)) and sdinvoice =e945.aux2

left join whsel00 e997 on cast(e945.gsctl as char(30))= e997.aux2

and e997.snd='CUST' and e997.doc='997'



Thanks,

Jack





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