 |
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 24 matches |
| Author | Message |
|---|---|
 Topic: COUNT and SUM of fields using ICETOOL |
|
| pai_sunil_bs Replies: 6 Views: 5544 |
 Forum: Utilities Posted: Sun Oct 11, 2020 10:41 am Subject: COUNT and SUM of fields using ICETOOL |
| Thanks Kolusu. Using DISPLAY ON "experience" field, I put a BREAK on the "STATE" field and then used BCOUNT and BTOTAL. I am getting the desired results. Thanks for your guidance. ... | |
| Topic: COUNT and SUM of fields using ICETOOL |
|
| pai_sunil_bs Replies: 6 Views: 5544 |
Forum: Utilities Posted: Tue Oct 06, 2020 1:31 pm Subject: COUNT and SUM of fields using ICETOOL |
| I am no comparison to you Kolusu in terms of knowledge!
What I meant to say was that I am aware that my requirement can be met through SORT. I am also aware that ICETOOL invokes SORT. I am only cur ... |
|
| Topic: COUNT and SUM of fields using ICETOOL |
|
| pai_sunil_bs Replies: 6 Views: 5544 |
Forum: Utilities Posted: Tue Oct 06, 2020 12:49 am Subject: COUNT and SUM of fields using ICETOOL |
| Thanks Kolusu. I am aware of the SORT. What I am looking for is whether the same is possible via ICETOOL. | |
| Topic: COUNT and SUM of fields using ICETOOL |
|
| pai_sunil_bs Replies: 6 Views: 5544 |
Forum: Utilities Posted: Mon Oct 05, 2020 9:23 pm Subject: COUNT and SUM of fields using ICETOOL |
| Hello,
I scanned the board before posting the query. Query: Is it possible to get COUNT and SUM of fields in ICETOOL just like we have in DB2. I know it is possible in DFSORT and also we have OC ... |
|
| Topic: Data issues - remove records based on condition |
|
| pai_sunil_bs Replies: 8 Views: 3694 |
Forum: Job Control Language(JCL) Posted: Thu Aug 21, 2008 4:51 am Subject: Data issues - remove records based on condition |
| The Account number is 15 Bytes Text field. In the MasterFile it starts from 20th position whereas in the DefaultersFile it starts from the first position.
Please find the sample: DefaultersFile ... |
|
| Topic: Data issues - remove records based on condition |
|
| pai_sunil_bs Replies: 8 Views: 3694 |
Forum: Job Control Language(JCL) Posted: Wed Aug 20, 2008 2:33 am Subject: Data issues - remove records based on condition |
| How can change the above if the account numbers in MasterFile contains duplicates?
The Account number is 15 Bytes Text field. In the MasterFile it starts from 20th position Please advice. |
|
| Topic: Data issues - remove records based on condition |
|
| pai_sunil_bs Replies: 8 Views: 3694 |
Forum: Job Control Language(JCL) Posted: Wed Aug 13, 2008 6:31 am Subject: Data issues - remove records based on condition |
| Thanks a Lot Frank! | |
| Topic: Data issues - remove records based on condition |
|
| pai_sunil_bs Replies: 8 Views: 3694 |
Forum: Job Control Language(JCL) Posted: Mon Aug 11, 2008 12:40 am Subject: Data issues - remove records based on condition |
| For Simplicity, assume the Header record can be identified by first 3 characters i.e. 'HDR' and similarly the Trailer record can be identified by first 3 characters i.e. 'TRL' .
The Account number ... |
|
| Topic: Data issues - remove records based on condition |
|
| pai_sunil_bs Replies: 8 Views: 3694 |
Forum: Job Control Language(JCL) Posted: Fri Aug 08, 2008 5:55 am Subject: Data issues - remove records based on condition |
| I tried searching the postings but did not get what I am looking for:
My senario: There are 2 files DefaultersFile and MasterFile DefaultersFile 2 4 5 6 MasterFile Header 1 2 ... |
|
| Topic: Data issues to remove records based on condition |
|
| pai_sunil_bs Replies: 0 Views: 1011 |
Forum: Job Control Language(JCL) Posted: Fri Aug 08, 2008 5:11 am Subject: Data issues to remove records based on condition |
| I tried searching the postings but did not get what I am looking for:
My senario: There are 2 files DefaultersFile and MasterFile DefaultersFile 2 4 5 6 MasterFile Header 1 2 ... |
|
| Topic: Data issues to remove records based on condition |
|
| pai_sunil_bs Replies: 0 Views: 969 |
Forum: Job Control Language(JCL) Posted: Fri Aug 08, 2008 5:08 am Subject: Data issues to remove records based on condition |
| I tried searching the postings but did not get what I am looking for:
My senario: There are 2 files DefaultersFile and MasterFile DefaultersFile 2 4 5 6 MasterFile Header 1 2 ... |
|
| Topic: Data issues for removing records frm file based on condition |
|
| pai_sunil_bs Replies: 0 Views: 1045 |
Forum: Job Control Language(JCL) Posted: Fri Aug 08, 2008 4:57 am Subject: Data issues for removing records frm file based on condition |
| I tried searching the postings but did not get what I am looking for:
My scenario: There are 2 files DefaultersFile and MasterFile Assume both files are FB and LRECL as 80 DefaultersFile 2 ... |
|
| Topic: Xpeditor Debugging |
|
| pai_sunil_bs Replies: 1 Views: 2937 |
Forum: Problem Determination Posted: Mon Feb 05, 2007 11:53 pm Subject: Xpeditor Debugging |
| How to trace the control backwards in an Expeditor?
I tried checking all the KEYS which are mapped. I did not get any clue. |
|
| Topic: Initialization of Working storage variables |
|
| pai_sunil_bs Replies: 5 Views: 3207 |
Forum: Application Programming Posted: Mon Sep 11, 2006 1:51 pm Subject: Initialization of Working storage variables |
| Thanks to All for the responses. | |
| Topic: Initialization of Working storage variables |
|
| pai_sunil_bs Replies: 5 Views: 3207 |
Forum: Application Programming Posted: Wed Sep 06, 2006 10:00 pm Subject: Initialization of Working storage variables |
| Thanks Kolusu.
I have seen this posting but this is not what I want. My program is working in our environment. The program is called dynamically. But the same program does not seem to be initializ ... |
|
All times are GMT - 5 Hours |