×
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'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
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.
midrange.com
