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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.