SQL statement size

 

The create SQL package function might not be able to handle an SQL statement of the same size that the precompiler can process.

While the SQL program is being precompiled, the SQL statement is placed into the associated space of the program. When this occurs, each token is separated by a blank. In addition, when the RDB parameter is specified, the host variables of the source statement are replaced with an 'H'. The create SQL package function passes this statement to the application server, along with a list of the host variables for that statement. The addition of the blanks between the tokens and the replacement of host variables can cause the statement to exceed the maximum SQL statement size (SQL0101 reason 5).

 

Parent topic:

Considerations for creating an SQL package