×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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:part1.I38r1k00.vALs4gvn@centurylink.net> CAAC
(COMMON Americas Advisory Council) IBM Influencer 2023
On 2/6/2026 1:38 PM, dfreinkel@xxxxxxxxxxxxxxxxx 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 mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
