 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 4 matches |
| Author | Message |
|---|---|
 Topic: Executing a Stored Procedure from REXX |
|
| mukthi Replies: 0 Views: 1584 |
 Forum: TSO and ISPF Posted: Tue Sep 16, 2003 1:26 pm Subject: Executing a Stored Procedure from REXX |
| Hi,
I am trying to execute a DB2 Stored Procedure from REXX. The code is: PROC = 'SYSPROC.SCTSZ999' ADDRESS DSNREXX "EXECSQL CALL " PROC "(  I,:RC,:RCD)"
Where PI is the input parameter, RC ... |
|
| Topic: DB2 Stored Procedure |
|
| mukthi Replies: 5 Views: 4505 |
Forum: Database Posted: Thu Dec 19, 2002 1:50 pm Subject: DB2 Stored Procedure |
| Hi Kolusu,
Just now I tried that option also. But the Insert statement is waiting till the trigger procedure is completed. Thanks in Advance. Mukthi |
|
| Topic: DB2 Stored Procedure |
|
| mukthi Replies: 5 Views: 4505 |
Forum: Database Posted: Thu Dec 19, 2002 12:23 pm Subject: DB2 Stored Procedure |
| Hi Kolusu,
The web user is expecting results from the stored procedure. The SP(Stored Procedure) reads three tables which will be having 150 million rows. The user may not pass all the key informat ... |
|
| Topic: DB2 Stored Procedure |
|
| mukthi Replies: 5 Views: 4505 |
Forum: Database Posted: Thu Dec 19, 2002 10:58 am Subject: DB2 Stored Procedure |
| Hi,
I am working on DB2 Stored Procedures now. These procedures are called from the web. One of the stored procedure takes atleast 15 minutes to run. The web user does not like to wait for that muc ... |
|
All times are GMT - 5 Hours |