The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Aug. 28, 2018
Filed:
Oct. 12, 2015
International Business Machines Corporation, Armonk, NY (US);
Kiran Challapalli, Hyderabad, IN;
Vaibhav S. Dantale, Pune, IN;
International Business Machines Corporation, Armonk, NY (US);
Abstract
In an approach for manipulating columns in a projection list in a database result set, a processor receives a database request having a projection operation for a plurality of columns in one or more tables, wherein the projection operation comprises a SELECT statement having a column list that includes having (a) a shorthand that specifies the plurality of columns and (b) a column sequence clause that specifies a column name from the plurality of columns and a resulting column position. A processor retrieves data records having the plurality of columns including the specified column name and the resulting column position. A processor generates a result set comprised of the data records having the plurality of columns, such that for the result set, values within the specified column name are inserted into the result set at the resulting column position.