As described in Creating static DB2 queries, if you are using DB2, you can run query specs either dynamically or statically. This section describes how to create a package spec, and add queries, so you precompile the SQL statements before runtime.