docs/Api/nz_import_dir_to_db.md

In am2222/nzdggs: Manipulate and Run Analysis on Netezza Using IDEAS Model

nz_import_dir_to_db: import directory

Description

Import a directory into database. The directory must have a set of csv files

Usage

nz_import_dir_to_db(
  DSN,
  directory,
  table_name,
  value_type = "varchar",
  createTable = T,
  max_errors = 2
)

Arguments

Argument |Description ------------- |---------------- DSN | The NZ DSN object made by nz_init directory | Directory of CSV files table_name | Name of the table to import data into value_type | The type of Value possible options float, varchar, integer, bigint createTable | Either make a new table and drop table if exists or append data to the existing table max_errors | The maximumn number of rows in the csv which can include error in their values

Value

Examples

nz_import_dir_to_db()

am2222/nzdggs documentation built on Sept. 7, 2020, 6:39 p.m.