Interview Questions

ashok_bln · New User Joined: 19 Feb 2005 Posts: 5 Location: bangalore

1.what are the salient features of db2 7 which makes it differ from its previous verison of universal database db2 6.

2.how will u run a job on a particular time & day?

3.do u have any idea of storing euroes(European currency) in cobol edit characters.

4.what is the latest version of cobol ?

5.Diff bwtween JCL Lib and Proc lib?

6.I have one main program which calls 2 sub-programs. I wanted to call one of them as static and the other as dynamic. How?

7.Diff between Sys-Abend and Sys-Dump?

8.What is the result of Select empname from emp where 1=1?

9.how to load records of a flat file to db 2 table?

10.Which is the first executable stmt in cobol?

11.Can we declare cursor in procedure division? If one can declare a cursor in procedure division then does it differ from one which is declared in working storage ...if differs how?

12.Can we create a plan directly without using pacakages?(IBM)

13.Transilation Process?(IBM)

14.How do we pass data from one prog to another prog without using linkage section give syntax?(TCS)

15.If i have 1000 programs.I change one field A(5) to A(10).On which programs is impacted,How u can know?(i-flex)

16.Where u will see the abends in Production?(HP)

17.Member name is ABCD & program name(id) is XYZ. On which name, loadmodule is created.?

18.Is there a way in JCL to identify the oldest GDG version assuming we don't know how many generations will exist at any given time?

19.Is anybody aware of a tool DB2 Veiwer, where one can run a query and can get the data in xls format?

20how to browse TD Queue ?
EXEC CICS WRITEQ TD QUEUE('SLOG')
FROM (SLOG-ERR-RECORD-MSG-LINE)
LENGTH(SLOG-RCD-LEN)

END-EXEC.

21.How to add the functional keys to the dilogs(panels)? IF i press the PF9 it should go the next screen. IF u have any sample code. Please send me

sivatechdrive · Posted: Wed Mar 30, 2005 9:21 am

Hi Ashok

U can find the answers for most of ur queries here
www.ibmmainframes.com/post-5883.html

3.do u have any idea of storing euroes(European currency) in cobol edit characters
Ans : it is done using .Net cobol & the current Ispf panels facilitates an option for Euro character insertion

4.what is the latest version of cobol ?
Ans :Cobol 2002, with OOPS concepts

10.Which is the first executable stmt in cobol?
Ans: the 1st statement of procedure division ( not the pragraph name)

Plz make a search in google u can get all the answers

Thanks
Siva