This makes sense. SAS is pretty powerful in converting datatypes and it is issue of bulkload. I have loaded and moved more than 200 million, without any issues. Please try bl_options and see whether it works.
libname sasflt 'SAS-library'; libname net_air netezza user=myuser pwd=mypwd server=air2 database=flights; proc sql; create table net_air.flights98 (bulkload=YES bl_options="logdir 'c:\temp\netlogs'") as select * from sasflt.flt98; quit;
Also try using a very SAS small dataset and do a bulkload and see whether it works or not. otherwise there is issue with your bulkload itself, which is netezza component.
@kiranv_ with smaller datasets the bulkload option is working.
My workaround was insead of using bulkload, to use insertbuff and dbcommit.
@Reeza thanks I'll look into this. The problem is that some tables have a large amount of columns...so maybe it's not ideal even if it does solve my issue.
@Reeza I have not but I think maybe itll be worth a shot to do it like that.
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!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.