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

In ibmdbR: IBM in-Database Analytics for R

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)

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".

Value

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

See Also

as.data.frame

Examples

## Not run: 

#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)
	

## End(Not run)

ibmdbR documentation built on Nov. 24, 2023, 5:09 p.m.