× 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 still have an RPGII program running at a client in Oklahoma. It reads a flat file they get from their bank every month, and passes that data into their application's check reconciliation file. It's really handy when one is several thousand checks every week. The program has been in use since the 20th century. 😊

I taught the accounting clerk how to modify the program when the bank modifies the layout of the data in the file.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Justin Taylor
Sent: Thursday, July 11, 2024 6:21 AM
To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: How has/will AI impacted the RPGLE community?

I heard Steve Will talking on the Incredible i Show. Converting RPG/36 and
RPG/38 to modern code is one of their goals. So I think it's safe to say that people probably still use primary and secondary files, and level breaks.




date: Wed, 10 Jul 2024 16:56:36 -0500
from: <tgarvey@xxxxxxxxxx>
subject: RE: How has/will AI impacted the RPGLE community?

I don't want to be one arguing for ChatGPT because I only saw it that
one time, and don't use it. Frankly don't want it on my PC.
But, so it's not comprehensive yet. Is anyone still using matching
records and level breaks, or primary and secondary files? Or even
native files at all? Certainly not in new development or even support if you can avoid it.
Using those techniques might serve as a good argument for redevelopment.

It seemed to me that IBM's effort now (as one takeaway from this
morning's
webinar) is to train it properly. They noted that it learns best by
using 'pairs' so it can compare one method to another.

Maybe I should wait until we can see the recording again.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
DEnglander--- via MIDRANGE-L
Sent: Wednesday, July 10, 2024 4:28 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: DEnglander@xxxxxxxxxxxxxxx
Subject: Re: How has/will AI impacted the RPGLE community?

Buck,

"One might say this is obscure, but who among us will be asking
ChatGPT to explain Z-ADD?"

Ask it to explain primary and secondary files with matching records
and level breaks. I'm curious on that response. ;-)

Doug


"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the
attachments accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended
recipient. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution or the taking of
any action in reliance on the contents of the information is strictly
prohibited. Any unauthorized interception of this transmission is
illegal under the law. If you have received this transmission in
error, please promptly notify the sender by reply e-mail, and then
destroy all copies of the transmission."
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.



------------------------------

message: 4
date: Wed, 10 Jul 2024 17:10:45 -0500
from: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
subject: Re: HTTPAPI: can anybody point me in the direction of docs or
a good example for http_url_post_raw2

That was 12 years ago.? You can't expect me to remember what exactly
was going on that long ago, and remember all the quirks, etc.. that's
asking a lot.

Essentially, you've created your own fork of HTTPAPI, so it's really
up to you to maintain it.

http_url_post_raw2() isn't really difficult to use. ? You pass it a
procedure address and data length in the parameters.? When retrieving
the data to send, it's going to call a subprocedure with parameters
and return value like this:

dcl-prmyProc int(10);
fd int(10) value;
data char(32767) options(*varsize);
size int(10) value;
end-pr;

It will call that procedure in a loop to get data to send.? You should
code the procedure to read the next chunk of data to send and put it
in the 'data' parameter. The data should be no longer than the 'size'
that it sends you. The return value should be the length of the chunk
of data you provided.

It will call it in a loop, and each time you provide the next chunk of
data until it has sent as many bytes as you originally specified in
the length parameter on the http_url_post_raw2() call.? The call is
made as the data is being sent over the network, so it allows you to
send data without it all needing to be loaded into one big buffer
beforehand (thus keeping the memory footprint smaller.)

On 7/9/2024 4:07 PM, James H. H. Lampert via MIDRANGE-L wrote:
On 7/9/24 1:43 PM, Scott Klement wrote:
Please don't use that routine for new applications, instead use
http_req.

That does not exist in even the standard 2012 version. And there are
things that *do* exist in that version, that don't exist in the
customized 2012 version, because they were never needed.

--
JHHL


------------------------------

message: 5
date: Wed, 10 Jul 2024 18:20:03 -0400
from: a4g atl <a4ginatl2@xxxxxxxxx>
subject: Can one do a RUNSQL command with VALUES?

I need to do the following. Can it be done?

chgvar &wSqlCmd value('VALUES SYSTOOLS.GENERATE_SPREADSHEET('
+

*tcat 'PATH_NAME => ' +

*bcat '''/tmp/FLT855''' +

*tcat ',' +

*bcat 'SPREADSHEET_QUERY => ' +

*bcat '''select * from dppdata.flt855p2''' +

*tcat ',' +

*bcat 'SPREADSHEET_TYPE => ''xlsx'',' +

*bcat 'COLUMN_HEADINGS => ''LABEL'' )')

RUNSQL SQL(&wsqlcmd) COMMIT(*NONE) NAMING(*SQL)



chgvar &wSqlCmd value('VALUES SYSTOOLS.SEND_EMAIL(' +

*tcat 'TO_EMAIL => ''dfreinkel@xxxxxxxxxxxxxxxxxx'','
+

*bcat 'SUBJECT => ''Regenerated FLT855 as requested
''' +

*bcat 'concat (select host_name from
sysibmadm.env_sys_info),' +

*bcat 'BODY => ''Time extracted ''' +

*bcat 'concat current timestamp,' +

*bcat 'ATTACHMENT => ''/tmp/FLT855.xlsx'' )' )

RUNSQL SQL(&wsqlcmd) COMMIT(*NONE) NAMING(*SQL)



Can this be done?


Thank you.

Darryl Freinkel


------------------------------

message: 6
date: Wed, 10 Jul 2024 15:20:21 -0700
from: VERNON HAMBERG Owner via MIDRANGE-L
<midrange-l@xxxxxxxxxxxxxxxxxx>
subject: Re: How has/will AI impacted the RPGLE community?

I don't think IBM is trying to get AI to generate RPG II code. This
raises the issue of what is the content being used to train the AI
app. This is based on a very brief presentation other than what all these folks saw.

Cheers
Vern


On Wed, 10 Jul, 2024 at 4:28 PM, DEnglander--- via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:


To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: DEnglander@xxxxxxxxxxxxxxx
Buck,

"One might say this is obscure, but who among us will be asking
ChatGPT to explain Z-ADD?"

Ask it to explain primary and secondary files with matching records
and level breaks. I'm curious on that response. ;-)

Doug


"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the
attachments accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended
recipient. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution or the taking of
any action in reliance on the contents of the information is strictly
prohibited. Any unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly
notify the sender by reply e-mail, and then destroy all copies of the transmission."
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:
MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:
support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

.

------------------------------

message: 7
date: Wed, 10 Jul 2024 17:26:28 -0500
from: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
subject: Re: How has/will AI impacted the RPGLE community?

I think Jon is saying that there's no value to IBM in converting RPG
to another language.

Their goal is to make AI to help you write your RPG code, not to
convert you away from their products.

On 7/10/2024 4:09 PM, tgarvey@xxxxxxxxxx wrote:
Yes, I saw your name listed in the presentation, along with others.
Seems like you're not too optimistic then?

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf
Of
Jon Paris
Sent: Wednesday, July 10, 2024 3:31 PM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx

Subject: Re: How has/will AI impacted the RPGLE community?

Yes, I know. I'm a member of the initial "outsiders" group involved
in
the project.


Jon P.

On Jul 10, 2024, at 4:18?PM, <tgarvey@xxxxxxxxxx>
<tgarvey@xxxxxxxxxx>
wrote:

Seems like IBM is moving forward with attempting to use AI in
support
of RPGLE. They're specifically using some 'tool' named Granite that
they are trying to 'teach' RPGLE and SQL. They are even arranging for
organizations to send them code to use for 'teaching' this tool, with
presumed restrictions on who gets to see the code, etc.
They want it to be able to 'read' RPGLE code and give an English
textual description of what the code actually does. They have already
been able to give it general instructions like 'based on this SQL
database definition, write a maintenance program'. They have other plans too.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf
Of Jon Paris
Sent: Wednesday, July 10, 2024 2:42 PM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How has/will AI impacted the RPGLE community?

If it is ever done it won't be by IBM. No mileage in it for them,


Jon P.

On Jul 10, 2024, at 3:28?PM, <tgarvey@xxxxxxxxxx>
<tgarvey@xxxxxxxxxx>
wrote:

Hello, everyone,



Just attended the IBM AI Strategy and Update webinar and thought I
might stimulate some discussion.



Seems like a year ago or so when I attended a webinar of a
software vendor who introduced how they were integrating AI into their product.
The demonstration included use of ChatGPT (I think) in which the
tool was told that it understood RPGLE code and a request was made
of the tool to write an RPGLE procedure to perform some minimal
mathematic function. It responded with a clean RPGLE procedure to
do that, and it was compiled and tested. Then the RPGLE source was
modified to be incorrect and the tool was asked to verify the
function source code was correct. The tool found the mistake and
pointed out the source
code error and suggested a correction.

I was impressed.



Now I'm wondering if ChatGPT has been improved enough to do
something
like:

Given source code for a simple RPGLE green screen entry panel,
convert that code to Visual Basic.



It's exciting to see the direction IBM is going, based on today's
webinar, but I'm wondering how we might be eventually impacted by
these developments?



Any thoughts, opinions? Anybody seen ChatGPT convert RPGLE to VB?



Kind Regards,



Thomas Garvey



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.




------------------------------

Subject: Digest Footer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.



------------------------------

End of MIDRANGE-L Digest, Vol 23, Issue 576
*******************************************

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.



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.