Is there any way to use TWO files by a single SELECT

devidas-patil · Active User Joined: 08 Jan 2007 Posts: 54 Location: pune

Hi all

i have two file and i want to use both the file in the cobol program and both file have the same attribute as well as the same FD entires but allowed me to use only one SELECT INFILE ASSIGN TO DDNAME
i cant
---> use two select statement in my program and
--> i cant merge two file,
--> i can't concatenate two file

what to do in this situation?
please let me know.

murmohk1 · Posted: Wed May 30, 2007 10:26 am Post subject:

Patil,

devidas-patil · Active User Joined: 08 Jan 2007 Posts: 54 Location: pune

hi murali
this is question of my interviews so oi told him this two option but he was expecting something different than this

Devzee · Posted: Wed May 30, 2007 10:44 am Post subject:

Anuj D.

devidas-patil · Active User Joined: 08 Jan 2007 Posts: 54 Location: pune

Hi anuj
i not asked him about the file usage. i am very sure he was asking me both are the input file.

Anuj D. · Posted: Thu Jun 07, 2007 8:03 pm Post subject:

Devzee · Posted: Thu Jun 07, 2007 8:15 pm Post subject:

dick scherrer · Posted: Thu Jun 07, 2007 9:08 pm Post subject:

Hello,

You might run a step that copies/merges the 2 files into one before executing your program with these strange rules. . .

Anuj D. · Posted: Fri Jun 08, 2007 7:40 pm Post subject:

Hi,

I hope interviewer asked about simple COBOL-batch program, by simple I mean a program which is not using any database. From the window of original question I think I didn't direct the OP in wrong direction.

However, if you can provide some examples or can direct to some link, that would be great to understand your statements rather better.

dick scherrer · Posted: Fri Jun 08, 2007 8:59 pm Post subject:

Hi Anuj,

If the files were combined prior to the COBOL program, the rather non-business "rules" of the question (can't use 2 . . .etc in the COBOL program) might be met.

I just took that work out of the COBOL code to satisfy the "rules" - probably not the best way to approach this, but keeps the 3 "can't"s out of COBOL

There is always the chance that what the interviewer meant to ask and what was understood to be the requirement was not the same. . . Happens quite often when you combine an interviewer with limited technical knowldege with an interviewee with limited experience and especially if they are communicating in a language that is not the "main" language of either one.

Anuj D. · Posted: Mon Jun 11, 2007 9:28 pm Post subject:

Still bounced..!
Let's leave it.

utkarshtewari · New User Joined: 26 Mar 2007 Posts: 6 Location: Pune

Hi Anuj,
Guess what dick is suggesting is that in RUN JCL we need to put a step to merge/sort the two files into one, using Utilities...thus creating a single file to be dealt with in the program...

and in the next JCL step you can execute the program.

dick scherrer · Posted: Sat Jun 16, 2007 5:02 am Post subject:

Yup, not a way i'd do it if i had the need to process those files, but might get around the non-business requirement mentioned above.

I am fairly sure there is no business reason for the restrictons. . .

Anuj D. · Posted: Tue Jun 19, 2007 6:35 pm Post subject:

Thanks Utkarsh.