<div>
no, there isn't any tool. Also in DB2 a stored procedure<br />
is a trick, when you write one it is converted in C source and then compiled (take a look at /home/db2inst1/sqllib/func<wbr />tion/routi<wbr />ne/sqlproc<wbr /> to see the c source).<br />
ByeBye.
</div>


no, there isn't any tool. Also in DB2 a stored procedure
is a trick, when you write one it is converted in C source and then compiled (take a look at /home/db2inst1/sqllib/function/routine/sqlproc to see the c source).
ByeBye.

<div>
Hi makkena_v ,<br />
<br />
Yes, there is a way to use your legacy system.<br />
IBM UDB supports External Stored Procedures, which are SQL wrappers around existing programs.<br />
<br />
<a href="http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnsq0g3/CCONTENTS" rel="ugc nofollow">http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnsq0g3/CCONTENTS</a><br />
<br />
look for the &quot;&nbsp;CREATE PROCEDURE (external) &quot;&nbsp;definition.<br />
<br />
You will not see a performance penalty, and the benefits are obvious - you wrap your business logic and use it either internally or expose it thru the stored procedure to external applications via ODBC/JDBC.<br />
<br />
<br />
Cheers,<br />
ShalomC
</div>


Hi makkena_v ,

Yes, there is a way to use your legacy system.
IBM UDB supports External Stored Procedures, which are SQL wrappers around existing programs.

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnsq0g3/CCONTENTS [http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnsq0g3/CCONTENTS]

look for the " CREATE PROCEDURE (external) " definition.

You will not see a performance penalty, and the benefits are obvious - you wrap your business logic and use it either internally or expose it thru the stored procedure to external applications via ODBC/JDBC.


Cheers,
ShalomC

<div>
<div class="content wysiwyg-content">
Hi, <br />
We have many COBOL programs on IBM mainframe, we are planning to convert them to DB2 stored procedure. is there any tools to conver this. Is there any performance and easy mainitenance benifit?.
</div>
</div>


Hi, 
We have many COBOL programs on IBM mainframe, we are planning to convert them to DB2 stored procedure. is there any tools to conver this. Is there any performance and easy mainitenance benifit?.

Converting COBOL Program  to DB2 Stored Procedures

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

COBOL (Common Business-Oriented Language) is a programming language with English-like syntax. It is readable but verbose compared to other programming languages. CODASYL (Conference on Data Systems Languages) created COBOL in 1959 based on design work from Grace Hopper. It was standardized in 1968. COBOL is still present in large-scale batch processing and transaction processing where legacy applications are being used, usually in government, financial, and administrative systems.