split_sql_query_nespp3: Splits a query into multiple parts, NESPP3 codes

In andybeet/dbutils: Utility package for db connectivity and functionality

Splits a query into multiple parts, NESPP3 codes

Description

If a query has > 1000 items it will fail. For all cases where a query has > maxItems the call will be split. This occurrs when NESPP4 codes used in an a sql call.

Usage

split_sql_query_nespp3(channel, NESPP4s, maxItems = 900)

Arguments

channel	an Object inherited from DBIConnection-class. This object is used to connect to communicate with the database engine. (see connect_to_database)
NESPP4s	Numerical Vector. NESPP4 codes used in an sql query
maxItems	Numeric scalar. Maximum number of items in a single sql query

Value

List

sql	the sql statements
speciesTable	Resulting table from concatenating the sql calls

andybeet/dbutils documentation built on March 15, 2024, 4:43 p.m.