nz_import_file_to_db: Import a file to db

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

Description

Import a single csv file to the netezza database. CSV columns must be as with following format "VALUE","DGGID","TID","KEY"

Usage

nz_import_file_to_db(
  DSN,
  file_path,
  table_name,
  value_type = "varchar(100)",
  createTable = T,
  max_errors = 2
)

Arguments

DSN	object extracted from nz_init function
file_path	the csv file path with following format "VALUE","DGGID","TID","KEY"
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

thespatiallabatLaurier/nzdggs documentation built on Sept. 7, 2020, 4:33 p.m.