Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201

    Unanswered: SQL*Loader-510: Physical record in data file

    What is causing this error

    The File on mainframe is a GDG

    it has a record layout with 123 bytes

    LDR file

    (
    CIF_CUST_GEN_KEY POSITION( 1: 7 )
    DECIMAL,
    CIF_CCOV_SEQ_NBR POSITION( 9: 12 )
    DECIMAL ,
    ENTITY_TYPE_CD POSITION( 14: 18 ) ,
    SRC_PLATFORM_CD POSITION( 19: 20 ),
    SRC_APPL_CD POSITION( 21: 22 ) ,
    SRC_CUST_KEY POSITION( 23: 47 ),
    SRC_CUSTCOV_KEY POSITION( 48: 87 ) ,
    ACTION_TIMESTAMP POSITION( 88: 106 )
    date "YYYY-MM-DD-HH24.MI.SS" ,
    AUDIT_ID POSITION( 115: 122 ) ,
    MAINT_CD POSITION( 123: 123 )
    )
    BYTES 1 - 12 on mainframe are packed

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Please show us your entire loader file, the error indicates that sql loader can't determine when the physical record ends. I suspect that the file doesn't contain any end of record bytes (cr,lf).

    If that is the problem then you can get around it by using the fix command in your control file. For example

    infile 'c:\path\myfile.txt' "fix 123"
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jan 2005
    Location
    Green Bay
    Posts
    201
    BILL

    The problem was the "FIX 123" was missing thanks for reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •