The script file bldCC, in sqllib/samples/cpp, contains the commands to build a sample C++ program.
The first parameter, $1, specifies the name of your source file. The second parameter, $2, specifies the name of the database to which you want to connect. The third parameter, $3, specifies the user ID for the database, and $4, specifies the password. Only the first parameter, the source file name, is required. Database name, user ID, and password are optional. If no database name is supplied, the program uses the default sample database.
#! /bin/ksh # bldCC script file # Builds a sample C++ program containing embedded SQL # Usage: bldCC <prog_name> [ <db_name> [ <userid> <password> ]] # Connect to a database. if (($# < 2)) then db2 connect to sample elif (($# < 3)) then db2 connect to $2 else db2 connect to $2 user $3 using $4 fi # Precompile the program. db2 prep $1.sqC bindfile # Bind the program to the database. db2 bind $1.bnd # Disconnect from the database. db2 connect reset # Compile the util.c error-checking utility. CC -n32 -I/opt/IBMdb2/V5.0/include -c util.C # Compile the program. CC -n32 -I/opt/IBMdb2/V5.0/include -c $1.C # Link the program. CC -n32 -o $1 $1.o util.o -L/opt/IBMdb2/V5.0/lib -rpath /opt/IBMdb2/V5.0/lib -lm -ldb2 |
| Compile and Link Options for bldCC |
|---|
|
The script file contains the following compile options:
|
|
The script file contains the following link options:
Refer to your compiler documentation for additional compiler
options.
|
To build the sample program updat from the source file updat.sqC, connecting to the sample database on the server, enter:
bldCC updat remote_database userid password
where
The result is an executable file, updat. To run the executable file against the sample database, enter:
updat userid password
where
Stored procedures are programs that access the database and return information to the client application. You compile and store stored procedures on the server. The server runs on another platform.
To build the stored procedure outsrv on a UNIX server, refer to the embedded SQL chapter for that platform in this book. If you are using an OS/2 or Windows server, refer to the embedded SQL chapter for that platform in Building Applications for Windows and OS/2 Environments.
Once you build the stored procedure outsrv, you can build the client application that calls the stored procedure, outcli, by using the bldCC script file. Refer to "MIPSpro C++" for details.
To call the stored procedure, run the client application by entering: outcli remote_database userid password
where
The client application passes a variable to the server program outsrv, which gives it a value, and then returns the variable to the client application.