Methodology for constructing batch processing solely with SQL statements.
SQL Sequencer (hereinafter referred to as SQLS) is a system that sequentially executes multiple SQL statements that have been arranged in order beforehand. Since our founding 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 using SQLS allows us to build business systems very cost-effectively and reliably. 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 allows us to start system construction with the minimum necessary knowledge, enabling participation in system development with minimal training. Furthermore, it achieves high productivity and reduces variability in quality.
![1_ttl_sqls[1].jpg](https://image.www.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 statements to behave like a single program. - Replace SQL with external parameter strings: There may be cases where you want to change the content of SQL at runtime, not just execute predefined SQL. 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 results of SQL execution. For example, obtaining the number of records with a SELECT statement and aborting the process if there are zero records. Additionally, branching can return to a previous SQL statement, 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.