SAS/ACCESS Interface to HP Neoview |
All SAS/ACCESS data set options in this table are supported for HP Neoview. Default values are provided where applicable. For general information about this feature, see Overview.
Option | Default Value |
---|---|
BL_BADDATA_FILE= |
When BL_USE_PIPE=NO, creates a file in the current directory or with the default file specifications. |
BL_DATAFILE= |
When BL_USE_PIPE=NO, creates a file in the current directory or with the default file specifications. |
BL_DELETE_DATAFILE= |
YES (only when BL_USE_PIPE=NO) |
BL_DELIMITER= |
| (the pipe symbol) |
BL_DISCARDS= |
1000 |
BL_ERRORS= |
1000 |
BL_FAILEDDATA= |
creates a data file in the current directory or with the default file specifications |
BL_HOSTNAME= |
none |
BL_NUM_ROW_SEPS= |
1 |
BL_PORT= |
none |
BL_RETRIES= |
3 |
BL_ROWSETSIZE= |
none |
BL_STREAMS= |
4 for extracts, no default for loads |
BL_SYNCHRONOUS= |
YES |
BL_SYSTEM= |
none |
BL_TENACITY= |
15 |
BL_TRIGGER= |
YES |
BL_TRUNCATE= |
NO |
BL_USE_PIPE= |
YES |
BULKEXTRACT= |
LIBNAME option setting |
BULKLOAD= |
NO |
DBCOMMIT= |
LIBNAME option setting |
DBCONDITION= |
none |
DBCREATE_TABLE_OPTS= |
LIBNAME option setting |
DBFORCE= |
NO |
DBGEN_NAME= |
DBMS |
DBINDEX= |
LIBNAME option setting |
DBKEY= |
none |
DBLABEL= |
NO |
DBMASTER= |
none |
DBMAX_TEXT= |
1024 |
DBNULL= |
YES |
DBNULLKEYS= |
LIBNAME option setting |
DBPROMPT= |
LIBNAME option setting |
DBSASLABEL= |
COMPAT |
DBSASTYPE= |
see Data Types for HP Neoview |
DBSLICE= |
none |
DBSLICEPARM= |
THREADED_APPS,3 |
DBTYPE= |
see Data Types for HP Neoview |
ERRLIMIT= |
1 |
IGNORE_ READ_ONLY_COLUMNS= |
NO |
INSERTBUFF= |
LIBNAME option setting |
NULLCHAR= |
SAS |
NULLCHARVAL= |
a blank character |
PRESERVE_COL_NAMES= |
LIBNAME option setting |
QUALIFIER= |
LIBNAME option setting |
QUERY_TIMEOUT= |
LIBNAME option setting |
READBUFF= |
LIBNAME option setting |
SASDATEFMT= |
none |
SCHEMA= |
LIBNAME option setting |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.