The main purpose of using SHARE is to handle concurrent update to the same table. Beacuse it is a server, it became also a ODBC server. It does not offer any bulk-load functionality. The performance of standard SQL INSERT INTO
table query-expression in SAS are comparable to bulk-load in regular RDBMS.
The most common way to load SAS tables are to use SAS programs. So if you can have your transactions in your ODBC source database, then have SAS to read them via ODBC and insert it into SAS tables. If you don't have the SAS/ACCESS to ODBC product, you can export your values to a flat file, and then have SAS read it.
The Table Server in SAS 9.2 may offer better performance. Another option would be using SPD server, if you contrary to expectation have that licensed.
/Linus
Data never sleeps