Extract MATURITY information from SVDBS — get_maturity • survdat

Extract a list of maturity codes and descriptions from the SVDBS FSCS_MATURITY_CODES table

get_maturity(channel)

Arguments

channel: an Object inherited from DBIConnection-class. This object is used to connect to communicate with the database engine. (see connect_to_database)

Value

A list is returned:

data: containing the result of the executed $sql statement
sql: containing the sql call
colNames: a vector of the table's column names

Reference

Use the data dictionary for field name explanations

See also

connect_to_database

Other helper: get_conversion_factors(), get_cruise_purpose(), get_length_weight(), get_sex(), get_sex_fscs(), get_species(), get_strata(), get_vessel()

Examples

if (FALSE) { # \dontrun{
# extracts complete maturity table
channel <- dbutils::connect_to_database(server="serverName",uid="userName")
get_maturity(channel)
} # }