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