BS2000/OSD SQL*Loader-509 and Record n Rejected Invalid Packed Decimal Nibble (Doc ID 947867.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4
Fujitsu Siemens BS2000/OSD

Symptoms

SQLLDR of Oracle Database 10g on BS2000/OSD has different behavior compared to SQLLDR of Oracle 9i. There are some special situations where you can not load input data which you have been able to load with Oracle 9i on BS2000/OSD:


1) When using a SAM or ISAM file with fixed record format (REC-FORM=(F,N) ) as input datafile SQLLDR aborts with:

 

 

 

SQL*Loader-500: Unable to open file (UPLOAD.F)
SQL*Loader-554: error opening file
SQL*Loader-509: System error: SOSD code 00000006 DMS=

 

 

2) If you want to load data of a binary datatype (RAW, DECIMAL etc.) and your input data contains a new line (X'15' in EBCDIC) SQLLDR aborts with:

 

Record 3: Rejected - Error on table TAB1, column COL1.
Invalid packed decimal nibble.
Record 34: Rejected - Error on table TAB1, column COL1.
Value larger than specified precision allows for this column
Record 44: Rejected - Error on table TAB1, column COL1.
Invalid packed decimal nibble.


Changes

SQLLDR uses the generic behavior under BS2000/OSD now

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms