A methodology for building batch processing solely with SQL statements.
SQLSequencer (hereinafter referred to as SQLS) is a system that sequentially executes multiple SQL statements that have been arranged in order in advance. Since our establishment in 2000, we have consistently built core business systems, and SQLS was born out of the thought process regarding how to standardize programs that do not involve screen processing (hereinafter referred to as batch processing). The prototype was developed in 2005, and we have experienced significant results from its actual use. Since then, we have not engaged in almost any batch programming at our company. We perform processing solely by describing the execution control XML given to SQLS. We have realized through actual system construction that SQLS allows for the construction of business systems at a very low cost and with high reliability. The only necessary knowledge is database design skills and SQL statements. In typical programming, additional knowledge such as language knowledge, object-oriented knowledge, and standardization rules for log output are also required. In this way, SQLS enables system construction with the minimum necessary knowledge, allowing participation in system construction tasks with minimal training. Moreover, it achieves high productivity and reduces variability in quality.
![1_ttl_sqls[1].jpg](https://image.mono.ipros.com/public/product/image/439/2000024494/IPROS8927270136012648396.jpg?w=280&h=280)
Inquire About This Product
basic information
【Features】 ○ Execute SQL sequentially: • SQL statements are written in order. It is also possible to branch based on the execution results, allowing the combination of SQL to behave like a single program. ○ Replace SQL with external parameter strings: • In addition to executing predetermined SQL, there may be cases where you want to change the content of the SQL at runtime. For example, changing search conditions or inserting total values into an UPDATE statement. Replacing SQL with external parameters leads to the generalization of processing. ○ Branch based on execution results: • There may be cases where you want to branch processing based on the execution results of SQL. For example, obtaining the number of records with a SELECT statement and stopping processing if there are zero records. Additionally, branching can return to a previous SQL, allowing it to behave like a program. ○ Perform error handling: • It is also possible to branch based on errors output by the DBMS. Detection of key value duplication, exclusive conflicts, etc., is possible. Branching after detection can also be performed. ● For more details, please contact us or refer to the catalog.
Price information
Please feel free to contact us.
Delivery Time
※Please feel free to contact us.
Applications/Examples of results
Please feel free to contact us.
catalog（2）
Download All Catalogs
Company information
Our company leverages its extensive experience to function as your information department. We have consistently handled everything from planning, design, manufacturing, to operation, focusing on core management systems such as sales management, purchasing management, inventory management, and human resources management. Based on this experience, we have established a system to comprehensively address business challenges. Please feel free to utilize us as your information department.