Re: Are SQL statement lines limited to 80 characters ?
Richard Schoen <richard-DiTrGpQEJGItADg8e/3/[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <CH0PR12MB52503CC7F42F1C5CE00D498DB766A@CH0PR12MB5250.namprd12.prod.outlook.com> |
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-DiTrGpQEJGItADg8e/3/[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 <richard-DiTrGpQEJGItADg8e/3/[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: richard-DiTrGpQEJGItADg8e/3/[email protected]<mailto:richard-DiTrGpQEJGItADg8e/3/[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: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org > Before posting, please take a moment to review the archives at > https://archive.midrange.com/rpg400-l. > > Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org 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: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.