writeDDL: Write DDL script
In OHDSI/DDLgeneratr: OMOP CDM DDL and Documentation Generator
Description
Write DDL script
Usage
1
2
writeDDL(targetdialect, cdmVersion, cdmDatabaseSchema, sqlFilename,
cleanUpScript = F)
Arguments
targetdialect
The dialect of the target database. Choices are "oracle", "postgresql", "pdw", "redshift", "impala", "netezza", "bigquery", "sql server"
cdmVersion
The version of the CDM for which you are creating the DDL.
cdmDatabaseSchema
The schema of the CDM instance where the DDL will be run. For example, this would be "ohdsi.dbo" when testing on sql server. After testing
this can be changed to "@cdmDatabaseSchema"
sqlFilename
The name of the sql file with the current ddl specifications to be translated and rendered
cleanUpScript
Set to T if the clean up script should be created. This is for testing purposes and will create a sql script that drops all CDM tables.
By default set to F. Set to F for Oracle as well as the sql render translation does not work well.
OHDSI/DDLgeneratr documentation built on March 10, 2021, 1:44 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
Write DDL script
Usage
1 2 | writeDDL(targetdialect, cdmVersion, cdmDatabaseSchema, sqlFilename,
cleanUpScript = F)
|
Arguments
targetdialect |
The dialect of the target database. Choices are "oracle", "postgresql", "pdw", "redshift", "impala", "netezza", "bigquery", "sql server" |
cdmVersion |
The version of the CDM for which you are creating the DDL. |
cdmDatabaseSchema |
The schema of the CDM instance where the DDL will be run. For example, this would be "ohdsi.dbo" when testing on sql server. After testing this can be changed to "@cdmDatabaseSchema" |
sqlFilename |
The name of the sql file with the current ddl specifications to be translated and rendered |
cleanUpScript |
Set to T if the clean up script should be created. This is for testing purposes and will create a sql script that drops all CDM tables. By default set to F. Set to F for Oracle as well as the sql render translation does not work well. |
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.