Choose your database:

Partners

Customers

Become a customer

SQL Maestro Group / Products / DB2 / DB2 Code Factory / Documentation

Download

Buy

DB2 Code Factory online Help

Return to chapter overview

Both SQL Editor and Visual Query Builder admit to using parameters inside the query text. A parameter is a kind of variable. Its value can be specified just before the query execution in the Parameters window. In the query text the parameter should appear as an identifier with a colon (':') at its beginning, e.g. :param1.

The Parameters dialog is used to specify the query parameters as well as values of the input parameters of procedures or functions before the execution. Enter parameter values and click the OK button to apply the values and execute the query or use the Cancel button to abort the execution.

Note: To allow use parameters in query text, check the corresponding option at the Tools tab of DB2 Code Factory Options.

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

News

Apr 10, 2017

Code Factories advanced to version 17.4

New version features colored tabs, new encryption algorithms in data grids, enhanced data input forms, updated data export/import tools and a lot of other useful things.

Sep 20, 2013

Code Factories are updated to version 13.9

New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many other useful things.

Mar 5, 2012

Code Factories advanced to version 12.3

New version introduces Unicode support in editors, updated code folding appearance, viewing BLOB data as PDF, data import from ODBC data source, Spanish translation and a lot of other new features.

More news

Resources

How to add inline buttons to a webpage created with PHP Generator?

The article shows how to implement an AJAX-based one-click editor for a logical column.

Investigating NBA demo. Part 1: Customizing common templates

This article begins a series of step-by-step tutorials on how we made the NBA demo. It explains how to add new items to the menu, implement run-time theme selection, and tweak the login form.

How to add a chart to a webpage created with PHP Generator?

The article illustrates how to use various chart libraries with PHP Generator.

More resources

Feature of the day

Code folding

With DB2 Code Factory editors it is possible to separate SQL scripts into regions that can be individually collapsed or expanded.

Visual Query Builder

DB2 Code Factory allows to design queries as visual diagrams.

DB2 Code Factory online Help

Query Parameters

Thanksgiving Sale