IBM Books

Application Development Guide

DB2 API Embedded SQL Samples


Table 30. DB2 API Embedded SQL Sample Programs
Sample Program Included APIs
asynrlog

C: asynrlog.sqc

  • sqlurlog - Asynchronous Read Log

bindfile

C: bindfile.sqc

  • sqlabndx - Bind

dbauth

C: dbauth.sqc

COBOL: dbauth.sqb

  • sqluadau - Get Authorizations

dbstat

C: dbstat.sqc

COBOL: dbstat.sqb

  • sqlureot - Reorganize Table

  • sqlustat - Runstats

expsamp

C: expsamp.sqc

COBOL: expsamp.sqb

  • sqluexpr - Export

  • sqluimpr - Import

impexp

C: impexp.sqc

COBOL: impexp.sqb

  • sqluexpr - Export

  • sqluimpr - Import

loadqry

C: loadqry.sqc

  • db2LoadQuery - Load Query

makeapi

C: makeapi.sqc

  • sqlabndx - Bind

  • sqlaprep - Precompile Program

  • sqlepstp - Stop Database Manager

  • sqlepstr - Start Database Manager

qload

C: qload.sqc

COBOL: qload.sqb

  • sqluqry - Load Query

rebind

C: rebind.sqc

COBOL: rebind.sqb

  • sqlarbnd - Rebind

rechist

C: rechist.sqc

  • sqlubkp - Backup Database

  • sqluhcls - Close Recovery History File Scan

  • sqluhgne - Get Next Recovery History File Entry

  • sqluhops - Open Recovery History File Scan

  • sqluhprn - Prune Recovery History File

  • sqluhupd - Update Recovery History File

tabscont

C: tabscont.sqc

COBOL: tabscont.sqb

  • sqlbctcq - Close Tablespace Container Query

  • sqlbftcq - Fetch Tablespace Container Query

  • sqlbotcq - Open Tablespace Container Query

  • sqlbtcq - Tablespace Container Query

  • sqlefmem - Free Memory

tabspace

C: tabspace.sqc

COBOL: tabspace.sqb

  • sqlbctsq - Close Tablespace Query

  • sqlbftpq - Fetch Tablespace Query

  • sqlbgtss - Get Tablespace Statistics

  • sqlbmtsq - Tablespace Query

  • sqlbotsq - Open Tablespace Query

  • sqlbstpq - Single Tablespace Query

  • sqlefmem - Free Memory

tload

C: tload.sqc

COBOL: tload.sqb

  • sqluexpr - Export

  • sqluload - Load

  • sqluvqdp - Quiesce Tablespaces for Table

tspace

C: tspace.sqc

COBOL: tspace.sqb

  • sqlbctcq - Close Tablespace Container Query

  • sqlbctsq - Close Tablespace Query

  • sqlbftcq - Fetch Tablespace Container Query

  • sqlbftpq - Fetch Tablespace Query

  • sqlbgtss - Get Tablespace Statistics

  • sqlbmtsq - Tablespace Query

  • sqlbotcq - Open Tablespace Container Query

  • sqlbotsq - Open Tablespace Query

  • sqlbstpq - Single Tablespace Query

  • sqlbstsc - Set Tablespace Containers

  • sqlbtcq - Tablespace Container Query

  • sqlefmem - Free Memory

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]