ibm interview questions asked on 10 july

karthik1680 · New User Joined: 14 May 2005 Posts: 64 Location: chennai

INTERVIEW QUESTION ASKED @ IBM

1)I HAVE 1MIILLION RECORDS IN A DATASET

I WANT ONLY FIRST TEN RECORDS using JCL

2)CAN WE CREATE PLAN THRU SPUFI?

3)SEARCH ALL & SEARCH

4)JCL CLASS

5)PLAN TABLE

6)TABLE IS PHYSICAL OR LOGICAL?

7)TEST PLAN IN REAL TIME?

8)STATC OR DYNAMIC

9)SUBSCRIPT & INDEX

10)HOW TO CHECK COPY BOOKS IN COBOL PRGMS

11)801 SQL ERROR

12)FILE STATUS CODE?

13)HOW TO USE COMMIT IN DB2

14)SYNCPOINT IN 2 PHASE COMMIT

15)COBOL DB2 PRECOMPILER

16)CICS INITIALISATION

17)PSEDO-CONVERSATION TECHNIQUES

18)PLAN & PACKAGE

19)LOADLIB USE IN COBOL

20)TABLE TYPES

21)MSGCLASS

22)COND DEFNATION

23)ENDEVOR USE IN REAL TIME

24)HOW TO USE CHANGEMAN

25)HOW TO CREATE NEW GEN?

26)WHAT IS DIFFT BET MOD & OLD?

27)COBOL STRING TYPES

28)10 FILE STATUS.HOW TO SOLVE?

29)911

30)DATA MISMATCH IN DB2

31)-922

32)JCL-

33)PARM PARAMETER

34) HOW TO INSERT VALUES IN TABLE VIAL CO BPRG.

35) OCCURS clause

priyesh.agrawal · Posted: Sun Aug 28, 2005 11:11 am

01) Use STOPAFT
02) No.
03) Binary search & Sequential search
04) To assign the job in a specific class defined by the system admin.
09 ) Subscript uses occurence to access while index uses displacement.
11) Connection failure.
12) Make it more clear... Well, its a variable giving current status of the last accessing command on the file.
18) ibmmainframes.com/viewtopic.php?t=1643
19) To store your compiled version of code.
20) In terms of dimention ?
21) Use to assign the job log to an output class defined by the system admin.
22) Use to bypass or execute a perticular step based on some specific condition in a job.
25) Using (+1) in DSN Parameter.
26) OLD gives an EXCLUSIVE control over Dataset, MOD doesn't. Also MOD append recs, OLD replace them.
27) Is there any type of STRING...U can say Numeric, Alpha & alphanumeric.
28) End of File reached.
29) Resource Deadlock
30) Make it more clear.
31) AUTHORIZATION FAILURE
32) WHAT IS THE QUESTION HERE.
33) To pass the data to the program being executed by the concerned step.
34) By executing SQL stmt by prog.
35) Defines tables and provides the basis for subscripting and indexing. It eliminates the need for separate entries for repeated data items.

May be some of them are not answered properly...but due to large volume, I tried to make it as short as possible.

harinatha · New User Joined: 24 Jul 2005 Posts: 28

Hi,

6)Table is physical object, but view is logical object.
10)if you open your cobol program in expand option(Y) in panvalent.
if the copy book is there, it will expand
13)Exec sql
COMMIT
End-Exec.

Priyesh can u give syntax for the below one
01) Use STOPAFT

Thanks & Regards,
Hari.

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 463

HI karthik1680,

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

hi

5)PLAN TABLE
select * from sysibm.syspackagelist where plan = :ws-plan-name

7)TEST PLAN IN REAL TIME?

8)STATC OR DYNAMIC
compiler option is DYNAM for dynamic default nodynam
static it link edited into main module
dynamic it run time

10)HOW TO CHECK COPY BOOKS IN COBOL PRGMS
dont know plz let me know

13)HOW TO USE COMMIT IN DB2
exec sql COMMIT end-exec.

14)SYNCPOINT IN 2 PHASE COMMIT

19)LOADLIB USE IN COBOL

pick up the compiled version at run time we need to declare it in jcl
using jcllib or steplib
20)TABLE TYPES
dimension s means

23)ENDEVOR USE IN REAL TIME
version control tool we can copy from stage6 to dev.

25)HOW TO CREATE NEW GEN?
?

26)WHAT IS DIFFT BET MOD & OLD?
appends at last and exclusive lock over a dataset

29)911
time out due to role back/resource dead lock

30)DATA MISMATCH IN DB2
-180

31)-922
connection failure
32)JCL-
job control language which manages indataset and outdataset and loadmodule for run a pgm
it is interface between app and mvs
33)PARM PARAMETER
1-100 char if any special char enclose with quotes '10+2'
define at linkage section
01 x.
05 xl pic s9(4) comp.
05 xtxt pic x(10)

34) HOW TO INSERT VALUES IN TABLE VIAL CO BPRG.
let me give a clear idea
35) OCCURS clause
repeating field level

if any wrong plz correct me
bye all d best

abeyjp · New User Joined: 26 Aug 2003 Posts: 1

7) It is used when we are using the production DB2 data for the test program( program in test enviornment) we need to create testplan.

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

I'm always amazed at how much effort is required to answer these questions and how little effort is required to say "Thanx for all your help".

Kevin · Active User Joined: 25 Aug 2005 Posts: 234

I'm amazed that someone, a student no less, has opened 21 posts, and yet has not put forth one bit of effort to answer any others. What is the point of paying good money for school if no one there can answer your questions? I would be suprised if this person is actually old enough to be attending job interviews, when they (and some others, I'm afraid) appear to be adolescents, at best.