How can I convert DB/C programs to use SQL instead of DB/C files? What problems might I encounter?
DB/C DX supports SQL with the SQLEXEC, SQLMSG and SQLCODE statements via dynamic SQL. The eventual interface to the SQL database engine is done using ODBC, JDBC or a proprietary interface in UNIX. Technical details about how SQLEXEC works can be found in the DB/C Programmer’s Reference manuals, all well as in the June 1993 and the October 1994 DB/C Newsletters. Old newsletters can be found at the Past Issues of the Newsletter link on the DB/C Newsletter page at www.dbcsoftware.com. From experience, we would like to warn you that there are some major problems you will run into if you attempt a conversion to SQL. First, the conversion itself is quite complicated. There are significant differences between the two file systems. Some differences may actually cause you to remove features and functionality from your DB/C programs. Because of the way SQL works, you can’t just replace each READ/WRITE statement with one SQL statement. Major restructuring of your program is typically required. Mo
