var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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
CIF_CUST_GEN_KEY POSITION( 1: 7 )
CIF_CCOV_SEQ_NBR POSITION( 9: 12 )
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
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"
You do not need a parachute to skydive. You only need a parachute to skydive twice.
The problem was the "FIX 123" was missing thanks for reply