reading stored procedure SQLs via JDBCThis is a discussion on reading stored procedure SQLs via JDBC within the JDBC JAVA forums in Framework and Interface Programming category; Hi Experts, Is there a way to read back Stored Procedure's SQL statements using JDBC from existing Database. I am thinking of migrating from one database to different database. Thanks HG... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
09-17-2008, 02:01 PM
| |||
| |||
 reading stored procedure SQLs via JDBC Hi Experts, Is there a way to read back Stored Procedure's SQL statements using JDBC from existing Database. I am thinking of migrating from one database to different database. Thanks HG  |
|
#2
09-17-2008, 04:25 PM
| |||
| |||
| Re: reading stored procedure SQLs via JDBC hgohilgroups@gmail.com wrote: > Hi Experts, > > Is there a way to read back Stored Procedure's SQL statements using > JDBC from existing Database. > I am thinking of migrating from one database to different database. > > Thanks > HG Look in schema SYSCAT table ROUTINES. If the LANGUAGE is SQL then column TEXT should contain text to recreate SP. |
|
#3
09-17-2008, 04:57 PM
| |||
| |||
| Re: reading stored procedure SQLs via JDBC hgohilgroups@gmail.com wrote: > Hi Experts, > > Is there a way to read back Stored Procedure's SQL statements using > JDBC from existing Database. > I am thinking of migrating from one database to different database. > > Thanks > HG Sorry - I assumed you are using DB2; if not then ignore my answer; visit system catalog of the database and find where text of SP may be stored. Jan M. Nelken |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 07:53 PM.
