Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

POLARIS interview question asked on 18th of sep

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
harinatha

New User


Joined: 24 Jul 2005
Posts: 28

PostPosted: Mon Sep 19, 2005 7:54 am    Post subject: POLARIS interview question asked on 18th of sep
Reply with quote

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
Back to top
View user's profile Send private message

Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Mon Sep 19, 2005 10:24 am    Post subject: Re: POLARIS interview question asked on 18th of sep
Reply with quote

Hi,


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


No you can not define in this way. It will give you following error

Code:
"X(3)V99" was not a valid combination of "PICTURE"


Quote:
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?


Use SKIPREC option for this kind of query.


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


In View mode you can check and make changes temperory and after confirmation you can make it permanently.

In Browse mode you can only check the data adn ca not make any changes.



Hope this helps


Regards

Rupesh
Back to top
View user's profile Send private message
Puneet

New User


Joined: 27 Jun 2005
Posts: 9
Location: Chennai

PostPosted: Mon Sep 19, 2005 10:44 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Puneet

New User


Joined: 27 Jun 2005
Posts: 9
Location: Chennai

PostPosted: Tue Sep 20, 2005 7:30 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
cheli

New User


Joined: 21 Jul 2005
Posts: 11

PostPosted: Wed Sep 21, 2005 11:14 am    Post subject: Re: POLARIS interview question asked on 18th of sep
Reply with quote

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.
Back to top
View user's profile Send private message
karthik1680
Warnings : 2

New User


Joined: 14 May 2005
Posts: 64
Location: chennai

PostPosted: Wed Sep 21, 2005 3:29 pm    Post subject: Re: POLARIS interview question asked on 18th of sep
Reply with quote

hi rupesh

could you plz explain browse mode and the view mode elaborately?
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Wed Sep 21, 2005 3:38 pm    Post subject: Re: POLARIS interview question asked on 18th of sep
Reply with quote

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
Quote:
you can check and make changes temperory


& in browse mode you can just read the member, no changes can be done.

Regards,

Priyesh.
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Wed Sep 21, 2005 4:14 pm    Post subject: Re: POLARIS interview question asked on 18th of sep
Reply with quote

Hi Priyesh,

Thanks a lot for your clarification..

Hi karthik,

Quote:
you can check and make changes temporary


As Priyesh mentioned , I also want to add some points in that.

When you open a file in View mode. You can make changes in in and only after your surety u can make in permanent. For this u can use

REP .ZF .ZL command on Command prompt.

If any file contain more than 10000 record you can not open it in view mode you have to open in Browse mode.


Hope this clarifies your doubt.

Regards

Rupesh
Back to top
View user's profile Send private message
prasanth_thavva

New User


Joined: 28 Jul 2005
Posts: 86
Location: Chennai

PostPosted: Sun Sep 25, 2005 11:38 am    Post subject: regarding spufi changes
Reply with quote

) 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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts QUESTION: RETURN CHANNEL pahiker CA Products 21 Thu Apr 20, 2017 12:31 am
No new posts The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Asynchronous CICS Processing Question moezbud CICS 1 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us