sqlconvertcall: Translate a SQL file

Description Usage Arguments Details Examples

Description

This function takes SQL and translates it to a different dialect.

Usage

1
2
sqlconvertcall(sql = "", targetDialect,
  oracleTempSchema = NULL)

Arguments

sql

The source SQL file

targetDialect

The target dialect. Currently 'oracle', 'postgresql', and 'redshift' are supported

oracleTempSchema

A schema that can be used to create temp tables in when using Oracle.

Details

This function takes SQL and translates it to a different dialect.

Examples

1
2
3
4
5
6
## Not run: 
sqlconvertcall("myRenderedStatement.sql",
                 "myTranslatedStatement.sql",
                 targetDialect = "postgresql")

## End(Not run)

kganilkg131/SQLCon documentation built on May 23, 2019, 12:51 a.m.