Interview questions

pravien · New User Joined: 22 Feb 2005 Posts: 11 Location: chennai

Hai folks,

Here i am posting the interview questions i faced.Please post the answers for these as early as possible.

1.FD IN-FILE.
01 IN-REC. PIC X(80).
- - -
-
-
PROCEDURE DIVISION.

INITIALIZE IN-FILE.
OPEN IN-FILE.
WILL IT BE SUCCESSFUL??

2. FILE1. FILE2

1 3
2 4
3 5
4 6
5 7
8
9
NOW OUTPUT FILE SHOULD BE LIKE THIS.

FILE3

1
2
3
4
5
6
7
8
9
BUT we have to use pure COBOL LOGIC for this.it would be helpful if any of u can post the piece of code here.

3. How can u retrieve details of employees who have not assigned any project from a table having column PROJECT without using IS NULL option?

sathish_rathinam · New User Joined: 22 Aug 2005 Posts: 59 Location: india

1.u can initialize a record but not a file .u will get some error.
3.select empname,empno,salary from emp where project ='null'.
by,
sathish

mainframesguru · New User Joined: 24 Jun 2005 Posts: 36 Location: Hyderabad

Hi

The following are the answers:

1. You cannot initialize a File. You can initialize only the Record
and also if you are trying to Initialize Record without Opening the File, you would get SOC04 Abend.

2. Follwo the Steps
1) Sort both the Files File1 and File2 Before Executing the Program.
Sort Key should be the one you are trying to compare
2)

*Initial Read
Read File1.
Read File2.

Perform Until Eof-File1 and Eof-File2

If Eof-File1
Continue
End-if

If Eof-File2
Cotinue
End-if

If File1 = File2
Write to Output File From File1 or File2
Read File1
Read File2
End-if

If File1 < File2
Write to Output File from File1
Read File1
End-If

If File1 > File2
Write to Output File from File2
Read File2
End-If
End-Perform.
------------------
Read File1 Para.
Read File1
At End Set Eof-File1 to True

Read File2 Para.
Read File2
At End Set Eof-File2 to True

3.
select empname,empno,salary from emp where project ='null'.

This Query will not work, for Null comparison, we have to use "IS NULL".
I dont have answer for this question.

Thanks And Regards
Vamshi
ICC-ISH

Rameshs · Posted: Wed Aug 31, 2005 2:29 pm

hi pravien,
This will give you the answer

select empname,empno from emp where project not like '_%';

if the query is wrong, inform me

notonly4u · New User Joined: 26 Apr 2005 Posts: 87 Location: Hyderabad

Dear pravien,

In the program we use to give the null indicators while decalring the host variables. So if the field is Null, It'll have a value of '-1'.

So I think it is wise way to check whether the field is null or not without using IS NULL option.

If you have any queries please inform

Regards
Tanden

David P · Posted: Wed Aug 31, 2005 9:01 pm

Hi Pravien,

Can you please elaborate more on your question 2.
I did not get exactly what the second question is?

regards,
David.

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

Here's a cut & paste of a similar pgm. The key is to recognize the relationshp between the recs in each file and know what action to take. In your case you want to write to the O/P.

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

Hi,

sumivel · New User Joined: 13 Sep 2005 Posts: 18

open input file1
open input file2
open output file3

Read file1
Read file2

perform until eofile1 and eofile2

if f1rec<f2rec
move f1rec to f3rec
write f3rec
read flie1

else
if f1rec >f2rec
move f2rec to f3rec
read file2
end-if
end-if
end-perform

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

Sumivel,

What happens when you have 10 recs in file1 and 100 recs in file2 and you hit EOF on file1?