POLARIS interview question asked on 18th of sep

harinatha · New User Joined: 24 Jul 2005 Posts: 28

Hi,

1) In SPUFI, We made some changes in a program and saved those changes. After saving , how will you identify the last changes made in the program.

2)can we redine 9(3)v99 comp-3 with x(3)v99 comp-3

3)In a table i am having duplicated records. write a query to fetch those duplicated records
for example, i am having the following table
empid empname
1 hari
2 hari
3 suri
4 ramu
5 ramu

write a query to fetch 1,2,4,5 records.

I wrote the query

Select empid,empname
from emp a
where a.empname in ( select b.empname
from emp b
where a.empid <> b.empid)

is it correct?

the following question asked in HCL

4)In a sequential dataset having 1 million records. if i put edit(e) or browse(b) options aganist that dataset, it says memory out of space.so i need to see last 10thousands records of that dataset.how will i?

5) what is diff b/w view mode and browse mode

Thanks & Regards,
Hari

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

Hi,

Puneet · New User Joined: 27 Jun 2005 Posts: 9 Location: Chennai

1.I believe the query will search the Non-duplicate records only, as in the nested Query you have mentioned the Not Condition.Instead of Not Condition i think if we place '=' that should work.

2.In view mode the number of records can be maximum of 999999.
For view more than that use Browse mode.To see last 10,000 records see the records using file-aid.

3.Comp-3 field cannot be used with Alpha-numeric characters.

Thanks,
Puneet

Puneet · New User Joined: 27 Jun 2005 Posts: 9 Location: Chennai

Hi Hari,

This query works fine
Make
---------
Makeid Makename
11 xx
11 yy
12 aa
13 bb
13 bb

SELECT MAKEID,MAKENAME FROM MAKE WHERE MAKEID IN (
SELECT MAKEID FROM MAKE
GROUP BY MAKEID HAVING COUNT(MAKEID) > 1);
Results>>
Make
---------
Makeid Makename
11 xx
11 yy
13 bb
13 bb

Thanks,
Puneet

cheli · New User Joined: 21 Jul 2005 Posts: 11

Hi,
I find the following Oracle query to delete all the duplicate rows except one.(e.g., if a table have 5 duplicate rows then this query will delete only 4 rows).

DELETE FROM student-table a WHERE EXISTS (SELECT *
from student-table b
where a.student-number = b.student-number and
a.row_id > b.row_id)

Here my doubt is that row_id can be used in DB2 V7 queries.If not then how we can achieve above function in DB2.

Thank U.....Have a nice day.

karthik1680 · New User Joined: 14 May 2005 Posts: 64 Location: chennai

hi rupesh

could you plz explain browse mode and the view mode elaborately?

priyesh.agrawal · Posted: Wed Sep 21, 2005 3:38 pm

karthik,

Suppose you have a job in a member, which got abended at STEP5.
Now you have to run the job again from STEP5.

You go to member having job, open it in view mode, change the RESTART PARM as needed and submit the job. Then you come out of the member.
Now you have ran the job with desired changes, without saving those changes. This is what RUPESH meant to say by

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

Hi Priyesh,

Thanks a lot for your clarification..

Hi karthik,

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

) In SPUFI, We made some changes in a program and saved those changes. After saving , how will you identify the last changes made in the program.?

i am guessing...

command prompt input

COMPARE SESSION

we wll get .. made changes