Re: Are SQL statement lines limited to 80 characters ?
Jon Paris <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected] > On Feb 6, 2026, at 4:41 PM, Richard Schoen <[email protected]> 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: [email protected] > ---------------------------------------------------------------------- > > message: 1 > date: Fri, 6 Feb 2026 19:10:47 +0100 > from: Daniel Gross <[email protected]> > 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 <[email protected]>: >> >> ?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: [email protected]<mailto:[email protected]> >> >> -- >> This is the RPG programming on IBM i (RPG400-L) mailing list To post a >> message email: [email protected] To subscribe, unsubscribe, >> or change list options, >> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l >> or email: [email protected] >> Before posting, please take a moment to review the archives at >> https://archive.midrange.com/rpg400-l. >> >> Please contact [email protected] for any subscription related questions. >> > -- > This is the RPG programming on IBM i (RPG400-L) mailing list > To post a message email: [email protected] > To subscribe, unsubscribe, or change list options, > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l > or email: [email protected] > Before posting, please take a moment to review the archives > at https://archive.midrange.com/rpg400-l. > > Please contact [email protected] for any subscription related questions. > -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact [email protected] for any subscription related questions.