 |
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 41 matches |
| Author | Message |
|---|---|
 Topic: Retrieving the count with COUNT(*) and GROUP BY |
|
| srini_igsi Replies: 5 Views: 2721 |
 Forum: Database Posted: Mon Mar 23, 2009 11:12 am Subject: Retrieving the count with COUNT(*) and GROUP BY |
| Thank you so much Kolusu. It's perfectly working. This is the reason why I always trust MVSFORUMS website.
It has made my program logic very simple. |
|
| Topic: Retrieving the count with COUNT(*) and GROUP BY |
|
| srini_igsi Replies: 5 Views: 2721 |
Forum: Database Posted: Sat Mar 21, 2009 7:31 am Subject: Retrieving the count with COUNT(*) and GROUP BY |
| Thank you so much Kolusu. I know how GROUP BY works but I was looking out for the tot of three of them only. I will run this query and let you know the result on Monday. | |
| Topic: need help in forward & backward scroll cursor |
|
| srini_igsi Replies: 6 Views: 3149 |
Forum: Database Posted: Fri Mar 20, 2009 7:54 am Subject: need help in forward & backward scroll cursor |
| Hi Kolusu,
Is there a way to implement the similar logic with a DATE field in the where caluse but with duplicate values. I believe we must have at lease one unique field on the screen/DB to con ... |
|
| Topic: Retrieving the count with COUNT(*) and GROUP BY |
|
| srini_igsi Replies: 5 Views: 2721 |
Forum: Database Posted: Fri Mar 20, 2009 7:45 am Subject: Retrieving the count with COUNT(*) and GROUP BY |
| Sorry Kolusu, I need the count of all the groups together after applying GROUP BY. | |
| Topic: Retrieving the count with COUNT(*) and GROUP BY |
|
| srini_igsi Replies: 5 Views: 2721 |
Forum: Database Posted: Thu Mar 19, 2009 2:39 pm Subject: Retrieving the count with COUNT(*) and GROUP BY |
| Could some body please let me know if there is a way to get the consolidated count for all the groups together instead of one per group.
SELECT COUNT(*) ... |
|
| Topic: DB2 query optimization |
|
| srini_igsi Replies: 2 Views: 1829 |
Forum: Database Posted: Tue Mar 17, 2009 2:56 am Subject: DB2 query optimization |
| Could somebody help to re-design the query please? | |
| Topic: DB2 query optimization |
|
| srini_igsi Replies: 2 Views: 1829 |
Forum: Database Posted: Mon Mar 16, 2009 1:37 pm Subject: DB2 query optimization |
| The following query extracts all the CORPS for all the releases released till date at CORP level. The db2 host variable DB2-HOST-V-RLSE-DATE is populated with highest/latest release date from some ot ... | |
| Topic: Which version of DFSORT supports joining files? |
|
| srini_igsi Replies: 6 Views: 4076 |
Forum: Utilities Posted: Fri Jan 23, 2009 11:46 am Subject: Which version of DFSORT supports joining files? |
| Thank you so much for your help. | |
| Topic: Which version of DFSORT supports joining files? |
|
| srini_igsi Replies: 6 Views: 4076 |
Forum: Utilities Posted: Fri Jan 23, 2009 7:40 am Subject: Which version of DFSORT supports joining files? |
| This is what I had coded earlier in 2007 and working fine.
//JS000020 EXEC PGM=SORT //* //SORTJNF1 DD ... |
|
| Topic: Which version of DFSORT supports joining files? |
|
| srini_igsi Replies: 6 Views: 4076 |
Forum: Utilities Posted: Fri Jan 23, 2009 6:39 am Subject: Which version of DFSORT supports joining files? |
| Hi,
Our shop has got DFSORT V1R5. When I tried to joing the files using 'JOINKEYS FILE' control statements, my job is abending with U0005. SYSOUT: ICE143I 0 BLOCKSET COPY TECHNIQUE SELECTE ... |
|
| Topic: Query for eliminating duplicates rows on a specific column.. |
|
| srini_igsi Replies: 2 Views: 1610 |
Forum: Database Posted: Fri Jan 23, 2009 2:11 am Subject: Query for eliminating duplicates rows on a specific column.. |
| Thank you so much Kolusu, its perfectly working. | |
| Topic: Query for eliminating duplicates rows on a specific column.. |
|
| srini_igsi Replies: 2 Views: 1610 |
Forum: Database Posted: Thu Jan 22, 2009 11:36 am Subject: Query for eliminating duplicates rows on a specific column.. |
| Hi,
The query is... SELECT A,B FROM TABLE T; Result: A B A1 B1 A1 B2 A1 B3 A2 B4 A2 B5 A3 B6 A4 B7 Required Output: A ... |
|
| Topic: Making MQ message persistent |
|
| srini_igsi Replies: 4 Views: 2771 |
Forum: CICS and Middleware Posted: Tue Oct 09, 2007 1:51 am Subject: Making MQ message persistent |
| I need information on making the MQ message PERSISTANCE
Is there any option to make the message persistance without changing the Queue properties. We can do it by changing the queue properties, But ... |
|
| Topic: Handling a varible length field in SORT |
|
| srini_igsi Replies: 2 Views: 1773 |
Forum: Utilities Posted: Wed Oct 03, 2007 2:18 am Subject: Handling a varible length field in SORT |
| Thanks for looking into this Bill. I will get back with some sample records shortly. | |
| Topic: Handling a varible length field in SORT |
|
| srini_igsi Replies: 2 Views: 1773 |
Forum: Utilities Posted: Tue Oct 02, 2007 9:56 am Subject: Handling a varible length field in SORT |
| I have two files FILE1 and FILE2. I have to compare both the files on a specific key. Both the files have got some common fields in them.
FILE1: Client1 Client2 Client3 Client4 Client5 ... |
|
All times are GMT - 5 Hours |