Author |
Message |
Topic: comparing two files and writing the 2nd file records to outp |
mfsrini
Replies: 1
Views: 2146
|
Forum: Utilities Posted: Fri Oct 07, 2011 9:13 am Subject: comparing two files and writing the 2nd file records to outp |
Hi,
My requirement is as follows:
I need to compare 2 files (eg: yesterday file, today file) and I need to write the differences to 3rd file
constraints:
1) If there is difference b/w firs ... |
Topic: mainframe with Teradata |
mfsrini
Replies: 1
Views: 8658
|
Forum: Other Technical Topics Posted: Sat Oct 23, 2010 12:53 pm Subject: mainframe with Teradata |
Hi,
Please let me know any material/link from which I can learn how Mainframe JCL interacts with Teradata utilities. |
Topic: Reordering of the records through SYNCSORT |
mfsrini
Replies: 6
Views: 4694
|
Forum: Job Control Language(JCL) Posted: Mon Apr 12, 2010 3:16 am Subject: Reordering of the records through SYNCSORT |
Hi,
If any one knows the answer for my queries in syncsort, please help me out. |
Topic: Reordering of the records through SYNCSORT |
mfsrini
Replies: 6
Views: 4694
|
Forum: Job Control Language(JCL) Posted: Thu Apr 08, 2010 4:28 am Subject: Reordering of the records through SYNCSORT |
Hi Kolusu,
Sorry for making you trouble. This is happened because of change in our requirements.
Answers to your questions are as below:
1) Input and Output file LRECL=250 and RECFM=FB
2) T ... |
Topic: Reordering of the records through SYNCSORT |
mfsrini
Replies: 6
Views: 4694
|
Forum: Job Control Language(JCL) Posted: Wed Apr 07, 2010 11:09 pm Subject: Reordering of the records through SYNCSORT |
Hi Kolusu,
thanks for providing the reply. The asked question is just a part of my requirement. My actual requirement need so many other changes as below:
Reorder the file with each '1' record a ... |
Topic: Reordering of the records through SYNCSORT |
mfsrini
Replies: 6
Views: 4694
|
Forum: Job Control Language(JCL) Posted: Wed Apr 07, 2010 5:28 am Subject: Reordering of the records through SYNCSORT |
Hi,
My requirement is as below:
Input file has the records in the following order starts with 1 and ends with 9 in the first position of the file.
1
2
3
5
5
9
I want to reorder the fi ... |
Topic: Copying one file to another file |
mfsrini
Replies: 7
Views: 3372
|
Forum: Job Control Language(JCL) Posted: Thu Feb 21, 2008 1:13 pm Subject: Re: copying |
Bill,
Is it possible to handle within one step |
Topic: Copying one file to another file |
mfsrini
Replies: 7
Views: 3372
|
Forum: Job Control Language(JCL) Posted: Thu Feb 21, 2008 6:29 am Subject: Re: copying |
nic,
I used IEBGENER also. But still I am getting abend.
In my case, input file is dynamically creating in one program. Some time it imight create with VB and some times it might create ... |
Topic: Copying one file to another file |
mfsrini
Replies: 7
Views: 3372
|
Forum: Job Control Language(JCL) Posted: Wed Feb 20, 2008 2:23 am Subject: Copying one file to another file |
hi,
i need to copy one file to another file. I doesn't the format of input file. It might be either FB or VB. My output file should be FB. Since, I doesn't know the format of input file, I can't u ... |
Topic: SORT query |
mfsrini
Replies: 1
Views: 1391
|
Forum: Job Control Language(JCL) Posted: Tue Jan 01, 2008 11:19 pm Subject: SORT query |
Hi,
I need to sort one input file which contains both header and detail records. My requirement is to count the total number of Detail records
Note: All header records are having first 3 chara ... |
Topic: LIKE operator in DB2 |
mfsrini
Replies: 1
Views: 1812
|
Forum: Database Posted: Thu Dec 14, 2006 12:35 am Subject: LIKE operator in DB2 |
hi,
I have to prepare one DB2 Stored procedure. My stored procedure will take the values from calling program and gives the result. In Where clause of that stored procedure, i have to use LIKE ... |
|