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.
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 🙂
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 🙂
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.