Re: CHATGPT and SQL

On Thu, 25 Jan 2024 at 21:57, Jose Perez <joseenocperez.jp@xxxxxxxxx> wrote:

Well another thing that we have to be careful with is how we ask CHATGPT, for example
if you ask Create a customer table using sql CHATGTP made create the sql sentence not based on DB2 (IBM I Database) instead if you ask
DB2 SQL Create a customer table your sql may be very similar to what we use in the IBM I.
as Birgitta said besides SQL being a standard for many programming languages some of them may have their own SQL statement.

I think of it like this:
Would I rather debug and test my own code, or someone else's?
ChatGPT is that 'someone else'.
If I did not know anything at all, then maybe it WOULD be better to
debug that generated code.

In my RPG world, newcomers always seem to get tripped up by subfiles.
Ask it these two questions:
Please write an example of an ILE RPG subfile program
Please write the appropriate DDS for this example

What in that code is a useful learning tool? (spoiler: it won't even compile).
--buck