Good morning,
I have several SAS tables containing several million records that I would like to load into DB2. For now, I do it via the NODE DATA Target (Insert) but given the amount of data, I would like to do a LOAD instead of an INSERT.
Could someone help me?
Thanks
Hi
This is the same node for inserting and loading. Bulk load is supported for DB2, you can refer to the following entry in the doc: https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.9/dfUnity.html#dfU_PFOutput_TrgtInsert....
This allows you to process a set number of rows at a time. Enter the number of rows to be processed in the Property Value field when you have thousands of records. This option will help your system run more efficiently. The default value for the BULK_ROW_COUNT option is 10,000.
Note: Bulk row count is supported on databases such as Oracle SQL Server and DB2. There is no need to activate a bulkload option at the driver level in the data connection for the table.
Hi
This is the same node for inserting and loading. Bulk load is supported for DB2, you can refer to the following entry in the doc: https://support.sas.com/documentation/onlinedoc/dfdmstudio/2.9/dfUnity.html#dfU_PFOutput_TrgtInsert....
This allows you to process a set number of rows at a time. Enter the number of rows to be processed in the Property Value field when you have thousands of records. This option will help your system run more efficiently. The default value for the BULK_ROW_COUNT option is 10,000.
Note: Bulk row count is supported on databases such as Oracle SQL Server and DB2. There is no need to activate a bulkload option at the driver level in the data connection for the table.
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.