IBM Books

What's New

Changes to Chapter 1. About the DB2 Software Developer's Kit

The following addition applies to page 1, in the paragraph beginning: "The DB2 SDKs for the Windows and OS/2 platforms". Add the following list item after the list item beginning: "DB2 Java Database Connectivity":

The following changes apply to page 1, in the paragraph beginning: "The DB2 SDKs for the Windows and OS/2 platforms":

Change the list item beginning "On OS/2, Windows NT" to the following:

Change the list item beginning "A documented API" to the following:

The "Sample Programs" section on page 4 should be replaced with the following:

Sample Programs

The DB2 SDK comes with sample programs. The file extensions for each supported language, and the directories where the programs can be found on the supported paltforms, are given in Table 10. In addition, the locations and extensions for other sample programs can be found in Table 11.

The sample programs providing examples of embedded SQL (except for Java), and DB2 API calls are shown in Table 12. Log Management User Exit programs are shown in Table 13. Command Line Processor (CLP) programs provided by DB2 are shown in Table 14.

Java JDBC sample programs are shown in Table 15. Java SQLJ sample programs are shown in Table 16.

Object Linking and Embedding (OLE) sample programs are shown in Table 17. The sample programs demonstrating DB2 CLI calls are shown in Table 18.

You can use the sample programs to learn how to code your applications.
Note:Not all sample programs have been ported to all the supported programming languages.

Table 10. Sample Program File Extensions and Locations
Language Embedded SQL Programs Non-embedded SQL Programs
C File Ext. .sqc .c
Directory samples/c 
samples/c samples/cli (CLI programs)


C++
File Ext.


.sqC (UNIX)
.sqx (Windows & OS/2)





.C (UNIX)
.cxx (Windows & OS/2)



Directory
samples/cpp
samples/cpp


COBOL
File Ext.
.sqb
.cbl

Directory


samples/cobol
samples/cobol_mf





samples/cobol
samples/cobol_mf




Fortran
File Ext.
.sqf


.f (UNIX)
.for (OS/2)



Directory
samples/fortran
samples/fortran


JAVA
File Ext.
.sqlj
.java

Directory
samples/java
samples/java


REXX
File Ext.
.cmd
.cmd

Directory
samples/rexx
samples/rexx





Table 11. Other Samples, their Extensions and Locations





Sample Group



CLP
File Ext.
.db2

Directory
samples/clp


OLE
File Ext.


.bas (Microsoft Visual Basic)
.CPP (Microsoft Visual C++)



Directory


samples\ole\msvb (Microsoft Visual Basic)
samples\ole\msvc (Microsoft Visual C++)


User Exit
File Ext.


.cad (Windows & OS/2)
.cadsm (UNIX)
.cdisk (UNIX)
.ctape (UNIX)



Directory
samples/c



Note:



Embedded SQL Programs

require precompilation, except for REXX embedded SQL programs where the
embedded SQL statements are interpreted when the program is run.

Directory Delimiters

On UNIX are /. On OS/2 and Windows platforms, are
\. In the tables, the UNIX delimiters are used unless
the directory is only available on Windows and/or OS/2.

IBM COBOL samples

Are only supplied on the OS/2, AIX, Windows NT and Windows 95 platforms in
the cobol subdirectory.

Micro Focus Cobol Samples

Are supplied on all platforms except the Macintosh and Silicon Graphics
IRIX. The 16-bit Micro Focus COBOL examples are supplied in the
cobol_16 subdirectory on OS/2, and the cobol
subdirectory on Windows 3.1. For all other platforms, the Micro
Focus COBOL samples are in the cobol_mf subdirectory.

Fortran Samples

Are only supplied on the AIX, HP-UX, Silicon Graphics IRIX, Solaris, and
OS/2 platforms.

Java Samples

Are Java Database Connectivity (JDBC) applications, applets, stored
procedures and UDFs, and embedded SQL (SQLJ) applications, applets, stored
procedures and UDFs. Java samples are available on the AIX, HP-UX, SCO
UnixWare 7, Silicon Graphics IRIX, Solaris, OS/2, Windows NT, Windows 98, and
Windows 95 platforms.

REXX Samples

Are only supplied on the AIX, OS/2, and Windows NT platforms.

CLP Samples

Are Command Line Processor scripts that execute SQL statements.

OLE Samples

Are for Object Linking and Embedding (OLE) in Microsoft Visual Basic and
Microsoft Visual C++, supplied on the Windows NT and Windows 95
platforms only.

User Exit samples

Are Log Management User Exit programs used to archive and retrieve
database log files. The files must be renamed with a
.c extension and compiled as C language programs.





You can find the sample programs in the samples subdirectory of
the directory where DB2 has been installed. There is a subdirectory for
each supported language. The following examples show you how to locate
the samples written in C or C++ on each supported platform.



The sample programs directory is typically read-only on most
platforms. Before you alter or build the sample programs, copy them to
your working directory. On the Macintosh, copy them to your working
folder.

Note:The sample programs that are shipped with DB2 Universal Database have
dependencies on the English version of the sample database and the
associated table and column names. If the sample database
has been translated into another national language on your version of DB2
Universal Database, you need to update the name of the sample
database, and the names of the tables and the columns coded in the supplied
sample programs, to the names used in the translated sample
database. Otherwise, you will experience problems running the sample
programs as shipped. 

Currently, the sample database is translated into the following
languages: 

    

  • Brazilian Portuguese

  • French

  • Korean

  • Norwegian

  • Simplified Chinese





In Table 12, 'Yes', in the Embedded SQL column, indicates that the
program contains embedded SQL. A blank indicates that the program does
not contain embedded SQL, and thus no precompiling is required.



Table 12. Sample Programs Showing Embedded SQL and APIs





Sample Program Name
Embedded SQL
Program Description


adhoc
Yes
Demonstrates dynamic SQL and the SQLDA structure to process SQL commands
interactively. SQL commands are input by the user, and output
corresponding to the SQL command is returned.


advsql
Yes
Demonstrates the use of advanced SQL expressions like CASE, CAST, and
scalar full selects.


asynrlog
Yes
Demonstrates the use of the following API: 

   ASYNCHRONOUS LOG READ




backrest


Demonstrates the use of the following APIs: 

   BACKUP DATABASE
   RESTORE DATABASE
   ROLL FORWARD DATABASE




blobfile
Yes
Demonstrates the manipulation of a Binary Large Object (BLOB), by reading
a BLOB value from the sample database and placing it in a file, the contents
of which can be displayed using an external viewer.


bindfile
Yes
Demonstrates the use of the BIND API to bind an embedded SQL application
to a database.


calludf
Yes
Demonstrates the use of the library of User-Defined Functions (UDFs)
created by udf for the sample database tables.


client


Demonstrates the use of the following APIs: 

   SET CLIENT
   QUERY CLIENT




columns
Yes
Demonstrates the use of a cursor that is processed using dynamic
SQL. This program lists all the entries in the system table,
SYSIBM.SYSTABLES, under a desired schema name.


cursor
Yes
Demonstrates the use of a cursor using static SQL.


d_dbconf


Demonstrates the use of the following API: 

   GET DATABASE CONFIGURATION DEFAULTS




d_dbmcon


Demonstrates the use of the following API: 

   GET DATABASE MANAGER CONFIGURATION DEFAULTS




db2mon


Demonstrates how to use the Database System Monitor APIs, and how to
process the output data buffer returned from the Snapshot API.


dbauth
Yes
Demonstrates the use of the following API: 

   GET AUTHORIZATIONS




dbcat


Demonstrates the use of the following APIs: 

   CATALOG DATABASE
   CLOSE DATABASE DIRECTORY SCAN
   GET NEXT DATABASE DIRECTORY ENTRY
   OPEN DATABASE DIRECTORY SCAN
   UNCATALOG DATABASE




dbcmt


Demonstrates the use of the following APIs: 

   CHANGE DATABASE COMMENT




dbconf


Demonstrates the use of the following APIs: 

   CREATE DATABASE
   DROP DATABASE
   GET DATABASE CONFIGURATION
   RESET DATABASE CONFIGURATION
   UPDATE DATABASE CONFIGURATION




dbinst


Demonstrates the use of the following APIs: 

   ATTACH TO INSTANCE
   DETACH FROM INSTANCE
   GET INSTANCE




dbmconf


Demonstrates the use of the following APIs: 

   GET DATABASE MANAGER CONFIGURATION
   RESET DATABASE MANAGER CONFIGURATION
   UPDATE DATABASE MANAGER CONFIGURATION




dbsnap


Demonstrates the use of the following API: 

   DATABASE SYSTEM MONITOR SNAPSHOT




dbstart


Demonstrates the use of the following API: 

   START DATABASE MANAGER




dbstat
Yes
Demonstrates the use of the following APIs: 

   REORGANIZE TABLE
   RUN STATISTICS




dbstop


Demonstrates the use of the following APIs: 

   FORCE USERS
   STOP DATABASE MANAGER




db_udcs


Demonstrates the use of the following APIs in order to simulate the
collating behavior of a DB2 for OS/390 CCSID 500 (EBCDIC International)
collating sequence: 

   CREATE DATABASE
   DROP DATABASE




dcscat


Demonstrates the use of the following APIs: 

   ADD DCS DIRECTORY ENTRY
   CLOSE DCS DIRECTORY SCAN
   GET DCS DIRECTORY ENTRY FOR DATABASE
   GET DCS DIRECTORY ENTRIES
   OPEN DCS DIRECTORY SCAN
   UNCATALOG DCS DIRECTORY ENTRY




delet
Yes
Demonstrates static SQL to delete items from a database.


dmscont


Demonstrates the use of the following APIs in order to create a database
with more than one database managed storage (DMS) container: 

   CREATE DATABASE
   DROP DATABASE




dynamic
Yes
Demonstrates the use of a cursor using dynamic SQL.


ebcdicdb


Demonstrates the use of the following APIs in order to simulate the
collating behavior of a DB2 for OS/390 CCSID 037 (EBCDIC US English) collating
sequence: 

   CREATE DATABASE
   DROP DATABASE




expsamp
Yes
Demonstrates the use of the following APIs: 

   EXPORT
   IMPORT

 in conjunction with a DRDA database.


fillcli
Yes
Demonstrates the client-side of a stored procedure that uses the SQLDA to
pass information specifying which table the stored procedure populates with
random data.


fillsrv
Yes
Demonstrates the server-side of a stored procedure example that uses the
SQLDA to receive information from the client specifying the table that the
stored procedure populates with random data.


impexp
Yes
Demonstrates the use of the following APIs: 

   EXPORT
   IMPORT




inpcli
Yes
Demonstrates stored procedures using either the SQLDA structure or host
variables. This is the client program of a client/server
example. (The server program is called inpsrv.) The
program fills the SQLDA with information, and passes it to the server program
for further processing. The SQLCA status is returned to the client
program. This program shows the invocation of stored procedures using
an embedded SQL CALL statement.


inpsrv
Yes
Demonstrates stored procedures using the SQLDA structure. This is
the server program of a client/server example. (The client program is
called inpcli.) The program creates a table
(PRESIDENTS) in the sample database with the information
received in the SQLDA. The server program does all the database
processing and returns the SQLCA status to the client program.


joinsql
Yes
An example using advanced SQL join expressions.


largevol
Yes
Demonstrates parallel query processing in a partitioned environment, and
the use of an NFS file system to automate the merging of the result
sets.


lobeval
Yes
Demonstrates the use of LOB locators and deferring the evaluation of the
actual LOB data.


lobfile
Yes
Demonstrates the use of LOB file handles.


lobloc
Yes
Demonstrates the use of LOB locators.


lobval
Yes
Demonstrates the use of LOBs.


makeapi
Yes
Demonstrates the use of the following APIs: 

   BIND
   PRECOMPILE PROGRAM
   START DATABASE MANAGER
   STOP DATABASE MANAGER




migrate


Demonstrates the use of the following API: 

   MIGRATE DATABASE




monreset


Demonstrates the use of the following API: 

   RESET DATABASE SYSTEM MONITOR DATA AREAS




monsz


Demonstrates the use of the following APIs: 

   ESTIMATE DATABASE SYSTEM MONITOR BUFFER SIZE
   DATABASE SYSTEM MONITOR SNAPSHOT




nodecat


Demonstrates the use of the following APIs: 

   CATALOG NODE
   CLOSE NODE DIRECTORY SCAN
   GET NEXT NODE DIRECTORY ENTRY
   OPEN NODE DIRECTORY SCAN
   UNCATALOG NODE




openftch
Yes
Demonstrates fetching, updating, and deleting of rows using static
SQL.


outcli
Yes
Demonstrates stored procedures using the SQLDA structure. This is
the client program of a client/server example. (The server program is
called outsrv.) This program allocates and initializes a one
variable SQLDA, and passes it to the server program for further
processing. The filled SQLDA is returned to the client program along
with the SQLCA status. This program shows the invocation of stored
procedures using an embedded SQL CALL statement.


outsrv
Yes
Demonstrates stored procedures using the SQLDA structure. This is
the server program of a client/server example. (The client program is
called outcli.) The program fills the SQLDA with the median
SALARY of the employees in the STAFF table of the
sample database. The server program does all the database
processing (finding the median). The server program returns the filled
SQLDA and the SQLCA status to the client program.


qload
Yes
Demonstrates the use of the following API: 

   LOAD QUERY




rebind
Yes
Demonstrates the use of the following API: 

   REBIND PACKAGE




rechist


Demonstrates the use of the following APIs: 

   CLOSE RECOVERY HISTORY FILE SCAN
   GET NEXT RECOVERY HISTORY FILE ENTRY
   OPEN RECOVERY HISTORY FILE SCAN
   PRUNE RECOVERY HISTORY FILE ENTRY
   UPDATE RECOVERY HISTORY FILE ENTRY




recursql
Yes
Demonstrates the use of advanced SQL recursive queries.


regder


Demonstrates the use of the following APIs: 

   REGISTER
   DEREGISTER




restart


Demonstrates the use of the following API: 

   RESTART DATABASE




sampudf
Yes
Demonstrates the use of User-Defined Types (UDTs) and User-Defined
Functions (UDFs). The UDFs declared in this program are all sourced
UDFs.


setact


Demonstrates the use of the following API: 

   SET ACCOUNTING STRING




setrundg


Demonstrates the use of the following API: 

   SET RUNTIME DEGREE




static
Yes
Uses static SQL to retrieve information.


sws


Demonstrates the use of the following API: 

   DATABASE MONITOR SWITCH




tabscont


Demonstrates the use of the following APIs: 

   TABLESPACE CONTAINER QUERY
   OPEN TABLESPACE CONTAINER QUERY
   FETCH TABLESPACE CONTAINER QUERY
   CLOSE TABLESPACE CONTAINER QUERY
   SET TABLESPACE CONTAINER QUERY




tabspace


Demonstrates the use of the following APIs: 

   TABLESPACE QUERY
   SINGLE TABLESPACE QUERY
   OPEN TABLESPACE QUERY
   FETCH TABLESPACE QUERY
   GET TABLESPACE STATISTICS
   CLOSE TABLESPACE QUERY




tabsql
Yes
Demonstrates the use of advanced SQL table expressions.


tblcli


Demonstrates a call to a table function (client-side) to display weather
information for a number of cities.


tblsrv


Demonstrates a table function (server-side) that processes weather
information for a number of cities.


thdsrver
Yes
Demonstrates the use of posix threads APIs for thread creation and
management. The program maintains a pool of contexts. A
generate_work function is executed from main, and creates dynamic SQL
statements that are executed by worker threads. When a context becomes
available, a thread is created and dispatched to do the specified work.
The work generated consists of statements to delete entries from either the
STAFF or EMPLOYEE tables of the sample database. This
program is only available on UNIX platforms.


tload
Yes
Demonstrates the use of the following APIs: 

   EXPORT
   QUIESCE TABLESPACE FOR TABLES
   LOAD




trigsql
Yes
An example using advanced SQL triggers and constraints.


udf
Yes
Creates a library of User-Defined Functions (UDFs) made specifically for
the sample database tables, but can be used with tables of
compatible column types.


updat
Yes
Uses static SQL to update a database.


util


Demonstrates the use of the following APIs: 

   GET ERROR MESSAGE
   GET SQLSTATE MESSAGE
   INSTALL SIGNAL HANDLER
   INTERRUPT

 This program also contains code to output information from an
SQLDA.


varinp
Yes
An example of variable input to Embedded Dynamic SQL statement calls
using parameter markers.





Table 13. Log Management User Exit Sample Programs.





Sample File Name
File Description


db2uext2.cadsm
This is a sample User Exit utilizing ADSTAR DSM ( ADSM ) APIs to archive
and retrieve database log files. The sample provides an audit trail of
calls (stored in a separate file for each option) including a timestamp and
parameters received. It also provides an error trail of calls in error
including a timestamp and an error isolation string for problem
determination. These options can be disabled. The file must be
renamed db2uext2.c and compiled as a C program.
Available on supported UNIX platforms only. The Windows NT version is
db2uext2.cad. The OS/2 version is
db2uexit.cad.


db2uext2.cad
This is the Windows NT version of db2uext2.cadsm. The file
must be renamed db2uext2.c and compiled as a C
program.


db2uexit.cad
This is the OS/2 version of db2uext2.cadsm. The file must
be renamed db2uexit.c and compiled as a C program.


db2uext2.cdisk
This is a sample User Exit utilizing the AIX system copy command to
archive and retrieve database log files. The sample provides an audit
trail of calls (stored in a separate file for each option) including a
timestamp and parameters received. It also provides an error trail of
calls in error including a timestamp and an error isolation string for problem
determination. These options can be disabled. The file must be
renamed db2uext2.c and compiled as a C program.
Available on supported UNIX platforms only.


db2uext2.ctape
This is a sample User Exit utilizing the SUN system tape commands to
archive and retrieve database log files. All limitations of the SUN
system tape commands are limitations of this user exit. The sample
provides an audit trail of calls (stored in a separate file for each option)
including a timestamp and parameters received. It also provides an
error trail of calls in error including a timestamp and an error isolation
string for problem determination. These options can be disabled.
The file must be renamed db2uext2.c and compiled as a C
program. Available on supported UNIX platforms only.





Table 14. Command Line Processor (CLP) Sample Programs.





Sample Program Name
Program Description


const
Creates a table with a CHECK CONSTRAINT clause.


cte
Demonstrates a common table expression. The equivalent sample
program demonstrating this advanced SQL statement is tabsql.


flt
Demonstrates a recursive query. The equivalent sample program
demonstrating this advanced SQL statement is recursql.


join
Demonstrates an outer join of tables. The equivalent sample
program demonstrating this advanced SQL statement is
joinsql.


stock
Demonstrates the use of triggers. The equivalent sample program
demonstrating this advanced SQL statement is trigsql.


testdata
Uses DB2 built-in functions such as RAND() and TRANSLATE() to populate a
table with randomly generated test data.


thaisort
This script is particularly for Thai users. Thai sorting is by
phonetic order requiring pre-sorting/swapping of the leading vowel and its
consonant, as well as post-sorting in order to view the data in the correct
sort order. The file implements Thai sorting by creating UDF functions
presort and postsort, and creating a table; then it calls the functions
against the table to sort the table data. To run this program, you
first have to build the user-defined function program, udf, from
the C source file, udf.c.





Table 15. Java Database Connectivity (JDBC) Sample Programs





Sample Program Name
Program Description


DB2Appl.java
A JDBC application that queries the sample database using the invoking
user's privileges.


DB2Applt.java
A JDBC applet that queries the sample database using a user and server
specified as applet parameters.


DB2Applt.html
An HTML file that embeds the applet sample program,
DB2Applt. It needs to be customized with server and user
information.


DB2Stp.java
A Java stored procedure that updates the EMPLOYEE table on the server,
and returns new salary and payroll information to the client.


DB2Udf.java
A Java UDF that demonstrates several tasks, including integer division,
manipulation of Character Large OBjects (CLOBs), and the use of Java instance
variables.





Table 16. Embedded SQL for Java (SQLJ) Sample Programs





Sample Program Name
Program Description


App.sqlj
An SQLJ application that uses static SQL to retrieve and update data from
the EMPLOYEE table of the sample database.


Applt.sqlj
An SQLJ applet that queries the sample database using a user and server
specified as applet parameters.


Applt.html
An HTML file that embeds the applet sample program,
Applt. It needs to be customized with server and user
information.


Stp.sqlj
An embedded SQL (SQLJ) stored procedure that updates the EMPLOYEE table
on the server, and returns new salary and payroll information to the
client.


CatUdf.sqlj
An SQLJ program that demonstrates cataloging Java UDFs and creating a
sample table, udftest, for testing them.


Udf.sqlj
An SQLJ program that demonstrates calling Java UDFs against the sample
table, udftest.


DropUdf.sqlj
An SQLJ program that demonstrates dropping Java UDFs and the sample
table, udftest.





Table 17. Object Linking and Embedding (OLE) Sample Programs





Sample Program Name
Program Description


sales
Demonstrates rollup queries on a Microsoft Excel sales spreadsheet
(implemented in Visual Basic).


names
Queries a Lotus Notes address book (implemented in Visual Basic).


inbox
Queries Microsoft Exchange inbox e-mail messages through OLE/Messaging
(implemented in Visual Basic).


invoice
An OLE automation user-defined function that sends Microsoft Word invoice
documents as e-mail attachments (implemented in Visual Basic).


ccounter
A counter OLE automation user-defined function (implemented in Visual
C++).


salarysrv
An OLE automation stored procedure that calculates the median salary of
the STAFF table of the sample database (implemented in Visual
Basic).


salaryclt
A client program that invokes the median salary OLE automation stored
procedure salarysrv (implemented in Visual Basic and in Visual
C++).





Table 18. 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


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 resume clob 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 library


Version 2 Samples unchanged


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




Note:Samples marked with a ** are new for this release. 

Other files in the samples/cli directory include: 

    

  • README - Lists all example files.

  • makefile - Makefile for all files







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


[ DB2 List of Books |
Search the DB2 Books ]