Oracle DDLs in Net Express

[Migrated content. Thread originally posted on 11 August 2011]

Hello,

I am currently researching on how to create Oracle Tables in Net Express.

I have some questions and I'm hoping you guys can help me.

> Do I need to convert the DB2 DDLs to Oracle DDLs before I can create the tables?
> How do I create the Oracle tables in Net Express?

Thanks in advance! :)

Hi,

How are you executing the DB2 DDL statements - from COBOL, or by executing DB2 command utilities?

If the latter, then Oracle has a command-line interface (sqlplus) that you can use to execute SQL statements, or they have tools such as SQL Developer from where you can execute SQL statements.

It's also possible to execute such statements from COBOL. To access Oracle, you can either use Oracle's COBOL precompiler, Pro*COBOL, or you can use OpenESQL (with which you would need appropriate ODBC drivers). For an example of using OpenESQL, see the static sample within the Net Express IDE\\ODBCESQL directory.

As to whether the DDL statements need to change, I guess that depends on the data types in use. Oracle's SQL Developer tooling provides tools to aid migration. You can get more detail on SQL Developer and other migration resources at http://www.oracle.com/technetwork/database/migration/db2-084087.html .