Results 1 to 5 of 5

Thread: Getting past the physical file record length limit of 32766 bytes

  1. #1
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229

    Getting past the physical file record length limit of 32766 bytes

    I'm STILL working on getting an FTP of an XML document to function.

    My XML input file has an entry that is 40000+ characters.
    The max record length of a physical file is 32766 characters.

    The FTP works in that I get the first 32766 characters of the row.
    It doesn't work as anything beyond 32766 is truncated.

    I'm about to search the internet for ways around this BUT, as is my habit, I'm going to post here first.

    Has anyone FTP'd records longer than 32766, and how did you do it?
    Has anyone used a non-FTP approach to do this?
    Is there a way to read the XML from the windows folder and not use FTP?

    Thanks in advance
    Frosty
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

  2. #2
    Member
    Join Date
    Sep 2001
    Location
    Greene, NY
    Posts
    143
    I'm not an RPG'er but I was under the impression that if you can get the XML file copied into the IFS (under the right codepage) that you can read it using free-form RPG. Check this link...maybe it is helpful:

    http://www.code400.com/forum/forum/i...t-clear-the-ds
    iSeries running at V6R1
    JDE World 7.3, Cum12
    OneWorld XE Coexistence - Configurator

  3. #3
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229
    Terry,

    Thanks for the reply.

    When I found that I could FTP directly from the shared network folder, I gave up on trying to get the IFS to work.
    When I researched XML-INTO, I found the documentation to be "unfulfilling".

    I guess I will go back to those and try again.

    Thanks.
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

  4. #4
    Member
    Join Date
    Sep 2001
    Location
    Greene, NY
    Posts
    143
    What version of the OS are you running on?

    I *believe* that if your trying to process an XML file/object with a record length larger than 32,766 your going to have to use special system functions (like XML-INTO) to process the XML directly from the stream file.

    Hope to be retired before I have to screw around with XML at our facility...lol
    iSeries running at V6R1
    JDE World 7.3, Cum12
    OneWorld XE Coexistence - Configurator

  5. #5
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229
    Terry, we are on V7R1 for the OS.

    Right now, my issue isn't w/the parsing of the XML.
    It's the fact that FTP is truncating records at the 32766 character.
    I lose valid data after that.

    I did look into the XML-INTO for the parsing.
    From what I've read, you have to specify which node you are looking for, and the "path" meaning where that node is within the XML.
    You would have to know which nodes are needed for what you want to do.

    FURTHER, you can parse the XML into a data structure, but that data structure must match the order in which the nodes are specified.

    Either way, it's not the XML-INTO that will get me beyond the truncation issue.

    I think I need to get back to trying to UNDERSTAND and USE the IFS.
    These are two things that I've been able to ignore prior to this.
    There goes my 30+ year streak of being apathetic to them...

    Thanks for your replies.
    I will be starting an IFS thread in a moment.

    Happy last couple days of Sept 2018.

    Frosty
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.