Bulk loader error: SQL3006C An I/O error

Binks_no_Sake — Wed, 19 Sep 2018 06:57:25 GMT

Hi, i'm playing with a new bulkload setup after migration of sas jobs from z/Os to Unix.

Managed to get the bulk loader working, but:

NOTE: 11120546 rows were inserted into DW_1.Tdw111.

ERROR: Bulk loader error: SQL3006C An I/O error occurred while opening the messaging file.

Job creates a work. file from DB2 table and inserts the data in a different DB2 table:

proc sql;                                                             
insert into DW_1.Tdw111                                    
(                                                                     
BULKLOAD=YES,                                                         
BL_DELETE_DATAFILE=YES,                                               
DBCOMMIT=100000,                                                      
INSERTBUFF=10000,                                                     
BL_DATAFILE=                                                          
"/*random path*/BL_TDW111_VNT_LL.IXF",
BL_OPTIONS='compound=100 norowwarnings'                               
)
select * from WORK.Tdw111;
quit;

Any idea what causes the error and how to deal with it ?

Thank you so much.

Re: Bulk loader error: SQL3006C An I/O error

Binks_no_Sake — Wed, 19 Sep 2018 11:27:18 GMT

SOLVED!

after a while of playing i used bulk load option:

BL_LOG="/random path/BL_TDW107.log"

where i found out, the actual problem, which was:

SQL3088N The source column specified to be loaded into database column
"END_INTENTSEQ" is not compatible with the database column, but the database
column is not nullable.

So i used another bl option:

BL_OPTION='FORCEIN'

And then the Bulk load have ran succesfully 🙂

topic Bulk loader error: SQL3006C An I/O error in SAS Programming

Bulk loader error: SQL3006C An I/O error

Re: Bulk loader error: SQL3006C An I/O error