从Oracle Pro*C 到 HiRDB С API 转换

Ispirer MnMTK数据库与应用迁移工具是成本的有效的产品，可以迎合唯一的业务要求。我们的灵活的工具是不断变化的。我们把我们的最大应力帮助我们的客户运行平稳数据库和应用迁移及完成大多数任务。

从Oracle Pro*C到HiRDB С API转换

转换为嵌入式SQL语句基于最初的实现从Oracle到HiRDB.

转换特征：

连接数据库/办理控制转换

• CONNECT语句对CHAR变量：

  Oracle Pro*C:

   
   CHAR *userid = "SCOTT"; 
   CHAR *password = "TIGER"; 
   
   EXEC SQL CONNECT :userid IDENTIFIED BY :password;
   

  HiRDB С API:

   
   EXEC SQL BEGIN DECLARE SECTION;
   /*  SQLWays Variable for username /Password */
       CHAR  SQLWays_userid[9];
       CHAR  SQLWays_password[31];
   EXEC SQL END DECLARE SECTION;
   
      CHAR *userid = "SCOTT"; 
      CHAR *password = "TIGER"; 
   
      sscanf(userid, "%8s", SQLWays_userid);
      sscanf(password, "%30s", SQLWays_password);
   
   EXEC SQL CONNECT USER :SQLWays_userid 
     USING :SQLWays_password;  
   

• CONNECT语句对VARCHAR变量：

  Oracle Pro*C:

   
   VARCHAR  userid[128];
   VARCHAR  password[32];
   
   EXEC SQL CONNECT :userid IDENTIFIED BY :password;
   

  HiRDB С API:

   
   EXEC SQL BEGIN DECLARE SECTION;
   /*  SQLWays Variable for username/Password */
       CHAR  SQLWays_userid[9];
       CHAR  SQLWays_password[31];
   EXEC SQL END DECLARE SECTION;
   
    struct{
      UNSIGNED short len ;
      UNSIGNED CHAR  arr[128] ;
    }userid;
   
    struct{
      UNSIGNED short len ;
      UNSIGNED CHAR  arr[32] ;
    }password;
   
     sscanf(userid.arr, "%8s", SQLWays_userid);
     sscanf(password.arr, "%30s", SQLWays_password);
   
   EXEC SQL CONNECT USER :SQLWays_userid 
     USING :SQLWays_password;       
   

光标转换

• Select查询在光标语句转换基于从Oracle到HiRDB实现：

  Oracle Pro*C:

   
   EXEC SQL DECLARE EMPCUR CURSOR FOR 
      SELECT CONCAT(JOB,ENAME), EMPNO
      FROM EMP 
      WHERE DEPTNO = :deptno;
   

  HiRDB С API:

   
   EXEC SQL DECLARE EMPCUR CURSOR FOR 
      SELECT JOB || ENAME, EMPNO
      FROM EMP 
      WHERE DEPTNO = :deptno;
   

DML查询转换

• Select, Insert, Update, Delete语句转换基于从Oracle到HiRDB实现

  Oracle Pro*C:

   
   EXEC SQL 
      SELECT EXTRACT(YEAR FROM C1), EMPNO
      INTO :ename, :empno
      FROM EMP 
      WHERE EMPNO = :empno;
   

  HiRDB С API:

   
   EXEC SQL 
      SELECT YEAR(C1), EMPNO
      INTO :ename, :empno
      FROM EMP 
      WHERE EMPNO = :empno;
   

程序调用转换

• 调用语句在PL/SQL快转换

• 去除包名称

  Oracle Pro*C:

   
   EXEC SQL CALL myschema.mypkge.fact(:num);
   

  HiRDB С API:

   
   EXEC SQL CALL myschema.fact(:num);
   

指标变量转换

• 去除关键字INDICATOR

  Oracle Pro*C:

   
   EXEC SQL
     SELECT C3,C4 INTO
     :vnum INDICATOR :vnum_ind FROM T2;
   

  HiRDB С API:

   
   EXEC SQL
     SELECT C3,C4 INTO
     :vnum:vnum_ind FROM T2;
   

声明主机变量转换

• 注释SQLCA, SQLDA, ORACA

  Oracle Pro*C:

   
   EXEC SQL INCLUDE SQLCA;
   EXEC SQL INCLUDE SQLDA;
   EXEC SQL INCLUDE ORACA;
   

  HiRDB С API:

   
   /* EXEC SQL INCLUDE SQLCA; */
   /* EXEC SQL INCLUDE SQLDA; */
   /* EXEC SQL INCLUDE ORACA; */
   

• 文件的包括转换

  Oracle Pro*C:

   
   EXEC SQL INCLUDE C:\script\INCL.h;
   EXEC SQL INCLUDE C:\script\INCL;
   

  HiRDB С API:

   
   #include "INCL.h"
   #include "INCL"
   

• #include Oracle 标头注释

  Oracle Pro*C:

   
   #include <oraca.h>
   #include <sql2oci.h>
   #include <sqlapr.h>
   #include <sqlca.h>
   #include <sqlcpr.h>
   #include <sqlda.h>
   #include <sqlkpr.h>
   #include <sqlucs2.h>
   

  HiRDB С API:

   
   /* #include <oraca.h> */
   /* #include <sql2oci.h> */
   /* #include <sqlapr.h> */
   /* #include <sqlca.h> */
   /* #include <sqlcpr.h> */
   /* #include <sqlda.h> */
   /* #include <sqlkpr.h> */
   /* #include <sqlucs2.h> */
   

扩展名转换

• 转换.PC扩展名到.EC

为什么选择Ispirer MnMTK?

Ispirer MnMTK自动您的Oracle Pro*C应用到HiRDB C API的整一迁移过程。选择应用迁移工具Ispirer MnMTK您可以重要减少时间必须的为您的源代码变化。此外，您对Ispirer MnMTK低风险与减少内部的努力为这个任务。

如果您要寻找价格政策，请您点击报价请求。