Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.java.databases > #255 > unrolled thread
| Started by | "hgohilgroups" <hgohilgroups@THRWHITE.remove-dii-this> |
|---|---|
| First post | 2011-04-27 15:22 +0000 |
| Last post | 2011-04-27 15:22 +0000 |
| Articles | 3 — 2 participants |
Back to article view | Back to comp.lang.java.databases
reading stored procedure "hgohilgroups" <hgohilgroups@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
Re: reading stored proced "Jan M. Nelken" <jan.m..nelken@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
Re: reading stored proced "Jan M. Nelken" <jan.m..nelken@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000
| From | "hgohilgroups" <hgohilgroups@THRWHITE.remove-dii-this> |
|---|---|
| Date | 2011-04-27 15:22 +0000 |
| Subject | reading stored procedure |
| Message-ID | <b128c9e3-294b-4d74-ab7f-e13eaca3310f@r66g2000hsg.googlegroups.com> |
To: comp.lang.java.databases 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 --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24
[toc] | [next] | [standalone]
| From | "Jan M. Nelken" <jan.m..nelken@THRWHITE.remove-dii-this> |
|---|---|
| Date | 2011-04-27 15:22 +0000 |
| Subject | Re: reading stored proced |
| Message-ID | <48d167a8$1@kcnews01> |
| In reply to | #255 |
To: comp.lang.java.databases 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. --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24
[toc] | [prev] | [next] | [standalone]
| From | "Jan M. Nelken" <jan.m..nelken@THRWHITE.remove-dii-this> |
|---|---|
| Date | 2011-04-27 15:22 +0000 |
| Subject | Re: reading stored proced |
| Message-ID | <48d16f36$1@kcnews01> |
| In reply to | #255 |
To: comp.lang.java.databases 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 --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.java.databases
csiph-web