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 dynamic SQL through client interfaces
  You can access DB2^® UDB for iSeries data through client interfaces on the server.

• 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. The statements in the source member can be run repeatedly, or changed, without compiling the source. This makes the setup of a database environment easier.

 

Parent topic:

SQL programming