Splits a query into multiple parts, SVSPP codes

Source: R/split_sql_query_svspp.R

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.

split_sql_query_svspp(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