 |
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 18 matches |
| Author | Message |
|---|---|
 Topic: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
|
| SAHANA Replies: 8 Views: 7662 |
 Forum: Job Control Language(JCL) Posted: Thu Mar 18, 2010 8:55 am Subject: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
| Thanks Kolusu.. It worked!!
But there was a change in requirement.. The client wanted me to reverse the logic of what was stated earlier.. i.e. File1 has below records: A0001 SAHANA A ... |
|
| Topic: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
|
| SAHANA Replies: 8 Views: 7662 |
Forum: Job Control Language(JCL) Posted: Thu Feb 11, 2010 8:18 am Subject: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
| Hi Kolusu,
File1 is 100 bytes LRECL and File2 is 80bytes LRECL. Records in the File1 are like below. Agent nos are present in Column 1 and 51. A0001 SAHANA A ... |
|
| Topic: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
|
| SAHANA Replies: 8 Views: 7662 |
Forum: Job Control Language(JCL) Posted: Mon Feb 08, 2010 7:31 am Subject: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
| Hi All,
I am really sorry I missed out to say that A0003 should not be in File2. I will be cautious in the future while I post. Thanks Sahana |
|
| Topic: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
|
| SAHANA Replies: 8 Views: 7662 |
Forum: Job Control Language(JCL) Posted: Sun Feb 07, 2010 6:14 am Subject: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
| File1:
Column1 and column 51 in File1 has the agent nos. i.e. for example A0001 and A0002 A0001 SAHANA A0002 SADHANA A0003 SATHYA A0004 ... |
|
| Topic: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
|
| SAHANA Replies: 8 Views: 7662 |
Forum: Job Control Language(JCL) Posted: Sat Feb 06, 2010 3:09 pm Subject: Exclude records present in File1 from File2 - DFSORT/ICETOOL |
| Hi,
Can anyone please give me the solution for the below requirement. File1 has agent nos in Column 1 and in Column 51. The agent no field is 5 digits. File2 has agents nos starting from C ... |
|
| Topic: Select Query Doubt |
|
| SAHANA Replies: 5 Views: 2814 |
Forum: Database Posted: Sun Nov 29, 2009 9:44 am Subject: Select Query Doubt |
| Hi All,
I have an input field I_PNO which comes from the Web and is stored in a table TAB1. I_PNO is a 10 digit alphanumeric field. I have another host variable :PNO which is from a input fla ... |
|
| Topic: how to subtract a number from a hexadecimal field? |
|
| SAHANA Replies: 10 Views: 5462 |
Forum: Application Programming Posted: Mon May 04, 2009 7:23 am Subject: how to subtract a number from a hexadecimal field? |
| Thanks a lott Kolusu and dbzTHEdinosauer....it worked!!! | |
| Topic: how to subtract a number from a hexadecimal field? |
|
| SAHANA Replies: 10 Views: 5462 |
Forum: Application Programming Posted: Tue Apr 21, 2009 11:52 am Subject: how to subtract a number from a hexadecimal field? |
| @ dbzTHEdinosauer - The logic proposed by you did not work... it was erroring out with the below error -
Receiving operand "BINARY-FIELD (GROUP)" of an arithmetic statement was neither ... |
|
| Topic: how to subtract a number from a hexadecimal field? |
|
| SAHANA Replies: 10 Views: 5462 |
Forum: Application Programming Posted: Fri Apr 17, 2009 11:36 am Subject: how to subtract a number from a hexadecimal field? |
| Yes the length is just 1 byte(or am I wrong?)
Please see the values as seen in the input file with HEX ON... The first byte is the length of the field... and in the below example its '14' . ... |
|
| Topic: how to subtract a number from a hexadecimal field? |
|
| SAHANA Replies: 10 Views: 5462 |
Forum: Application Programming Posted: Fri Apr 17, 2009 4:26 am Subject: how to subtract a number from a hexadecimal field? |
| ok i will rephrase my qn now...
01 VAR-FIELD PIC X(96). VAR-FIELD(1:1) is a one-byte hexadecimal code indicating the length of VAR-FIELD.. VAR-FIELD(2:96) will contain the first na ... |
|
| Topic: how to subtract a number from a hexadecimal field? |
|
| SAHANA Replies: 10 Views: 5462 |
Forum: Application Programming Posted: Thu Apr 16, 2009 10:33 am Subject: how to subtract a number from a hexadecimal field? |
| Dear Folks,
I have a field VAR-FIELD defined as PIC X(05). The first byte VAR-FIELD(1:1) is a hexadecimal code indicating the length of VAR-FIELD. Since I removed a part of the name, I now ... |
|
| Topic: How to search a word in a field - Inspect |
|
| SAHANA Replies: 15 Views: 12659 |
Forum: Application Programming Posted: Wed Feb 25, 2009 7:43 am Subject: How to search a word in a field - Inspect |
| Thanks a lott Kolusu.... It Worked!!!! | |
| Topic: How to search a word in a field - Inspect |
|
| SAHANA Replies: 15 Views: 12659 |
Forum: Application Programming Posted: Tue Feb 24, 2009 12:04 pm Subject: How to search a word in a field - Inspect |
| The data in the file is like below...is that the reason why it is not picking up ???
.. |
|
| Topic: How to search a word in a field - Inspect |
|
| SAHANA Replies: 15 Views: 12659 |
Forum: Application Programming Posted: Tue Feb 24, 2009 11:56 am Subject: How to search a word in a field - Inspect |
| Hii Kolusu,
when I use the below code, only 2 records are written... MOVE 0 TO TALLY-C INSPECT WS-NAME-FLD TALLYING TALLY-C FOR ALL 'FATHER ' IF TALLY-C > 0 MOVE to output or write ... |
|
| Topic: How to search a word in a field - Inspect |
|
| SAHANA Replies: 15 Views: 12659 |
Forum: Application Programming Posted: Tue Feb 24, 2009 11:42 am Subject: How to search a word in a field - Inspect |
| sorry i did not understand this part......can u pls temme...
"would check last non-space unstring object for 'FATHER'" |
|
All times are GMT - 5 Hours |