SAS/ACCESS Interface to HP Neoview

Bulk Loading and Extracting for HP Neoview

Overview

Bulk loading is the fastest way to insert large numbers of rows into an HP Neoview table. To use the bulk-load facility, specify BULKLOAD=YES. The bulk-load facility uses the HP Neoview Transporter with an HP Neoview control file to move data from the client to HP Neoview.

Here are the HP Neoview bulk-load data set options. For detailed information about these options, see Data Set Options for Relational Databases.

BL_BADDATA_FILE=
BL_DATAFILE=
BL_DELETE_DATAFILE=
BL_DELIMITER=
BL_DISCARDS=
BL_ERRORS=
BL_FAILEDDATA=
BL_HOSTNAME=
BL_NUM_ROW_SEPS=
BL_PORT=
BL_RETRIES=
BL_ROWSETSIZE=
BL_SYNCHRONOUS=
BL_TENACITY=
BL_TRIGGER=
BL_TRUNCATE=
BL_USE_PIPE=
BULKLOAD=

Examples

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

libname sasflt 'SAS-data-library';
libname net_air neoview DSN=air2 user=louis 
        pwd=fromage schema=FLIGHTS;

proc sql;
create table net_air.flights98
       (bulkload=YES bl_system=FLT0101) 
        as select * from sasflt.flt98;
quit;

This next example shows how you can append the SAS data set, SASFLT.FLT98, to the existing HP Neoview table, ALLFLIGHTS. The BL_USE_PIPE=NO option forces SAS/ACCESS Interface to HP Neoview to write data to a flat file, as specified in the BL_DATAFILE= option. Rather than deleting the data file, BL_DELETE_DATAFILE=NO causes the engine to leave it after the load has completed.

proc append base=net_air.allflights
 (BULKLOAD=YES
  BL_DATAFILE='/tmp/fltdata.dat'
  BL_USE_PIPE=NO
  BL_DELETE_DATAFILE=NO)
  BL_SYSTEM=FLT0101 
data=sasflt.flt98;
run;

Extracting

Overview

Bulk extracting is the fastest way to retrieve large numbers of rows from an HP Neoview table. To use the bulk-extract facility, specify BULKEXTRACT=YES. The bulk extract facility uses the HP Neoview Transporter with an HP Neoview control file to move data from the client to HP Neoview into SAS.

Here are the HP Neoview bulk-extract data set options:

BL_BADDATA_FILE=

BL_DATAFILE=

BL_DELETE_DATAFILE=

BL_DELIMITER=

BL_FAILEDDATA=

BL_SYSTEM=

BL_TRUNCATE=

BL_USE_PIPE=

BULKEXTRACT=

Examples

This first example shows how you can read the large HP Neoview table, FLIGHTS98, to create and populate a SAS data set, SASFLT.FLT98:

libname sasflt 'SAS-data-library';
libname net_air neoview DSN=air2 user=louis 
        pwd=fromage schema=FLIGHTS;

proc sql;
create table sasflt.flt98
        as select * from net_air.flights98
       (bulkextract=YES bl_system=FLT0101);
quit;

This next example shows how you can append the contents of the HP Neoview table, ALLFLIGHTS, to an existing SAS data set, SASFLT.FLT98. The BL_USE_PIPE=NO option forces SAS/ACCESS Interface to HP Neoview to read data from a flat file, as specified in the BL_DATAFILE= option. Rather than deleting the data file, BL_DELETE_DATAFILE=NO causes the engine to leave it after the extract has completed.

proc append base=sasflt.flt98
data=net_air.allflights
 (BULKEXTRACT=YES
  BL_DATAFILE='/tmp/fltdata.dat'
  BL_USE_PIPE=NO
  BL_DELETE_DATAFILE=NO);
BL_SYSTEM=FLT0101
run;

Top of Page