Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Doubts on Indexes

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

New User


Joined: 12 Jun 2005
Posts: 28
Location: Hyderabad

PostPosted: Wed Sep 07, 2005 10:16 pm    Post subject: Doubts on Indexes
Reply with quote

Hi,
I am new to mainframes can any one help me out please

1. How many uniique indexes can a table have?

2. What is the maximum number of indexes and columns a table can have?

3. What are the steps in Compilation process?

4. What are the different ways to pass data from JCL to Cobol?

5. I am having an employee record. I have to change the empno field from 9(5) to 9(7). this field is there in 100 programs. What are the steps to successfully implement the Change. What i know is with 3.14 option we can find out the locations where the empno field is there. After locating this and changing the length, what are the steps to make this change successfully run in production environment.

6. What is configuration management in mainframes.
Back to top
View user's profile Send private message

prasanth_thavva

New User


Joined: 28 Jul 2005
Posts: 86
Location: Chennai

PostPosted: Thu Sep 08, 2005 10:25 am    Post subject:
Reply with quote

How many uniique indexes can a table have?
table contains only one unique so only one
What is the maximum number of indexes and columns a table can have?
that is depends on columns there is unique and non unique indexes so we can n number of indexes
What are the steps in Compilation process?

u did not mention which one

COBOL PGM
STEP1>but if a cobol means compile with IGYCRCTL and link edit with IEWL
if u r using a Db2 pgm u have to use

STEP2>
DB2 COBOL PGM
Precompile DSNHPC
then step1 do as above
come to other side u have to perform db2 bind
use IKJEFTO1 AND BIND PACKAGE AND BIND PLAN CREATES APPLICATION PLAN


CICS DB2 COBOL

TRANSLATE
FOLLOW STEP2 AND STEP1

What are the different ways to pass data from JCL to Cobol?
They are 3 ways
1> process and cbl it is usually used to give compiler options
amode,rmode,ssrang,....
2> sysin dd * /data have to write ACCEPT in pgm
3> parm (1-100)

5. I am having an employee record. I have to change the empno field from 9(5) to 9(7). this field is there in 100 programs. What are the steps to successfully implement the Change. What i know is with 3.14 option we can find out the locations where the empno field is there. After locating this and changing the length, what are the steps to make this change successfully run in production environment.
do a appropriate changes in pgm and compile and test it
6> What is configuration management in mainframes.
usually that is used for endevor (configuaration management tool like)
i am guessing plz correct me if u know

bye all d best
plz correct me if any thing wrong
icon_question.gif
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 Identify top 30 big tables or indexes... ashek15 DB2 0 Fri Jun 16, 2017 10:01 am
No new posts DB2 XML indexes (V10) ozburt DB2 2 Tue Jan 07, 2014 3:39 pm
No new posts How to access SYSCAT.INDEXES ravikumar15 DB2 6 Thu Apr 25, 2013 1:08 am
No new posts Doubts in MQ data Converstions Thamilselvi Java & MQSeries 3 Mon Jul 02, 2012 3:48 pm
No new posts Doubts related to insertion of table ... Vidya Kajale COBOL Programming 1 Tue Apr 24, 2012 11:54 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us