 |
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 20 matches |
| Author | Message |
|---|---|
 Topic: Cursor with return for |
|
| drammo Replies: 1 Views: 3343 |
 Forum: Database Posted: Wed May 06, 2015 5:53 pm Subject: Cursor with return for |
| We have a stored procedure that returns result set to a web service. In addition to the columns selected from tables, I need to also return some computed values that involves complex business logic. I ... | |
| Topic: Is Package executable? |
|
| drammo Replies: 1 Views: 2162 |
Forum: Database Posted: Thu Oct 13, 2011 2:28 pm Subject: Is Package executable? |
| Found answer in the manuals
If the stored procedure contains SQL statements, you must process them like they are in any other SQL application program through the DB2 pre-compiler or the SQL statem ... |
|
| Topic: Is Package executable? |
|
| drammo Replies: 1 Views: 2162 |
Forum: Database Posted: Thu Oct 13, 2011 1:37 pm Subject: Is Package executable? |
| We have a stored procedure which calls a few subroutines. The subroutines & the stored proc have DB2 and they are all bound as packages.
None, including the stored proc, are plans. I am abl ... |
|
| Topic: IMS Connect -- SPA population |
|
| drammo Replies: 6 Views: 3223 |
Forum: IMS Posted: Thu Aug 10, 2006 2:31 pm Subject: IMS Connect -- SPA population |
| Thanks for the link Kolusu. The data processing program (txn2 in the problem description) will also be used on the mainframe, so I dont have much flexibility to alter that program.
The way we are a ... |
|
| Topic: IMS Connect -- SPA population |
|
| drammo Replies: 6 Views: 3223 |
Forum: IMS Posted: Mon Jul 24, 2006 11:14 am Subject: IMS Connect -- SPA population |
| We are in the process of verifying IMS connect to call a IMS transaction from Java. We are able to successfully use the phonebook example code that come with this product.
Currently, in the IMS re ... |
|
| Topic: Calling IMS transaction from DB2 SP |
|
| drammo Replies: 1 Views: 2468 |
Forum: IMS Posted: Fri Jun 09, 2006 11:45 am Subject: Calling IMS transaction from DB2 SP |
| I am not very familiar with IMS, so I was not sure if the results of my search in MVSforums were relevant to my question below. You patience is appreciated.
We have a IMS transaction which receives ... |
|
| Topic: Email ID validation in COBOL |
|
| drammo Replies: 2 Views: 14500 |
Forum: Application Programming Posted: Fri May 12, 2006 7:22 am Subject: Email ID validation in COBOL |
| Thanks Vivek! | |
| Topic: Email ID validation in COBOL |
|
| drammo Replies: 2 Views: 14500 |
Forum: Application Programming Posted: Mon May 08, 2006 12:37 pm Subject: Email ID validation in COBOL |
| I am looking for COBOL code to validate a well-formed email address. I saw a previous posting with Java Script code (http://www.mvsforums.com/helpboards/viewtopic.php?t=4796), but I could save some ti ... | |
| Topic: Partial INTEGER search |
|
| drammo Replies: 4 Views: 2424 |
Forum: Database Posted: Thu May 04, 2006 2:34 pm Subject: Partial INTEGER search |
| Out of curosity, is there a way to pad leading zeros to an integer column, while converting it to Char?
Thanks! |
|
| Topic: Partial INTEGER search |
|
| drammo Replies: 4 Views: 2424 |
Forum: Database Posted: Thu May 04, 2006 2:31 pm Subject: Partial INTEGER search |
| I am a dumbo. Thanks Kolusu. | |
| Topic: Partial INTEGER search |
|
| drammo Replies: 4 Views: 2424 |
Forum: Database Posted: Thu May 04, 2006 2:07 pm Subject: Partial INTEGER search |
| The requirement is to identify all rows based on the last four digits of a column defined as integer.
Source Table Account_ID ---------- 105 34221 2223123 3310105 44 ... |
|
| Topic: Load on tbl with no unique index |
|
| drammo Replies: 3 Views: 1793 |
Forum: Database Posted: Mon Jan 30, 2006 2:32 pm Subject: Load on tbl with no unique index |
| I am LOADing data in to a table with no unique indices. However 3 non-unique indices are created on it. Will it help to sort the input dataset on one of these non-unique indices (the one which is most ... | |
| Topic: Insert Vs Load |
|
| drammo Replies: 3 Views: 2124 |
Forum: Database Posted: Thu Jan 26, 2006 9:09 am Subject: Insert Vs Load |
| Will LOAD be an overkill for a few thousand records that too when the table is not being accessed by any other application? | |
| Topic: Insert Vs Load |
|
| drammo Replies: 3 Views: 2124 |
Forum: Database Posted: Wed Jan 25, 2006 1:27 pm Subject: Insert Vs Load |
| I have a program which formats data and inserts into a DB2 table. For each run, there will be thousands of inserts. Performance wise, is it better to write the formatted records into a dataset and the ... | |
| Topic: IF statement in Triggers |
|
| drammo Replies: 4 Views: 2222 |
Forum: Database Posted: Thu Jan 19, 2006 2:42 pm Subject: IF statement in Triggers |
| Its a good suggestion Dennis, but my real SQL has ELSEIF conditions as well. To resolve the error, I reduced the query to bare minimum. | |
All times are GMT - 5 Hours |