 |
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 99 matches |
| Author | Message |
|---|---|
 Topic: CICS DB2 MQ Question |
|
| edkir98 Replies: 0 Views: 6344 |
 Forum: CICS and Middleware Posted: Wed Dec 08, 2010 9:37 am Subject: CICS DB2 MQ Question |
| We are using a online MQ DB2 program. There is a DB2 select before all MQ operations in the cobol program. i started the transaction by putting a message in the MQ. Program started.
i am forcing th ... |
|
| Topic: Connecting between 2 DB2 Systems |
|
| edkir98 Replies: 1 Views: 1594 |
Forum: Database Posted: Mon Sep 27, 2010 10:01 am Subject: Connecting between 2 DB2 Systems |
| We have 2 DB2 subsytems - DB2A and DB2B. Both of them are in different location and they have their own set of tables and programs. I have a requirement where my program in DB2A has to access a table ... | |
| Topic: Help required regarding Path File |
|
| edkir98 Replies: 5 Views: 5402 |
Forum: CICS and Middleware Posted: Thu Aug 12, 2010 8:54 am Subject: Help required regarding Path File |
| Hi Dick, Thanks for the quick reply.
Yes i could always use a random search. If i would declare an alternate index and a related path on Continent and country and use the path file in the program ... |
|
| Topic: Help required regarding Path File |
|
| edkir98 Replies: 5 Views: 5402 |
Forum: CICS and Middleware Posted: Thu Aug 12, 2010 8:12 am Subject: Help required regarding Path File |
| Hello,
We have a huge VSAM file with 500 million records and 4 fields (say Continent, Country, Currency and Account number). A combination of continent, country, currency and account number would mak ... |
|
| Topic: Question on GDG Versions |
|
| edkir98 Replies: 3 Views: 3356 |
Forum: Job Control Language(JCL) Posted: Tue Mar 23, 2010 5:46 am Subject: Question on GDG Versions |
| Hi Bill, Do you mean that i should drop the GDG base and re-create it? Doesnt it work like, when i did ALTER to change the number of versions from 5 to 30 and i try to create a 6th generation, the 1st ... | |
| Topic: Question on GDG Versions |
|
| edkir98 Replies: 3 Views: 3356 |
Forum: Job Control Language(JCL) Posted: Fri Mar 19, 2010 6:56 am Subject: Question on GDG Versions |
| i created a GDG with 5 versions. Now i did a ALTER to increase the number of versions to 30. But still i am not able to see more than 5 versions. Can someone help.
Please see parameteres Limit: and ... |
|
| Topic: Sum for a group of records |
|
| edkir98 Replies: 6 Views: 4605 |
Forum: Utilities Posted: Thu Feb 18, 2010 12:36 pm Subject: Sum for a group of records |
| Hi Kolusu.. Thanks.. we have a ICE201I F
may be i need to wait some more time to work out this example  |
|
| Topic: Sum for a group of records |
|
| edkir98 Replies: 6 Views: 4605 |
Forum: Utilities Posted: Thu Feb 18, 2010 12:27 am Subject: Sum for a group of records |
| Hi Kolusu,
i tried the same jcl.. but its giving me an error.. may be the version was different.. but it shows V1R5 ICE143I 0 BLOCKSET COPY TECHNIQUE SELECTED ... |
|
| Topic: Fetch, Write and Delete |
|
| edkir98 Replies: 1 Views: 1753 |
Forum: Database Posted: Mon Feb 15, 2010 9:53 am Subject: Fetch, Write and Delete |
| We have a master table and around 10 child tables. What we do now is when a timestamp is passed to the program it fetches the parent row one by one, then fetches the equivalent child rows in all the t ... | |
| Topic: Help needed to write Query |
|
| edkir98 Replies: 1 Views: 1589 |
Forum: Database Posted: Wed Dec 23, 2009 5:13 am Subject: Help needed to write Query |
| We have a table which has columns
1) Account_number 2) MQMessage_Number 3) Sequence_Number 4) MQ_message and some other columns. The purpose of this table is to backup the MQ message which th ... |
|
| Topic: Question on Query |
|
| edkir98 Replies: 2 Views: 2109 |
Forum: Database Posted: Tue Aug 04, 2009 8:26 am Subject: Question on Query |
| Its not possible to do this with SQL or Dint i make my question clear.. | |
| Topic: Question on Query |
|
| edkir98 Replies: 2 Views: 2109 |
Forum: Database Posted: Thu Jul 30, 2009 10:30 am Subject: Question on Query |
| i have 4 tables. 3 of them have to be inner joined to obtain the list of accounts and some account details after applying a lot of filter conditions on the 3 tables. Then i need to do left outer join ... | |
| Topic: Joining 3 tables |
|
| edkir98 Replies: 5 Views: 3298 |
Forum: Database Posted: Fri Jul 24, 2009 8:00 am Subject: Joining 3 tables |
| Thank you Christian and Kolusu! | |
| Topic: Joining 3 tables |
|
| edkir98 Replies: 5 Views: 3298 |
Forum: Database Posted: Thu Jul 23, 2009 3:10 pm Subject: Joining 3 tables |
| hi NASCAR, thanks for your info
But what i wanted to know was in the 2 queries that i had written, will Query 2 in any way be more efficient that Query 1? I'm not writing new queries in my applicat ... |
|
| Topic: Joining 3 tables |
|
| edkir98 Replies: 5 Views: 3298 |
Forum: Database Posted: Thu Jul 23, 2009 2:31 pm Subject: Joining 3 tables |
| Suppose i am joining 3 tables based on 1 column COL_A, i have a question
Is it enough if i write a query like this SELECT COL1,COL2,COL2 FROM TBL1, TBL2, TBL3 WHERE TBL1.COL_A = TBL2.CO ... |
|
All times are GMT - 5 Hours |