 |
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 13 matches |
| Author | Message |
|---|---|
 Topic: Sort using delimiter space |
|
| Sumathi Replies: 8 Views: 5450 |
 Forum: Utilities Posted: Wed Mar 23, 2005 6:44 pm Subject: Sort using delimiter space |
| Frank,
We have syncsort in our shop and when I tried with your sysin, it says the following syntax error. SYSIN : INREC IFTHEN=&# ... |
|
| Topic: Sort using delimiter space |
|
| Sumathi Replies: 8 Views: 5450 |
Forum: Utilities Posted: Wed Mar 23, 2005 3:20 pm Subject: Sort using delimiter space |
| Hi,
My input file has only 2 columns as follows. Reg len is 80. The lengthof first column will be 1 to 9, length of 2nd key is 2. The keys are delimited by single space. 1 12 1 56 111 11 ... |
|
| Topic: Duplicates are not deleted |
|
| Sumathi Replies: 8 Views: 4940 |
Forum: Utilities Posted: Thu Apr 01, 2004 12:53 pm Subject: Duplicates are not deleted |
| Hi Kolusu,
Now I found the problem. Though I am using REPRO with REPLACE at step 5, the VSAM file is not getting refreshed. That was the problem. To resolve this I have included 2 more steps. That ... |
|
| Topic: Duplicates are not deleted |
|
| Sumathi Replies: 8 Views: 4940 |
Forum: Utilities Posted: Thu Apr 01, 2004 12:25 pm Subject: Duplicates are not deleted |
| Kolusu,
I have to use IDCAMS and SORT instead of SYNCTOOL. Hence I have been forced to do this way. Here we go, the detailed information about my assignment. I have to delete some records from th ... |
|
| Topic: Duplicates are not deleted |
|
| Sumathi Replies: 8 Views: 4940 |
Forum: Utilities Posted: Wed Mar 31, 2004 7:52 pm Subject: Duplicates are not deleted |
| Hi Frank,
I tried select with NODUPS option earlier. The error msg what I got was, SYSIN : SELECT FROM(SORTIN) TO(SORTOUT) ON(1,14,CH ... |
|
| Topic: Duplicates are not deleted |
|
| Sumathi Replies: 8 Views: 4940 |
Forum: Utilities Posted: Wed Mar 31, 2004 7:18 pm Subject: Duplicates are not deleted |
| Hi,
I have used the piece of jcl found in this forum, for my requirement. (My requirement is 2 files have to merged, duplicates have to be eliminated and results have to written into another datase ... |
|
| Topic: VSAM - Record manipulations |
|
| Sumathi Replies: 11 Views: 25498 |
Forum: Data Management Posted: Tue Mar 30, 2004 6:10 pm Subject: VSAM - Record manipulations |
| Hi Kolusu and others,
I tried to implement the above exercise using idcams and sort. Find below the jcl, which can be used for both insert and updation. Please have a look and comment for any chang ... |
|
| Topic: VSAM - Record manipulations |
|
| Sumathi Replies: 11 Views: 25498 |
Forum: Data Management Posted: Thu Mar 25, 2004 6:36 pm Subject: VSAM - Record manipulations |
| Hi Kolusu,
Earlier it was not given any errors. The job went through fine. But the result was not what expected. I am using the correct sort fields 1,14,ch,a. As you mentioned in your quote, I hav ... |
|
| Topic: VSAM - Record manipulations |
|
| Sumathi Replies: 11 Views: 25498 |
Forum: Data Management Posted: Thu Mar 25, 2004 6:16 pm Subject: VSAM - Record manipulations |
| Hi Kolusu,
Yes. It helped lot, both Insert and Delete working now. But Update is not. It looks like that SUM FIELDS=NONE is working on the other way. Is that necessary to mention LAST(DUPS) or FIRST( ... |
|
| Topic: VSAM - Record manipulations |
|
| Sumathi Replies: 11 Views: 25498 |
Forum: Data Management Posted: Thu Mar 25, 2004 4:43 pm Subject: VSAM - Record manipulations |
| Great ! But when I try for Insert, it failed with RC 16
The error code is : VSAMIN VSAM OPEN ERROR -- A0 COMPLETION CODE - SYSTEM=000 USER=0016 REASON=00000000 VSAMFILE has been created wi ... |
|
| Topic: VSAM - Record manipulations |
|
| Sumathi Replies: 11 Views: 25498 |
Forum: Data Management Posted: Thu Mar 25, 2004 12:08 am Subject: VSAM - Record manipulations |
| Hi Kolusu and others,
In the mean time, I have gone through other postings and decided to do it in the following way. For Delete: Repro VSAM to Seq file2 ; Use SORT to merge Seq file and Seq file ... |
|
| Topic: VSAM - Record manipulations |
|
| Sumathi Replies: 11 Views: 25498 |
Forum: Data Management Posted: Wed Mar 24, 2004 10:45 pm Subject: VSAM - Record manipulations |
| Hi Kolusu,
I am sorry. I think I didn't made my sentence clearly. Using JCL means it includes all the possible utilities(idcams, sort and so on) as well. In the mean time I could able to complet ... |
|
| Topic: VSAM - Record manipulations |
|
| Sumathi Replies: 11 Views: 25498 |
Forum: Data Management Posted: Wed Mar 24, 2004 6:11 pm Subject: VSAM - Record manipulations |
| Hi,
I need your help to find out the solution for the below. Before posting, I have searched in this forum, but I couldn't get exactly what I want. The challenges are as follows: Challenge 1: ... |
|
All times are GMT - 5 Hours |