Application Development Guide

DB2 API Embedded SQL Samples

Table 41. DB2 API Embedded SQL Sample Programs

Sample Program	Included APIs
asynrlog C: asynrlog.sqc	sqlurlog - Asynchronous Read Log
autocfg C: autocfg.sqc C++: autocfg.sqC	db2AutoConfig -- Autoconfig db2AutoConfigMemory -- Autoconfig Free Memory sqlfudb -- Update Database Configuration sqlfusys -- Update Database Manager Configuration sqlesetc -- Set Client sqlaintp -- SQLCA Message
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
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
utilemb C: utilemb.sqc C++: utilemb.C	sqlaintp - Get Error Message sqlogstt - Get SQLSTATE Message