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
 

 

EDS interview query

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

Active User


Joined: 17 Oct 2004
Posts: 190
Location: hyderabad

PostPosted: Mon Apr 25, 2005 10:56 am    Post subject: EDS interview query
Reply with quote

Hi Friends

I was asked some tricky questions in an interview, please share your answers

On endevor:
One of your friends did a checkout for an element & went on leave ... how can you checkout (not copy) the same element?

On DB2
You have 5 SQL queries in a program, how can you know the efficiency of the queries using a plan table

On COBOL
Move Spaces to filler ----> will this work?

then I have one personal question on COBOL
A table whose data is contained in the DATA DIVISION is known as a(n)
____________ .
a. loaded table
b. key table
c. input-loaded table
d. linear table
e. hard-coded table



Regards
Siva
Back to top
View user's profile Send private message

csreddy

New User


Joined: 29 Apr 2005
Posts: 1

PostPosted: Fri Apr 29, 2005 4:36 pm    Post subject: Re: EDS interview query
Reply with quote

Cobol- Spaces should not be moved to FILLER
Back to top
View user's profile Send private message
Ram_k

New User


Joined: 28 Apr 2005
Posts: 5
Location: Chennai

PostPosted: Fri Apr 29, 2005 4:51 pm    Post subject: Re: EDS interview query
Reply with quote

Hi,

Reg your below ques

On DB2
You have 5 SQL queries in a program, how can you know the efficiency of the queries using a plan table

Ans: -

When you bind the program by specifying explain yes parameter you can view details of each sql in the plan table by using the query no..

The efficiency of each query can be determined by checking the following criterias in the plan table
1. Check the access path by inex or indexonly
Note: - some times table space scan is the best way to access the data..it depends on the vol of data...
2.Check whether the tables specified in your sql got loaded in the way you want it..this is another important factor which will affect the performance..
3.check for sorts (order by,group by)
...etc

Hope this gives you some idea..
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Wed May 04, 2005 6:55 am    Post subject:
Reply with quote

Hi Siva,

Think about moving spaces to a fillier. What one of the fillers? How do you tell the compiler which one you want? That was the trick to the ques.

Iwould guess the ans to the last one is "e", hard coded. Anything that's coded as a literal is "hard coded".
Back to top
View user's profile Send private message
srividya.srinivasan

New User


Joined: 30 Mar 2005
Posts: 11
Location: Pune, India

PostPosted: Thu May 05, 2005 3:08 pm    Post subject: Re: EDS interview query
Reply with quote

Hi Guyz,


Regarding Shiva's Question about moving Spaces to Filler.

You can never move spaces to soem thing i.e the filler that is not defined at all.

Hence even if u move it, u'll get an error stating Filler is not defined.


Vidya
Back to top
View user's profile Send private message
David P

Active User


Joined: 11 Apr 2005
Posts: 106
Location: Cincinnati Ohio

PostPosted: Fri May 06, 2005 12:43 pm    Post subject:
Reply with quote

Hi Siva,
On Endavor.
If you want to check out some module which is already signout by someone else you need to override signout provided you have the previlage for the same or else you will have to contact the admin for it.

let me know in case of any concerns.
regards,
David.
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 The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm


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