DB2 graphic QMF Version 8

Replacing substitution variables

When you bind a package, you must specify a host variable to use in place of each substitution variable in the SQL text. However, a substitution variable cannot always be directly replaced by a host variable. Substitution variables provide direct text substitution in the query text before the text is sent to the database server. Host variables are sent as part of the query to the database server. Refer to the documentation for your database server for rules on where and how host variables can be used in queries.

After you specify a relationship between a substitution variable and a host variable, QMF for Windows remembers the relationship, and suggests it in future queries, making binding packages simpler.

The valid data types for host variables are:


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004