Application Development Guide

DB2 API Non-Embedded SQL Samples

Table 40. DB2 API Sample Programs with No Embedded SQL

Sample Program	Included APIs
backrest C: backrest.c	sqlbftcq - Fetch Tablespace Container Query sqlbstsc - Set Tablespace Containers sqlfudb - Update Database Configuration sqlubkp - Backup Database sqluroll - Rollforward Database sqlurst - Restore Database
checkerr COBOL: checkerr.cbl	sqlaintp - Get Error Message sqlogstt - Get SQLSTATE Message
cli_info C: cli_info.c	sqleqryi - Query Client Information sqleseti - Set Client Information
client C: client.c C++: client.C COBOL: client.cbl	sqleqryc - Query Client sqlesetc - Set Client
d_dbconf C: d_dbconf.c COBOL: d_dbconf.cbl	sqleatin - Attach sqledtin - Detach sqlfddb - Get Database Configuration Defaults
d_dbmcon C: d_dbmcon.c COBOL: d_dbmcon.cbl	sqleatin - Attach sqledtin - Detach sqlfdsys - Get Database Manager Configuration Defaults
db_udcs C: db_udcs.c COBOL: db_udcs.cbl	sqleatin - Attach sqlecrea - Create Database sqledrpd - Drop Database
db2mon C: db2mon.c	sqleatin - Attach sqlmon - Get/Update Monitor Switches sqlmonss - Get Snapshot sqlmonsz - Estimate Size Required for sqlmonss() Output Buffer sqlmrset - Reset Monitor
dbcat C: dbcat.c COBOL: dbcat.cbl	sqlecadb - Catalog Database sqledcls - Close Database Directory Scan sqledgne - Get Next Database Directory Entry sqledosd - Open Database Directory Scan sqleuncd - Uncatalog Database
dbcmt C: dbcmt.c COBOL: dbcmt.cbl	sqledcgd - Change Database Comment sqledcls - Close Database Directory Scan sqledgne - Get Next Database Directory Entry sqledosd - Open Database Directory Scan sqleisig - Install Signal Handler
dbconf C: dbconf.c COBOL: dbconf.cbl	sqleatin - Attach sqlecrea - Create Database sqledrpd - Drop Database sqlfrdb - Reset Database Configuration sqlfudb - Update Database Configuration sqlfxdb - Get Database Configuration
dbinst C: dbinst.c COBOL: dbinst.cbl	sqleatcp - Attach and Change Password sqleatin - Attach sqledtin - Detach sqlegins - Get Instance
dbmconf C: dbmconf.c COBOL: dbmconf.cbl	sqleatin - Attach sqledtin - Detach sqlfrsys - Reset Database Manager Configuration sqlfusys - Update Database Manager Configuration sqlfxsys - Get Database Manager Configuration
dbsnap C: dbsnap.c COBOL: dbsnap.cbl	sqleatin - Attach sqlmonss - Get Snapshot
dbstart C: dbstart.c COBOL: dbstart.cbl	sqlepstart - Start Database Manager
dbstop C: dbstop.c COBOL: dbstop.cbl	sqlefrce - Force Application sqlepstp - Stop Database Manager
dcscat C: dcscat.c COBOL: dcscat.cbl	sqlegdad - Catalog DCS Database sqlegdcl - Close DCS Directory Scan sqlegdel - Uncatalog DCS Database sqlegdge - Get DCS Directory Entry for Database sqlegdgt - Get DCS Directory Entries sqlegdsc - Open DCS Directory Scan
dmscont C: dmscont.c	sqleatin - Attach sqlecrea - Create Database sqledrpd - Drop Database
ebcdicdb C: ebcdicdb.c COBOL: ebcdicdb.cbl	sqleatin - Attach sqlecrea - Create Database sqledrpd - Drop Database
migrate C: migrate.c COBOL: migrate.cbl	sqlemgdb - Migrate Database
monreset C: monreset.c COBOL: monreset.cbl	sqleatin - Attach sqlmrset - Reset Monitor
monsz C: monsz.c COBOL: monsz.cbl	sqleatin - Attach sqlmonss - Get Snapshot sqlmonsz - Estimate Size Required for sqlmonss() Output Buffer
nodecat C: nodecat.c COBOL: nodecat.cbl	sqlectnd - Catalog Node sqlencls - Close Node Directory Scan sqlengne - Get Next Node Directory Entry sqlenops - Open Node Directory Scan sqleuncn - Uncatalog Node
restart C: restart.c COBOL: restart.cbl	sqlerstd - Restart Database
setact C: setact.c COBOL: setact.cbl	sqlesact - Set Accounting String
setrundg C: setrundg.c	sqlesdeg - Set Runtime Degree
sws C: sws.c COBOL: sws.cbl	sqleatin - Attach sqlmon - Get/Update Monitor Switches
utilapi C: utilapi.c C++: utilapi.C	sqlaintp - Get Error Message sqlogstt - Get SQLSTATE Message