什么是db2的静态SQL

fjg0

请问：什么是db2的静态SQL？如何绑定应用？

wangzhonnewnew

generally speaking, a static sql can be considered as the access plan for the query only be generated once and kept in package, so that all further access to this "package" will use the pre-calculated access plan to access data...

fjg0

tks,and how to bind to a application ?

wangzhonnewnew

when you compile a embeded C program, it will generate a bnd file and an executable...
you need to copy the bnd file to sqllib/bnd directory and use bind command to bind the package