 |
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 39 matches |
| Author | Message |
|---|---|
 Topic: Join |
|
| SK2007 Replies: 3 Views: 2877 |
 Forum: Database Posted: Mon Oct 10, 2011 9:37 pm Subject: Join |
| Thanks Kolusu and GuyC.
It is working as expected...thanks again for your help. |
|
| Topic: Join |
|
| SK2007 Replies: 3 Views: 2877 |
Forum: Database Posted: Wed Oct 05, 2011 2:47 pm Subject: Join |
| Hi,
I have two tables. 1) open table 2) pending table OpenTable has threecolumns 1) Mbr-id 2) Invoice-no 3) tot-amnt ----+----1----+----2----+- ************************** 1234567 545875 ... |
|
| Topic: Channel Status in Z/OS console |
|
| SK2007 Replies: 3 Views: 6135 |
Forum: CICS and Middleware Posted: Wed Aug 03, 2011 1:42 pm Subject: Channel Status in Z/OS console |
| Thanks much Kolusu, for your help.
My aim is to figureout what are channles are not in RUN status. So I tried DISPLAY CHSTATUS(*) CURRENT But it didn't list INACTIVE status channels. ... |
|
| Topic: Channel Status in Z/OS console |
|
| SK2007 Replies: 3 Views: 6135 |
Forum: CICS and Middleware Posted: Wed Aug 03, 2011 9:26 am Subject: Channel Status in Z/OS console |
| Hi,
I would like to know the CHANNEL status, but the given job gave error(Invalid function DISPLAY). Please let me know how to find channel status thru JCL. //MQDISCH JOB (),'MQ ... |
|
| Topic: Sorting with condition |
|
| SK2007 Replies: 10 Views: 4629 |
Forum: Utilities Posted: Wed Jul 13, 2011 2:40 pm Subject: Sorting with condition |
| Thank you so much, Kolusu. | |
| Topic: Sorting with condition |
|
| SK2007 Replies: 10 Views: 4629 |
Forum: Utilities Posted: Mon Jul 11, 2011 10:18 pm Subject: Sorting with condition |
| Thanks much Kolusu. It is working as expected.
One more small request, how to get the total count for all mbr-ids. That means for above request the Total count is 5. Thanks again for your help. |
|
| Topic: Sorting with condition |
|
| SK2007 Replies: 10 Views: 4629 |
Forum: Utilities Posted: Mon Jul 11, 2011 2:33 pm Subject: Sorting with condition |
| Kolusu,
For this mbr-id 123456789, the BT is entered in 201005, and continue same in 201006. I dont want to count anything entred in 201005 and continue same in 201006.. If BT entered in 201005 a ... |
|
| Topic: Sorting with condition |
|
| SK2007 Replies: 10 Views: 4629 |
Forum: Utilities Posted: Mon Jul 11, 2011 1:56 pm Subject: Sorting with condition |
| Sqlcode,
Thanks for your response. For mbr-id 123456790 i should get 3. The BT#s are 32432434 34535634 84595634 Also the first BT was on 201006, and no record on 201005. Thanks |
|
| Topic: Sorting with condition |
|
| SK2007 Replies: 10 Views: 4629 |
Forum: Utilities Posted: Mon Jul 11, 2011 12:38 pm Subject: Sorting with condition |
| Hi
I have dataset with 4 columns: 1) Mbr-id - 9 bytes 2) RT# - 8 bytes 3) BT# - 9 bytes 4) year and month - 6 bytes (ex; 201101) The sample data is ----+----1----+----2----+----3----+ ... |
|
| Topic: Trigger CICS program |
|
| SK2007 Replies: 2 Views: 3663 |
Forum: CICS and Middleware Posted: Sat Apr 24, 2010 9:45 pm Subject: Trigger CICS program |
| Thanks Kolusu.
I looked at the pdf given in the link. But I felt it is difficult to solve my situation. This ASRA caused SOC4. I got connection handle as zeros after MQOPEN. Is it correct??zeors is ... |
|
| Topic: Trigger CICS program |
|
| SK2007 Replies: 2 Views: 3663 |
Forum: CICS and Middleware Posted: Fri Apr 23, 2010 4:00 pm Subject: Trigger CICS program |
| Hi,
I am very new to MQ series. Please help me. My requirement is to trigger a program when there is a message in Queue. The triggered program will read the message from Queue and send message to ... |
|
| Topic: Drop records based on conditions |
|
| SK2007 Replies: 4 Views: 2806 |
Forum: Utilities Posted: Mon Jan 25, 2010 3:55 pm Subject: Drop records based on conditions |
| Hi Kolusu,
Thanks for your help. It is working as expected. But I need one more condition to be considered to sort the records. In addition to the conditions mentioned, I want to keep records w ... |
|
| Topic: Drop records based on conditions |
|
| SK2007 Replies: 4 Views: 2806 |
Forum: Utilities Posted: Sun Jan 24, 2010 9:07 pm Subject: Drop records based on conditions |
| Additional information:
The input file is FB and 80 bytes length. |
|
| Topic: Drop records based on conditions |
|
| SK2007 Replies: 4 Views: 2806 |
Forum: Utilities Posted: Sun Jan 24, 2010 5:17 pm Subject: Drop records based on conditions |
| Hi All,
I am having difficulty in dropping records base don conditions. Please help me. My input file is ----+----1----+----2----+----3----+----4----+----5 //SORTIN DD * ... |
|
| Topic: Compare Signed numeric value |
|
| SK2007 Replies: 3 Views: 1823 |
Forum: Utilities Posted: Thu Jan 07, 2010 2:11 pm Subject: Compare Signed numeric value |
| Hi Frank,
Thanks for quick response. Yes, the third field starts from 21st position. I hvae only 2 decimal places. Thanks SK2009 |
|
All times are GMT - 5 Hours |