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 🙂
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: