| 主权项 |
1. A computer implemented method for identifying a load utility, the method comprising:
receiving a first information, wherein the first information comprises one or more records, the one or more records being associated with a load utility and defining a library of parameters, wherein the first information comprises transaction data, wherein transaction data comprises at least one of an account name, an account number, an account balance, a transaction amount, a transaction date, a payee, a signature, and/or a memo, wherein the library of parameters defines a first syntax, wherein the library of parameters comprise a Log table, a Work table, a Uniqueness Violation (UV) table, and/or an Error table; counting the number of records in the first information; comparing the counted number of records to a predetermined threshold value; identifying a load utility to be used to load the records into a database based on the comparison between the counted number of records and the predetermined threshold value, wherein identifying further comprises (i) determining that the number of records is greater than the predetermined threshold, and loading the first information into a database using a multiload load utility (MLOAD); (ii) determining that the number of records is less than the predetermined threshold, and loading the first information into the database using a Teradata load utility (TPUMP); or (iii) determining that the number of records equals the predetermined threshold, and loading the first information into a data base using either the MLOAD or the TPUMP utility, whereby larger volumes of records are processed using the MLOAD load utility and smaller volumes of records are processed using the TPUMP utility, and whereby less computer resources are used to implement TPUMP than MLOAD thereby providing for conservation of computer resources; loading the first information into the database using the MLOAD load utility or the TPUMP utility based on at least comparing the counted number of records to the predetermined threshold value; converting the first syntax of the library of parameters to a second syntax, wherein the second syntax is associated with the identified load utility, wherein converting the first syntax comprises generating at least one script and computer code of the library of the parameters using the second syntax, wherein converting further comprises:
identifying one or more unassociated parameters, wherein the one or more unassociated parameters are not associated with the identified load utility;automatically editing the one or more unassociated parameters to comply with the second syntax, wherein automatically editing further comprises automatically adding a statement and a parameter into the library of parameters associated with the identified load utility; andupdating the library of parameters based on at least automatically editing the one or more unassociated parameters; validating the second syntax of the library of parameters, wherein validating the second syntax of the library of parameters comprises using a compiler; and writing an output parameter to a memory location based on positive validation of the second syntax of the library of parameters. |
