Re: Are SQL statement lines limited to 80 characters ?

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

There was an issue in this area many moons ago but I thought it had been fixed.

I am assuming that your source physical file has a length > 92.


Jon Paris
Jon.Paris@xxxxxxxxxxxxxx



> On Feb 6, 2026, at 4:41 PM, Richard Schoen <richard@xxxxxxxxxxxxxxxxx> wrote:
>
> Actually just adding **free didn't eliminate the line limit from what I could tell. 
>
> Regards,
> Richard Schoen
> Web: http://www.richardschoen.net
> Email: richard@xxxxxxxxxxxxxxxxx
> ----------------------------------------------------------------------
>
> message: 1
> date: Fri, 6 Feb 2026 19:10:47 +0100
> from: Daniel Gross <daniel@xxxxxxxx>
> subject: Re: Are SQL statement lines limited to 80 characters ?
>
> For **free I can say, it's only limited by the line length of the source file. 
>
> HTH
> Daniel
>
>
> > Am 06.02.2026 um 18:44 schrieb Richard Schoen <richard@xxxxxxxxxxxxxxxxx>:
> >
> > ?Maybe some of you already know this, but I just spent a couple hours debugging an SQL statement that worked great in ACS Run SQL but would not pass the SQLRPGLE pre-compiler test.
> >
> > As it turns out I believe each line of an SQL statement can only be up to position 80 before you need to continue on the next line.
> >
> > I read something that alluded specifying **free would allow longer lines, but that didn't seem to help.
> >
> > Can someone tell me what the reality is for this ?
> >
> > Am I limited to 80 line SQL statements in SQLRPGLE ?
> >
> > Thanks
> >
> > Regards,
> > Richard Schoen
> > Web: http://www.richardschoen.net
> > Email: richard@xxxxxxxxxxxxxxxxx<mailto:richard@xxxxxxxxxxxxxxxxx>
> >
> > --
> > 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.