Patent Document ID: 9378254
Application ID: 13843446

Base Claim:
1. A method, implemented by an information handling system, that copies records between tables in a relational database, the method comprising: receiving a Structured Query Language (SQL) table COPY statement, wherein the COPY statement is devoid of an INSERT clause and identifies a source table and a target table; retrieving a plurality of column names from a metadata corresponding to the source table; and generating an SQL statement, based upon the COPY statement, that includes an INSERT INTO clause pertaining to the target table and a SELECT clause pertaining to the source table, wherein the INSERT INTO clause includes a set of target column names corresponding to the plurality of column names, and wherein the SELECT clause includes a set of corresponding source column names.

---

Claim 5:
5. The method of claim 1 , wherein the COPY statement further identifies a ON ERROR clause, the method further comprising: identifying one or more mismatches between the source table and the target table; and adjusting the generated SQL statement based on the ON ERROR clause and the identified mismatches.