rxExecuteSQLDDL: Execute SQL Command for Data Manipulation, Definition, or Control

Description

Execute a command to define, manipulate, or control SQL data (but not return data).

Usage

 rxExecuteSQLDDL(src, ...)

Arguments

src

An RxOdbcData data source.

...

Additional arguments, typically sSQLString= supplied with a character string specifying the SQL command to be executed. The typical SQL commands are CREATE TABLE and DROP TABLE.

Value

Returns NULL; executed for its side-effect (the manipulation of the SQL data source).

Author(s)

Microsoft Corporation Microsoft Technical Support

See Also

RxOdbcData

Examples

 ## Not run:


# Note: for improved security, read connection string from a file, such as
# conString <- readLines("conString.txt")

conString <- "Driver=Teradata;DBCNAME=myDb;Database=test;Uid=tester;pwd=pwd;"
outOdbcDS <- RxOdbcData(table = "MyClaims", 
 connectionString = conString,
 useFastRead=TRUE) 
rxOpen(outOdbcDS, "w") 
rxExecuteSQLDDL(outOdbcDS, sSQLString = paste("CREATE TABLE [MyClaims]([RowNum] [int] NULL, [age] [char](5) NULL, ",
 "[car_age] [char](3) NULL, [type] [char](1) NULL, ", " [cost] [float] NULL, [number] [float] NULL);", sep=""))
inTextData <- RxTextData(file = file.path(rxGetOption("sampleDataDir"), "claims.txt"),
 stringsAsFactors = TRUE, useFastRead = TRUE)
outOdbcDS <- RxOdbcData(table = "MyClaims", 
 connectionString = conString,
 useFastRead=TRUE) 
rxDataStep(inData = inTextData, outFile = outOdbcDS) 
 ## End(Not run)