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
 

 

ibm interview questions asked on 10 july

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

New User


Joined: 14 May 2005
Posts: 64
Location: chennai

PostPosted: Mon Jul 11, 2005 9:22 pm    Post subject: ibm interview questions asked on 10 july
Reply with quote

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
Back to top
View user's profile Send private message

priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1452
Location: Chicago, IL

PostPosted: Sun Aug 28, 2005 11:11 am    Post subject: Re: ibm interview questions asked on 10 july
Reply with quote

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) http://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.
Back to top
View user's profile Send private message
harinatha

New User


Joined: 24 Jul 2005
Posts: 28

PostPosted: Fri Sep 02, 2005 11:04 pm    Post subject: Re: ibm interview questions asked on 10 july
Reply with quote

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.
Back to top
View user's profile Send private message
Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Mon Sep 05, 2005 10:14 am    Post subject: Re: ibm interview questions asked on 10 july
Reply with quote

HI karthik1680,

Quote:
4)JCL CLASS


Use the CLASS parameter to assign the job to a class. The class you should request depends on the characteristics of the job and your installation's rules for assigning classes.

In a JES2 system, the assigned job class can affect whether or how a job is executed.

Identifies the class for the job. The jobclass is one character, A through Z or 0 through 9, and must be a valid class specified at JES initialization.


Quote:
21)MSGCLASS


Use the MSGCLASS parameter to assign the job log to an output class. The job log is a record of job-related information for the programmer. Depending on the JOB statement MSGLEVEL parameter.

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


STOPAFT is used with Sort command.

STOPAFT=n Where n is number of records

It stops after n number of records.

Regards
Rupesh
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:40 am    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
abeyjp

New User


Joined: 26 Aug 2003
Posts: 1

PostPosted: Fri Sep 09, 2005 5:15 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Sat Sep 17, 2005 6:14 am    Post subject:
Reply with quote

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".
Back to top
View user's profile Send private message
Kevin

Active User


Joined: 25 Aug 2005
Posts: 234

PostPosted: Sat Sep 17, 2005 8:23 am    Post subject: Re: ibm interview questions asked on 10 july
Reply with quote

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.
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 The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
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


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