commit_sql: commit .sql file to database

Description Usage Arguments Examples

Description

commit .sql file to database

Usage

1
commit_sql(conn, sql_file, file_flag = T)

Arguments

conn

the connection from connect_db

sql_file

the sql file without any comments

file_flag

default TRUE, if FALSE, the sql file itself is treated as a string

Examples

1
2
3
4
5
## Not run: 
commit_sql(conn, "Z:/EMR/bearhunt.sql")
commit_sql(conn, "select * from session.ca", file_flag = F)

## End(Not run)

dajuntian/emr4washu documentation built on May 14, 2019, 3:29 p.m.