Table 33. Sample CLI Programs in DB2 Universal Database
| Sample Program Name | Program Description | ||
|---|---|---|---|
| Utility files used by most CLI samples | |||
|
samputil.c
| Utility functions used by most samples | ||
|
samputil.h
| Header file for samputil.c, included by most samples | ||
| General CLI Samples | |||
|
adhoc.c
| Interactive SQL with formatted output (was typical.c) | ||
|
async.c
| Run a function asynchronously (based on fetch.c) | ||
|
basiccon.c
| Basic connection | ||
|
browser.c
| List columns, foreign keys, index columns or stats for a table | ||
|
calludf.c
| Register and call a UDF | ||
|
colpriv.c
| List column Privileges | ||
|
columns.c
| List all columns for table search string | ||
|
compnd.c
| Compound SQL example | ||
|
datasour.c
| List all available data sources | ||
|
descrptr.c
| Example of descriptor usage | ||
|
drivrcon.c
| Rewrite of basiccon.c using SQLDriverConnect | ||
|
duowcon.c
| Multiple DUOW Connect type 2, syncpoint 1 (one phase commit) | ||
|
embedded.c
| Show equivalent DB2 CLI calls, for embedded SQL (in comments) | ||
|
fetch.c
| Simple example of a fetch sequence | ||
|
getattrs.c
| List some common environment, connection and statement options/attributes | ||
|
getcurs.c
| Show use of SQLGetCursor, and positioned update | ||
|
getdata.c
| Rewrite of fetch.c using SQLGetData instead of SQLBindCol | ||
|
getfuncs.c
| List all supported functions | ||
|
getfuncs.h
| Header file for getfuncs.c | ||
|
getinfo.c
| Use SQLGetInfo to get driver version and other information | ||
|
getsqlca.c
| Rewrite of adhoc.c to use prepare/execute and show cost estimate | ||
|
lookres.c
| Extract string from the resume clob field using locators | ||
|
mixed.sqc
| CLI sample with functions written using embedded SQL (Note: This file must be precompiled ) | ||
|
multicon.c
| Multiple connections | ||
|
native.c
| Simple example of calling SQLNativeSql, and SQLNumParams | ||
|
prepare.c
| Rewrite of fetch.c, using prepare/execute instead of execdirect | ||
|
proccols.c
| List procedure parameters using SQLProcedureColumns | ||
|
procs.c
| List procedures using SQLProcedures | ||
|
sfetch.c
| Scrollable cursor example (based on xfetch.c) | ||
|
setcolat.c
| Set column attributes (using SQLSetColAttributes) | ||
|
setcurs.c
| Rewrite of getcurs.c using SQLSetCurs for positioned update | ||
|
seteattr.c
| Set environment attribute (SQL_ATTR_OUTPUT_NTS) | ||
|
tables.c
| List all tables | ||
|
typeinfo.c
| Display type information for all types for current data source | ||
| xfetch.c | Extended Fetch, multiple rows per fetch | ||
| BLOB Samples | |||
|
picin.c
| Loads graphic BLOBS into the emp_photo table directly from a file using SQLBindParamToFile | ||
|
picin2.c
| Loads graphic BLOBS into the emp_photo table using SQLPutData | ||
|
showpic.c
| Extracts BLOB picture to file (using SQLBindColToFile), then displays the graphic. | ||
|
showpic2.c
| Extracts BLOB picture to file using piecewise output, then displays the graphic. | ||
| Stored Procedure Samples | |||
|
clicall.c
| Defines a CLI function which is used in the embedded SQL sample mrspcli3.sqc | ||
|
inpcli.c
| Call embedded input stored procedure samples/c/inpsrv | ||
|
inpcli2.c
| Call CLI input stored procedure inpsrv2 | ||
|
inpsrv2.c
| CLI input stored procedure (rewrite of embedded sample inpsrv.sqc) | ||
|
mrspcli.c
| CLI program that calls mrspsrv.c | ||
|
mrspcli2.c
| CLI program that calls mrspsrv2.sqc | ||
|
mrspcli3.sqc
| An embedded SQL program that calls mrspsrv2.sqc using clicall.c | ||
|
mrspsrv.c
| Stored procedure that returns a multi-row result set | ||
|
mrspsrv2.sqc
| An embedded SQL stored procedure that returns a multi-row result set | ||
|
outcli.c
| Call embedded output stored procedure samples/c/inpsrv | ||
|
outcli2.c
| Call CLI output stored procedure inpsrv2 | ||
|
outsrv2.c
| CLI output stored procedure (rewrite of embedded sample inpsrv.sqc) | ||
| Samples using ORDER tables created by create.c (Run in the following order) | |||
|
create.c
| Creates all tables for the order scenario | ||
|
custin.c
| Inserts customers into the customer table (array insert) | ||
|
prodin.c
| Inserts products into the products table (array insert) | ||
|
prodpart.c
| Inserts parts into the prod_parts table (array insert) | ||
|
ordin.c
| Inserts orders into the ord_line, ord_cust tables (array insert) | ||
|
ordrep.c
| Generates order report using multiple result sets | ||
|
partrep.c
| Generates exploding parts report (recursive SQL Query) | ||
|
order.c
| UDF library code (declares a 'price' UDF) | ||
| order.exp | Used to build order libary | ||
| Samples unchanged from DB2 Version 2 | |||
|
v2sutil.c
| samputil.c using old v2 functions | ||
|
v2sutil.h
| samputil.h using old v2 functions | ||
|
v2fetch.c
| fetch.c using old v2 functions | ||
|
v2xfetch.c
| xfetch.c using old v2 functions | ||
| |||