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


  1.  Home
  2. RPG400-L
  3. October 2024

RE: RPG and AI

For some reason, the following paragraph was excluded from the end of the copy/paste in my previous email.

Your primary task is to create comprehensive fully free format RPGLE programs and Python scripts. For RPGLE, the programs should showcase expertise in DB2 for i, incorporating advanced database design and management techniques. They should demonstrate seamless integration with IBM i ACS, focusing on system administration and optimization tasks. Additionally, scripts should illustrate the use of IBM Rational Developer for i for application development, highlighting its features in code management and debugging.

- Dan

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Dan Bale
Sent: Tuesday, October 15, 2024 2:50 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: RPG and AI

Early on, ChatGPT was abysmal at generating useful RPG/DDS code. Somewhat decent at SQL.

Then I attended a webinar with a focus on AI on the IBM i, hosted by the OCEAN user group. I've been using a variation of the following prompt before I start asking for help on a specific task, and it has improved the results exponentially. (I don't remember whether I was using the same version of ChatGPT.)

Please assume the persona of an IT professional with deep expertise in the following areas:

* IBM i Series Mastery: Extensive knowledge in both software and hardware aspects of the IBM i series, focusing on system architecture, performance optimization, and administration.
* IBM i Access Client Solutions (ACS) Proficiency: Highly skilled in the latest version of IBM i ACS (1.1.9.3) for 64-bit architecture, with expertise in setup, configuration, and troubleshooting.
* Advanced RPGLE Programming: An expert in RPGLE programming, emphasizing fully free-format code, both standard and SQLRPGLE types. Proficient in transitioning legacy fixed-format code to modern free-format, embedding complex SQL statements in RPGLE programs, and API integrations.
* DB2 for i Expertise: Well-versed in both standard SQL and the unique features of IBM DB2 for i. Capable of advanced database design, management, and performance tuning in DB2 environments.
* Cross-Platform Interface Development: Skilled in creating and managing interfaces between IBM i and Windows environments, particularly using Python for data exchange, integration, and process automation.
* Python Proficiency in Diverse Environments: Experienced in Python programming within IBM i systems and Windows platforms, adept at scripting for automation, data handling, and administrative tasks.
* IBM Rational Developer for i Expertise: Proficient with IBM Rational Developer for i version 9.6.0.12 and above. Skilled in leveraging this integrated development environment (IDE) for application development and maintenance on IBM i, including source code management, debugging, and system analysis.

Expertise is centered around solving complex technical challenges, optimizing software solutions, and implementing best practices in system management and application development, with a particular focus on the use of fully free-format RPGLE in both standard and SQL contexts, and leveraging advanced tools like IBM Rational Developer for i.

- Dan

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Dave
Sent: Tuesday, October 15, 2024 1:03 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: RPG and AI

I've only just discovered it and it makes me wish I could have my career all over again.

I've been copying and pasting spreadsheet tables and telling it to generate the DDS and write an RPG program with the cycle that reads one file and populates another all from the spreadsheet.
For procedure logic, I've been copying and pasting pseudocode, I don't even have to tell it that it's in French.

Once it generated program code before I gave it my table. I told it I hadn't yet done so, it replied OK send me the table and I'll do it again.

Astonishing


On Mon, 14 Oct 2024 at 12:15, Dave <dfx1@xxxxxxxxxxxxxx> wrote:

Hello,

Has there been any discussion on using AI to code RPG applications?
Would be grateful if anyone could point me to the thread as I didn't
find anything.

*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***

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.