 |
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 10 matches |
| Author | Message |
|---|---|
 Topic: how to concatenate duplicate records |
|
| sree_sen Replies: 2 Views: 1872 |
 Forum: Utilities Posted: Fri Jul 22, 2005 7:13 am Subject: how to concatenate duplicate records |
| Hi,
I am posting this as I dont have the quick solutions to this - The requirement is I have an I/p file where certain details are as follows - 123 Abcd 234 nijpoi 123 pqrs 123 ... |
|
| Topic: How to place a space before and after a delimited record |
|
| sree_sen Replies: 7 Views: 5129 |
Forum: Utilities Posted: Tue Jul 05, 2005 10:26 am Subject: How to place a space before and after a delimited record |
| Hi Kolusu,
Thanks, it worked finally, but with a slight modification. Here is my snippet - //SYSIN DD * SORT FIELDS=COPY OUTREC FIELDS=(1 ... |
|
| Topic: How to place a space before and after a delimited record |
|
| sree_sen Replies: 7 Views: 5129 |
Forum: Utilities Posted: Tue Jul 05, 2005 9:33 am Subject: How to place a space before and after a delimited record |
| Hi Kolusu,
I tried the snippet u provided - I am getting the following as my o/p - A | AT | 2005| 1 |2005-07-04-06.00.02.1988 11| A | XZ | 2005| 1 |2005-07-04-06.00.02.1988 11| wh ... |
|
| Topic: How to place a space before and after a delimited record |
|
| sree_sen Replies: 7 Views: 5129 |
Forum: Utilities Posted: Tue Jul 05, 2005 8:54 am Subject: How to place a space before and after a delimited record |
| Ram,
What if my file is a VB one? The '|' delimiter and other records are in the same columns though. Basically this problem I am facing while migrating from the Platinum Unload utility to DB2 Hi ... |
|
| Topic: How to place a space before and after a delimited record |
|
| sree_sen Replies: 7 Views: 5129 |
Forum: Utilities Posted: Tue Jul 05, 2005 6:08 am Subject: How to place a space before and after a delimited record |
| Thanks a lot, Ram, Its working perfect... | |
| Topic: Want to add a sequence number for duplicate records... |
|
| sree_sen Replies: 5 Views: 4084 |
Forum: Utilities Posted: Tue Jul 05, 2005 4:25 am Subject: Want to add a sequence number for duplicate records... |
| Hi,
I checked in the link as given by Kolusu and there the snippet of Frank gives me the output as- AAA 1 AAA 2 AAA 3 BBB 1 BBB 2 CCC 1 DDD 1 DDD 2 DDD 3 DDD 4 AAA 1 AAA 2 ... |
|
| Topic: How to place a space before and after a delimited record |
|
| sree_sen Replies: 7 Views: 5129 |
Forum: Utilities Posted: Tue Jul 05, 2005 2:54 am Subject: How to place a space before and after a delimited record |
| Hi,
The records to my i/p file are pre-formatted as below - R1 R2 R3 R4 R5 ---------------------------------------------------------(read file) A | AT | 2005| 1 ... |
|
| Topic: Want to add a sequence number for duplicate records... |
|
| sree_sen Replies: 5 Views: 4084 |
Forum: Utilities Posted: Thu Jun 30, 2005 4:54 am Subject: Want to add a sequence number for duplicate records... |
| sorry, typo error, read the last record in my o/p file should come as
abcd xyz s 3 instead of mnop lhg r 3 ...sorry once again, as i was in a quckfix mode to solve my production issue... |
|
| Topic: Want to add a sequence number for duplicate records... |
|
| sree_sen Replies: 5 Views: 4084 |
Forum: Utilities Posted: Thu Jun 30, 2005 4:52 am Subject: Want to add a sequence number for duplicate records... |
| Hi,
I have a requirement where the records in my input file are in the following format - abcd xyz s abcd ijk p mnop lhg r abcd xyz s abcd xyz s ...so on Now i want to add a sequ ... |
|
| Topic: Help sending an Excel file as email attachment thru Mainfram |
|
| sree_sen Replies: 5 Views: 9692 |
Forum: Job Control Language(JCL) Posted: Fri Jun 24, 2005 9:32 am Subject: Help sending an Excel file as email attachment thru Mainfram |
| Hi Valeti,
Could you please tell me how did you create the excel file from a PS using FOCUS tool. DO you have any snippet for this? And also, when you have the PS file why aren't you trying to s ... |
|
All times are GMT - 5 Hours |