Re: Microsoft Copilot and IBM i DB2 SQL

[Arne Quanbeck <arne@xxxxxxxxxxxx>]

Generalized LLMs like Grok and ChatGPT need to know what system they
are producing results for. Stephen's advice is excellent. You can add
additional preferences to get a better solution. 

The other thing to note is that there are generally multiple versions
of each model. For Grok the current generally available version as of
this writing is 4.2. Grok has Fast, Expert and Heavy modes. You need a
subscription for heavy, and it's generally overkill for things like
generating SQL.


On Wed, 2026-03-18 at 15:01 -0400, Stephen Richter wrote:
> Maybe you need a subscription?   I pay $12 a  month through x.com
> .    Post
> your question, I will run it through grok.   In the prompt I always
> say DB2
> for IBM i.  The SQL answers are outstanding from Grok.
>
> On Wed, Mar 18, 2026 at 2:41 PM Art Tostaine, Jr.
> <atostaine@xxxxxxxxx>
> wrote:
>
> > Just today Grok didn't have any idea what i was talking about,
> > ChatGPT gave
> > me a perfect SQL statement with the exact same prompt.
> >
> > Art
> > --
> > 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.