MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 11 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: comparing two files and writing the 2nd file records to outp
mfsrini

Replies: 1
Views: 2146

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group