Embedded SQL

DB2 SQL CURSOR : BASIC

SQL CURSORS Result Set of a SELECT Statement which returns more than one row is easy to view on SQL interface like STRSQL. But How we can handle this result set pragmatically in Embedded SQL or SQL/PL code? Answer is SQL CURSOR. CURSOR provides a simple way to access Result Set returned by SELECT Statement. You can think of CURSOR as a [...]


IBM i SQL

DB2 SQL GLOBAL VARIABLES

GLOBAL VARIABLES GLOBAL VARIABLES are database objects to save a single value at a time(like DTAARA object) They can be accessed and modified using SQL statements. Their definition (only definition, not actual value) is stored in the database catalogs. The reason for this is that global variables have a session scope. This means that [...]





IBM i SQL

DB2 SQL GLOBAL TEMPORARY TABLE

Global Temporary Table DECLARE GLOBAL TEMPORARY TABLE gives you a handy option to create table in QTEMP lib with some very useful options. As DECLARE GLOBAL TEMPORARY TABLE creates table in QTEMP lib so It cannot be shared by other sessions. It does not appear in the system catalog. When you end your session, the rows of the table are [...]








DOWNLOADS

QSql: GUI for DB2 for IBM i.