Results 1 to 3 of 3

Thread: Read flat file to custom table

  1. #1

    Read flat file to custom table

    Iam trying to open and read pipe delimiter flat file with .dat extension and then process it.
    Can anyone guide me with opening a flat file and processing it with a fixed delimiter.

    Regards,

  2. #2
    Member
    Join Date
    Apr 2003
    Location
    Ohio, USA
    Posts
    405
    You've got a few options.

    You could design a Table Conversion to read and process the file.

    You could look at b4700240 to see if it would help. Or, use Object Browser to do a search on some key words like Import or Flat File to find some other business functions for reading and processing flat files.
    Ellen Deak
    Sr. Software Developer
    Dealer Tire
    EnterpriseOne (E920), Tools 9.2.2.4, IBM DB2 V7.2, Create!form 8

  3. #3
    New Member
    Join Date
    Jun 2005
    Location
    KS,USA
    Posts
    38
    You can use this.

    B76B0220 - Flat File I/O Functions

    VA dd_PTH = [file location path dependent on the platform type]
    VA dd_RECL = [maximum length of data]
    VA dd_GENLNG = 0

    Fetch Next Line from Flat File
    VA dd_PTH -> szFlatFileName
    VA dd_GENLNG <> idFilePtr
    VA dd_APTA <- szFlatFileRecord
    VA dd_RECL -> mnRecordLength

    While VA sec_dd_GENLNG is not equal to "0"
    Fetch Next Line from Flat File
    VA dd_PTH -> szFlatFileName
    VA dd_GENLNG <> idFilePtr
    VA dd_APTA <- szFlatFileRecord
    VA dd_RECL -> mnRecordLength
    End While
    ----------------------------------------------
    JD Edwards XE B7333, EnterpriseOne 8.11, 9.0 and 9.1, BSSV, C, JAVA

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.