AW: CHATGPT and SQL

This is the solution of aria AI, if i ask as Raul did.

CREATE TABLE yourlib.yourtab (
Clientno INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) PRIMARY KEY,
Name VARCHAR(100),
City VARCHAR(100),
Email VARCHAR(100)
);

Passed in ACS SQL with journal warnings.

AI, with some attention, can be very helpful, for Java solutions as well.
Why should I get wounded fingers of typing when the system can do for me?

But, who can remember the phone numbers in the smartphone?
With AI we are on the best way to do the same with our knowledge.

KF

-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] Im Auftrag von Birgitta Hauser
Gesendet: Freitag, 26. Januar 2024 07:46
An: 'RPG programming on IBM i'
Betreff: RE: CHATGPT and SQL

... did you try to create the table?
1. Where (in which schema will it be created)?
2. AUTO_INCREMENT is not allowed in Db2 for i

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
"Train people well enough so they can leave, treat them well enough so they don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert Einstein)

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Raul Alberto Jager Weiler
Sent: Friday, 26 January 2024 01:09
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: CHATGPT and SQL

I asked Bard to create a client table, this is the example, I did mot copy all the explanations it gave me

CREATE TABLE clientes (
id_cliente INT NOT NULL AUTO_INCREMENT,
nombre VARCHAR(255),
apellido VARCHAR(255),
email VARCHAR(255),
PRIMARY KEY (id_cliente)
);


El jue, 25 de ene de 2024, 14:20, Brian May via RPG400-L < rpg400-l@xxxxxxxxxxxxxxxxxx> escribió:

This is one of the many great features of generative AI that we use
within our AI solutions. It is extremely useful.

Brian May
VP of Product Management
Profound API and AI Solutions Product Owner Profound Logic Software

http://www.profoundlogic.com/ai

937-439-7925 Phone
877-224-7768 Toll Free



-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of JOSE
PEREZ via RPG400-L
Sent: Thursday, January 25, 2024 9:51 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: JOSE PEREZ <joseenocperez@xxxxxxxxx>
Subject: CHATGPT and SQL

Colleagues do you know that you can generate SQL statement using CHATGPT?
what do you think of this?, have you use it? Sometimes some of us
don't remember about a sql statement so here comes our friend CHATGPT
to our help. I would like to hear your story on this.
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.