copy_to API When Loading Data into PTI Table | Teradata R Package - copy_to API When Loading Data into PTI Table - Teradata R Package

When the copy_to API fails with the Database error message “4358 Time Series: TD_TIMECODE| TD_SEQNO out of range for table”, you must check the permitted TD_TIMECODE and TD_SEQNO ranges based on the other arguments of copy_to() using the following:

DBI::dbGetQuery(con, “exec DBC.TD_TIMESERIES_RANGE('MyDB.<table_name>')”)

Where:

• con is the connection object
• MyDB is the schema name
• <table_name> is the name of the table to be created

And correct the data or the arguments like "seq.max" to suit the data.