ibmdbR (version 1.34.3)

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

Description

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

Usage

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

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 and a table with the specified name already exists, this parameter specifies whether the existing table is to be dropped (TRUE) or whether the as.ida.data.frame statement is to be ignor

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

Value

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

See Also

as.data.frame

Examples

# create data.frame from table in local memory
df <- idaQuery("SELECT * FROM DB2INST1.SHOWCASE_SYSTEMS")
 
# convert data.frame to ida.data.frame, contents will be loaded into table 'SHOWCASE_SYSTEMS_COPY'
idadf <- as.ida.data.frame(df,'SHOWCASE_SYSTEMS_COPY',clear.existing=TRUE)