Using SQL in different environments

You can use SQL in many different environments.

Using a cursor
When SQL runs a SELECT statement, the resulting rows comprise the result table. A cursor provides a way to access a result table.
Dynamic SQL applications
Dynamic SQL allows an application to define and run SQL statements at program run time. An application that uses dynamic SQL either accepts an SQL statement as input or builds an SQL statement in the form of a character string. The application does not need to know the type of the SQL statement.
Using interactive SQL
Interactive SQL allows a programmer or a database administrator to quickly and easily define, update, delete, or look at data for testing, problem analysis, and database maintenance.
Using the SQL statement processor
The SQL statement processor allows SQL statements to be run from a source member or a source stream file. The statements in the source can be run repeatedly or changed without compiling the source. This makes the setup of a database environment easier.
Using the RUNSQL CL command
The RUNSQL CL command allows an SQL statement to be run from within a CL program without needing a source file.

Parent topic: SQL programming