Re: Are SQL statement lines limited to 80 characters ?
Vern Hamberg via RPG400-L <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
SQL statements can overflow many lines, but each line must fit within a certain length for source members, which have a record length, and SRCDTA length is 12 less than the record length. **free still has a SRCDTA field and can use everything from position 1 to its length. Fixed, columnar format is limited to 8 to 80 (is this true for source files defined with record length of 112? I've never tried using a longer source PF. Nor have I tried embedded SQL for ILE RPG in a 92-long source PF. *Regards* *Vern Hamberg* IBM Champion 2025 <cid:[email protected]> CAAC (COMMON Americas Advisory Council) IBM Influencer 2023 On 2/6/2026 1:38 PM, dfreinkel-cbKQUZO/W6aaLr2CDSiKrwC/[email protected] wrote: > I believe it refers to the length of the SQL statement which can overflow many lines. I have done this before. However, if you are using a source file member, you will be limited to the length of the SRCDTA field. > > Darryl Freinkel > A4G > Telephone: 770.321.8562 > -- 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.