ibmdbR (version 1.51.0)

as.ida.data.frame: Convert an R object to an IDA data frame

Description

This function creates an IDA data frame ida.data.frame from a local R data.frame by creating a table in the database.

Usage

as.ida.data.frame(x, table=NULL, clear.existing=FALSE, case.sensitive=TRUE, 
                  rownames=NULL, dbname=NULL, asAOT=FALSE)

Value

A IDA data frame that points to the newly created table.

Arguments

x

The name of the input object that is to be converted to a IDA data frame.

table

The name of the database table that is to be created to hold the contents of the IDA data frame. The specified name is folded to uppercase. If this parameter is not specified, a name is generated automatically.

clear.existing

If the table parameter is specified, this parameter indicates whether the existing table is to be dropped (TRUE) or whether the as.ida.data.frame statement is to be ignored and a warning message issued (FALSE).

case.sensitive

If the table parameter is specified for an existing table, this parameter specifies whether the column names in that table name are to be treated as case-sensitive (TRUE) or not case-sensitive (FALSE).

rownames

The name of the column for the unique row id. If the value of this parameter is NULL, this column is not added to the output table.

dbname

DB2 for z/OS only parameter: the name of the database where the table should be created in.

asAOT

DB2 for z/OS only parameter: the table should be created as an "accelerator only table".

See Also

as.data.frame

Examples

if (FALSE) {

#Add an ID column to iris
iris2 <- iris
iris2$ID <- 1:150

#Upload it and overwrite if already exists
idf <- as.ida.data.frame(iris2,"IRIS",clear.existing=T)
	
}