 |
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 22 matches |
| Author | Message |
|---|---|
 Topic: Get Part Keys that Have Max Count |
|
| WallaceC Replies: 3 Views: 3186 |
 Forum: Database Posted: Tue Mar 02, 2010 4:45 pm Subject: Get Part Keys that Have Max Count |
| I got -904 for the query. I do not know whether it is related to the setup of the shop or not, but I will verify.
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN ... |
|
| Topic: Get Part Keys that Have Max Count |
|
| WallaceC Replies: 3 Views: 3186 |
Forum: Database Posted: Tue Mar 02, 2010 3:45 pm Subject: Get Part Keys that Have Max Count |
| I have the following table TBL:
KEY1 KEY2 KEY3 FLD4 --------------------------- A A A WWW B A A XXX A B B EEE I want to get the combi ... |
|
| Topic: Count Occurrences of Each Length within A Field |
|
| WallaceC Replies: 4 Views: 2532 |
Forum: Database Posted: Wed Feb 17, 2010 12:52 pm Subject: Count Occurrences of Each Length within A Field |
| Hi Kolusu,
Yes, you are correct that the fields is just a CHAR format. I tried the new query and it works perfectly. Thank you. |
|
| Topic: Count Occurrences of Each Length within A Field |
|
| WallaceC Replies: 4 Views: 2532 |
Forum: Database Posted: Wed Feb 17, 2010 10:53 am Subject: Count Occurrences of Each Length within A Field |
| Hi Kolusu,
I tried the query but got incorrect result: Query: -- SELECT COUNT(*) AS COUNT ... |
|
| Topic: Count Occurrences of Each Length within A Field |
|
| WallaceC Replies: 4 Views: 2532 |
Forum: Database Posted: Tue Feb 16, 2010 4:12 pm Subject: Count Occurrences of Each Length within A Field |
| I have a table TBL with the following fields:
FLD_1 char(5) - key FLD_2 char(5) - key FLD_3 char(250) - non-key Sample Data: FLD_1 FLD_2 FLD_3 ----- ----- -------------------------- ... |
|
| Topic: Locking/Unlocking |
|
| WallaceC Replies: 6 Views: 2801 |
Forum: Application Programming Posted: Thu Jul 17, 2008 1:01 pm Subject: Locking/Unlocking |
| Possible return codes on timeout when running a query:
1) SQLCODE -911 Explanation: The current unit of work was the victim in a deadlock, or experienced a timeout, and had to be rolled back. ... |
|
| Topic: Check header and trailer existence |
|
| WallaceC Replies: 9 Views: 4752 |
Forum: Utilities Posted: Fri Apr 18, 2008 1:33 pm Subject: Check header and trailer existence |
| Thank you, Kolusu. I tested your suggestion and it worked!
Wallace |
|
| Topic: Check header and trailer existence |
|
| WallaceC Replies: 9 Views: 4752 |
Forum: Utilities Posted: Fri Apr 18, 2008 8:34 am Subject: Check header and trailer existence |
| I would like to use SORT to validate header (record with 1HDR) and trailer (record with 9TRL) existence on a file. If both header and trailer are on file, step gives return code of 0; otherwise, step ... | |
| Topic: Validating Trailer Count on File Using SORT |
|
| WallaceC Replies: 4 Views: 3664 |
Forum: Utilities Posted: Thu Apr 17, 2008 3:54 pm Subject: Validating Trailer Count on File Using SORT |
| Thank you, Kolusu. It worked also.
Wallace |
|
| Topic: Validating Trailer Count on File Using SORT |
|
| WallaceC Replies: 4 Views: 3664 |
Forum: Utilities Posted: Thu Apr 17, 2008 5:22 am Subject: Validating Trailer Count on File Using SORT |
| Hi Frank,
I tried your suggestion and it worked perfectly. Thank you! Wallace |
|
| Topic: Validating Trailer Count on File Using SORT |
|
| WallaceC Replies: 4 Views: 3664 |
Forum: Utilities Posted: Wed Apr 16, 2008 5:25 pm Subject: Validating Trailer Count on File Using SORT |
| Besides writing COBOL program, is it possible to use SORT on a job to validate trailer count on a file and return condition codes depending upon if number of detail records matching trailer count or ... | |
| Topic: Validate trailer count |
|
| WallaceC Replies: 2 Views: 2038 |
Forum: Job Control Language(JCL) Posted: Fri Jan 25, 2008 12:42 pm Subject: Validate trailer count |
| Thank you Kolusu. I tried the codes suggested and they worked. | |
| Topic: Validate trailer count |
|
| WallaceC Replies: 2 Views: 2038 |
Forum: Job Control Language(JCL) Posted: Fri Jan 25, 2008 11:49 am Subject: Validate trailer count |
| I have a file with header, detail, and trailer with count as of follow:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8 1HDR 20080124 ... |
|
| Topic: How to search string from GDGs? |
|
| WallaceC Replies: 11 Views: 12977 |
Forum: Job Control Language(JCL) Posted: Wed Nov 22, 2006 2:59 pm Subject: How to search string from GDGs? |
| Hi Shekar,
I tried that and it worked. Thank you. Wallace |
|
| Topic: How to search string from GDGs? |
|
| WallaceC Replies: 11 Views: 12977 |
Forum: Job Control Language(JCL) Posted: Wed Nov 22, 2006 2:39 pm Subject: How to search string from GDGs? |
| Hi Sri Ramla,
I tried your suggestion, but the output only showed the line numbers of where the string is but not on which GDG. The output is as follows: ISRSUPC - MVS/PDF FILE/LINE/WORD/B ... |
|
All times are GMT - 5 Hours |