Bufop - precompiler for programmers using C/C++ and the IBM DB2/2.
Bufop is a replacement for the IBM sqlprep program that comes standard with the IBM DB2/2 database. However, this version is designed for, and has better support for C programmers (read & write to/from structures) and C++ programmers who can embed SQL into their classes.
Use - the same format of the sqlprep is used as input to Bufop.(don't support line numbers yet).
Features:
The SQL INCLUDE 'filename' will process the include file name without embedding the file into the source. This implies the class definitions and structures can be defined in a header file(s). This facility allows a single program can be built to process an entire project.
example
EXEC SQL INCLUDE 'proga.sqc' // which also includes headers
EXEC SQL INCLUDE 'progb.sqc' // which also includes headers
EXEC SQL INCLUDE 'progc.sqc' // which includes headers and other programs
Read to & write from a structure
Read into & write from within a class (including inherited attributes that are public or protected).
The optional use of booleans on WHENEVER statements. (Can generate a goto or set a Boolean for program inspection - great for do while found loops)
slightly better diagnostics in the event of an error in an SQL statement (all used variables are dumped along with their types)
future
direct support for date and time data types
clean up of the generated code
better examples and starter stuff.
better optimization (the current optimization is dangerous because the addresses of the structures or class data could change with each call)
A note about the example:
The sample code was developed to test some of the features of the precompiler. Style and performance were not much of a consideration when these test cases were developed. Also - If you do not have the IBM C/Set++ compiler, the use of the container class could be removed or replaced.
BETA Restrictions
THIS IS A BETA - I have not had the time to do extensive testing on all of the input options.
I have not tested user defined SQLDAs ( and I'll bet they don't work)
I do not yet support variable length strings with two byte lengths (i.e. structures for this data type).
The product is still a little fragile when encountering some errors.
If you have any suggestions for improvements/changes to this product please either write to me or E-Mail on compuserve.
IMPORTANT - this is a beta, USE AT YOUR OWN RISK. While every effort has been made to make this a useful product, there is no guarantee it will meet all of your requirements.
If you would like a copy of the finished product, full documentation and more extensive examples using PM & the container classes, then please send a check for $25.00 (US) for each developer to::
Ross Software
1625 Red Mill Drive
Upper St Clair, PA 15241.
The product should be finished by the end of November.
