Bulk Loading and Unloading for Yellowbrick

Overview of Bulk Loading and Unloading for Yellowbrick

Bulk loading is the fastest way to insert large numbers of rows into a Yellowbrick table. To use the bulk-load utility, set the BULKLOAD= LIBNAME option or data set option to YES. Similarly, bulk unloading is the fastest way to retrieve large numbers of rows from a Yellowbrick table. To use the bulk-unloading utility, set the BULKUNLOAD= LIBNAME option or data set option to YES. Bulk loading is implemented with the Yellowbrick ybload utility, which moves data from SAS into the Yellowbrick database. Bulk unloading is implemented with the Yellowbrick ybunload, which moves data from Yellowbrick into SAS.

LIBNAME and Data Set Options with Bulk Loading and Unloading

This section lists the Yellowbrick options for bulk loading and bulk unloading. For more information about these options, see Overview.

Here are the data set options for bulk loading and bulk unloading:

• BL_DATAFILE=
• BL_DEFAULT_DIR=
• BL_DELETE_DATAFILE=
• BL_DELIMITER=
• BL_ESCAPE=
• BL_FORMAT=
• BL_LOGFILE=
• BL_NULL=
• BL_QUOTE=
• BL_YB_PATH=
• BULKLOAD=
• BULKUNLOAD=
• YB_JAVA_HOME=

Bulk-Load Example for Yellowbrick

This first example shows how you can use a SAS data set, SASFLT.FLT98, to create and load a large Yellowbrick table, FLIGHTS98:

libname sasflt 'SAS-library';
libname net_air ybrick user=myusr1 pwd=mypwd1
        server=air2 database=flights;

proc sql;
create table net_air.flights98 (bulkload=YES bl_yb_path='path-to-ybload')
        as select * from sasflt.flt98;
quit;