IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Doubts on Indexes


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Identify top 30 big tables or indexes... DB2 0
No new posts DB2 XML indexes (V10) DB2 2
No new posts How to access SYSCAT.INDEXES DB2 6
No new posts Doubts in MQ data Converstions Java & MQSeries 3
No new posts Doubts related to insertion of table ... COBOL Programming 1
Search our Forums:

Back to Top