BookmarkSubscribeRSS Feed
Fluorite | Level 6
I'm curious whether SAS Multi-Insert technology actually invokes something similar to PL/SQL "forall" inserts. The speed is very similar on systems that I'm using. Both are almost the same speed assql*loader
Tourmaline | Level 20
This specific question is best answered by a SAS/ACCESS developer.
Try to get an answer via tech support, or if you attend Global Forum - grab someone at the demo stations.

In my mind, there are some situations when bulkload is faster, especially for really large loads.

Data never sleeps
Fluorite | Level 6
We have found that "forall" out performs bulkload in our situation. We ended up making Oracle "forall" Procedures to call from SAS.

Ready to join fellow brilliant minds for the SAS Hackathon?

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!
How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 2 in conversation