Wednesday Jun 13, 2012

Migrating C/C++ embedded SQL code

When moving from Sybase C Embedded SQL to Oracle C Embedded SQL, there are no tools are process. Since Embedded SQL is a standard it should be pretty straight forward. The biggest challenge is going to be SQL that is Sybase specific. I would map the process out as follows:
1. Change include files from Sybase Embedded SQL libraries to Oracle Pro*C in each module.
2. Make sure the C code does not test for Sybase specific error messages. Fix where needed.
3. Run all modules through the Pro*C pre-compiler. Fix any embedded static SQL that does not make it through the pre-compiler using the SQL Developer scratch pad editor.
4. Compile using C compiler.
5. Test run the application fixing any dynamic SQL that does not work against Oracle using SQL Developer scratch pad editor.
SQL Developer can be downloaded here:

Saturday Oct 15, 2011

Father of cloud IaaS, PaaS, DaaS and SaaS passes away

The operating systems, application servers and databases that run the cloud for the most part are powered by C: http://www.cnn.com/2011/10/14/tech/innovation/dennis-ritchie-obit-bell-labs/index.html?hpt=hp_bn6 A sad day for the world of high tech.
About

Migrating legacy client/server and mainframe technologies to the Oracle cloud.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today