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
 

 

HEXAWARE/HCL/TCS - Some Interview Questions

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

New User


Joined: 03 Mar 2005
Posts: 2

PostPosted: Sun Apr 02, 2006 7:29 am    Post subject: HEXAWARE/HCL/TCS - Some Interview Questions
Reply with quote

Let me give some of the interview ?s i faced..
Answer Please..

1. What is the maximum limit for length for a COBOL copybook?
2. What is internal storage for COMP and COMP-3 for a value "12547"?
3. What is maximum value (in bytes and value) that can be passed from jcl to COBOL thru parm
4. What is maximum value (in bytes and value) that can be passed from jcl to COBOL thru sysin?..
5. How many values can be acceptable in one ACCEPT in COBOL..

5.i. Scenario
In jcl
//sysin dd *
123,124..(what is limit)
5.ii. Scenario
In jcl
//sysin dd *
123
124
(what is limit)
6. What is use of Explain parameter in BIND CARD?
7. How many DBRM/Package/Plan will create for a DB2 Module?
8 Which one is efficient Package/Plan?
9. OPEN cursor - What it will do other than locating the record?
10. Declaration of length of EIBCALEN?
Back to top
View user's profile Send private message

skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Thu Nov 23, 2006 2:16 pm    Post subject: Re: HEXAWARE/HCL/TCS - Some Interview Questions
Reply with quote

Answers .....

2.Comp is binary storage ... Comp-3 is hexadecimal storage
3.100 bytes
5.only one value at a time
6.Explain gives the access path to the SQL calls
9.Will point to the first record after the selection criterions are made.

Thats all i know ....
Back to top
View user's profile Send private message
kavitha81

New User


Joined: 21 Nov 2006
Posts: 6
Location: bangalore

PostPosted: Thu Nov 23, 2006 5:53 pm    Post subject: Re: HEXAWARE/HCL/TCS - Some Interview Questions
Reply with quote

Hi,
I think when we give "open cursor",it will load the cursor with records.
Back to top
View user's profile Send private message
kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Fri Nov 24, 2006 5:30 pm    Post subject: Re: HEXAWARE/HCL/TCS - Some Interview Questions
Reply with quote

To add....

1. There is no such limit in terms of size it can be coded upto 999999 variables.

2. Comp takes 4 bytes and comp3 takes 1 byte for every 2 characters.

6. Explain gives the SQL execution path. i.e, the query can be excecuted in many ways but Db2 takes the best path. To know that you need to give EXPLAIN during bind.

7. Db2 module, you mean for the complete project. if so it is like this, One module/ Project has one plan. Each program has one DBRM which yields one Package

8. package concept is more effient. cause you can Compile and bind only that subprogram when you change any code in that.
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 Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am
This topic is locked: you cannot edit posts or make replies. Mainframe interview on 10th Oct 2015 ... kotesh Mainframe Jobs 0 Thu Oct 08, 2015 5:21 pm


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