Method for resolving problem of unable outward variable transfer of executive character string under action domain limitation

Abstract

The invention provides a method which aims at solving the problem that a variable in an execution character string can not be transferred to the outside due to the limitation of an effect scope and is applied to the program design of the storage process or batch processing in a relational data base based on the structured query language. In the program design, by utilizing the execution character string method, a query statement can be dynamically formed, which makes the program design more flexible; however, the execution character string has the independent scope, and the variable defined in the execution character string can not be directly transferred out of the execution character string; aiming at the problem, the method is characterized in that during the storage process or batch processing, a temporary table is established first; in the execution character string, data are inserted or updated; and outside the execution character string, the data of the temporary table are queried, so that the problem that the variable in the execution character string can not be transferred to the outside is solved. With the method, the application of the execution character string is more flexible and wider, the programming complexity is effectively simplified, and the operational performance of a computer is improved.

Description

Technical field: [0001] The present invention relates to software design, especially application software program design using stored procedure or batch processing in relational database system based on structured query language. Background technique: [0002] The relational database system based on structured query language is the most commonly used and the most efficient database system, and is widely used. In the specific program design of stored procedures or batch processing in the relational database system of structured query language, it is often necessary to write a large number of similar query statements, and the changed parts are mainly table names, column names and other objects that cannot use variables. This requires dynamically constructing query statements from long strings created with concatenation operators such as strings and string variables, and then using the execute string function to execute. This method makes program design more flexible, can effe...

AI Technical Summary

Problems solved by technology

[0004] The present invention is a relatively convenient method for solving the problem that the execution string is limited by the scope and cannot directly transmit variables

[0005] The solution method of the present invention is realized like this: in stored procedure or batch processing, first create temporary table, then insert or update data to temporary table in execution string, then query the data of temporary table outside execution string, thereby solve The problem that variables cannot be passed from inside to outside of the execution string

Images