Abstract: One or more processors receive operational data. The operational data includes two or more fields that contain an identical type of data as two or more fields within a master table. One or more processors generate a plurality of first unique identifiers from the two or more fields within the operational data and the master table. One or more processors determine a match between a pair of the plurality of first unique identifiers. The match is between a first unique identifier included in a operational data record and a first unique identifier included in a master table record. One or more processors determine a second unique identifier from the master table record. One or more processors generate an operational table record that includes the second unique identifier and at least a portion of the operational data.

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.

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.

Abstract: One or more processors receive operational data. The operational data includes two or more fields that contain an identical type of data as two or more fields within a master table. One or more processors generate a plurality of first unique identifiers from the two or more fields within the operational data and the master table. One or more processors determine a match between a pair of the plurality of first unique identifiers. The match is between a first unique identifier included in a operational data record and a first unique identifier included in a master table record. One or more processors determine a second unique identifier from the master table record. One or more processors generate an operational table record that includes the second unique identifier and at least a portion of the operational data.

Abstract: One or more processors receive operational data. The operational data includes two or more fields that contain an identical type of data as two or more fields within a master table. One or more processors generate a plurality of first unique identifiers from the two or more fields within the operational data and the master table. One or more processors determine a match between a pair of the plurality of first unique identifiers. The match is between a first unique identifier included in a operational data record and a first unique identifier included in a master table record. One or more processors determine a second unique identifier from the master table record. One or more processors generate an operational table record that includes the second unique identifier and at least a portion of the operational data.

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.

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.

Abstract: Techniques are disclosed for retrieving database data records using a request having a substitute clause. The substitute clause replaces a value stored in a predefined column with a new value while selecting the values of the plurality of columns in a projection list. In one embodiment, the database request may utilize a pre-defined syntax for a SELECT statement that supports a substitute clause having a form of: substitute(<col name>, <expression>).

Abstract: Techniques are disclosed for retrieving database data records using a request having a substitute clause. The substitute clause replaces a value stored in a predefined column with a new value while selecting the values of the plurality of columns in a projection list. In one embodiment, the database request may utilize a pre-defined syntax for a SELECT statement that supports a substitute clause having a form of: substitute(<col name>, <expression>).