IBM MainFrame Interview Questions
Questions Answers Views Company eMail

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

Cap Gemini, RBS,

3 11395

Can we able to find all the Table names under a Particular Plan?

CTS,

1 5631

what is CCID in endevor, what it is its role?

CTS,

5 36225

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

Cap Gemini,

1 7679

what is differnece between DROP TABLE & DELETE TABLE .

Cap Gemini,

4 9728

What if we fail to give values in columns declared as NOT NULL ?

Cap Gemini,

3 8374

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

Cap Gemini,

2 8155

How to remove the spaces at end of each record in the output file Via COBOL program? note: The file has a VB length

IBM, Wipro,

2 15085

what is the purpose of using link ?

Kanbay,

5 6876

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

Cap Gemini,

1 5618

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

Cap Gemini,

3 11360

What is the output of the following command given in TSO/ISPF terminal? SRCHFOR 'abc' SRCHFORC 'xyz', (+5)

CTS, IBM,

2 11698

What are the sub parameters for UNDO command? How does it work?

CTS, IBM,

2 7994

If A>B next sentence end-if display 1 display 2. display 3. If a>b, it will display only 3.(the next sentence, ie., after fullstop/period) ____________________________________ if a>b continue end-if display 1 display 2. display 3. If a>b, it Will display 1 2 3 (the next statement) ____________________________________ if a>b continue display 1 end-if display 2 display 3. display 4. If a>b, Will it display 2 3 4 (or) 1 2 3 4 ?

UST,

8 9481

Sending data is aplhabetic size 7 (value 3000), I wantated this value to be stored in database, which is defined as s9(7)v9(2)comp-3.

2 5206


Un-Answered Questions { IBM MainFrame }

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

636


What is a base cluste?

598


suppose if you added a coloumn to db2 table, How would it be the Impact analysis?

1507


What is node in db2?

602


What is the function of dbctl?

667






How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1700


How to view db2 table structure?

581


which utility is used to sort a file in jcl?

741


How do you access an uncatalogued dataset in a jcl?

721


How do I start db2 in windows?

554


How to Get Information About the Tables?

1174


How connect db2 database to datastage?

757


without jcl how to run the batch programs

2196


Explain the purpose of dd dummy statement?

665


Can you use max on a char column?

634