generateSQL: Generate query from an SQL template file
In TonyBlonigan/sqlTemplateR: Dynamic SQL Templates for Flexible Queries
Description
Usage
Arguments
Value
See Also
Examples
Description
Generate query from an SQL template file
Usage
1
generateSQL(sqlTemplate, activate = NULL, tagMap = NULL)
Arguments
sqlTemplate
String: path to SQL Template File
activate
String: Vector of column names that should be uncommented.
If using alias, include the alias: c('prod.CORP_DIV_CD','cust.ADDRESS')
tagMap
List: Tags and the string they should be replaced with
Value
string
See Also
Examples
1
generateSQL(sqlTemplate = 'exampleQuery.sql', 'MARKET', "CORP_DIV_CD = 'DIV_A'")
TonyBlonigan/sqlTemplateR documentation built on May 14, 2019, 6:08 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value See Also Examples
Description
Generate query from an SQL template file
Usage
1 | generateSQL(sqlTemplate, activate = NULL, tagMap = NULL)
|
Arguments
sqlTemplate |
String: path to SQL Template File |
activate |
String: Vector of column names that should be uncommented. If using alias, include the alias: c('prod.CORP_DIV_CD','cust.ADDRESS') |
tagMap |
List: Tags and the string they should be replaced with |
Value
string
See Also
Examples
1 | generateSQL(sqlTemplate = 'exampleQuery.sql', 'MARKET', "CORP_DIV_CD = 'DIV_A'")
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.