Onnet Systems Inc. SQLSequencer

Added to bookmarks
Bookmarks list

Bookmark has been removed
Bookmarks list

You can't add any more bookmarks

By registering as a member, you can increase the number of bookmarks you can save and organize them with labels.
Free membership registration

last updated：Jan 30, 2011

Official site

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.

Related Link - http://www.onnet.ne.jp/products/dev_sqls.html#sqls…

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.