1. How do u decide the complexity of the program/event. Have u used any methodology
-- As per my knowledge
-- In general it depends on many factors like the number of databases it is accessing-for updating/retrieving/reading etc.,,
And the number of procedures it is invoking/using and the number of programs effecting n so on...
2 How do u ensure that your program's functionality remains unaltered, even though u have deleted a para in your program.
-- As a programmer it is important to maintain the existing functionality
and to maintain different versions,we make use of Version controlers
3. What is the difference between ISO 9001 and ISO 9002
-- Am not sure,i know these are certification levels
5 In ISPF besides nulls, How do you create null character at the end of data line
6. Explain exception handling and security in DB2
norally we have standard error handling subroutine .we just include those things before procedure division
-- In programming we take care of these exceptions like null-indicators
-- null indicators is different .
7. What is EraseOff
9. How do u compile a BMS Map after changing some fields in it.
How do you check its Syntax
-- whenever u make changes to ur cobol-cics pgm we have to refresh the load module by using the cmd CEMT pgm(pgm-name) SET NEWC
10 How do u test the program from one break point to the next break point in one step
-- In expeditor we define the block from where to where exactly we want to execute after definig the blocks press F12,in one single step it debugs and show s u th eresult
11 How do you retrieve the previous version of a program, write all the steps involved in it
-- Using the version controller retrive the previous version in to ur local pds .we have several version controllers like Endevor,panvalet etc
12 I have these fields in my specs -- > Emp-Id, Dept-No, Salary.
Write a program to count the no of employees in a department.
-- In cobol-db2 pgm use select statement along with the count function
based on emp-id
13 How do u convert a VSAM file into ISAM and viceversa
-- No clue
14 How do u ensure that data is passed from Map to the program
By checking the EIBCALEN length. correct me if im wrong.
-- Ur right by EIBCALEN
15 I pressed update option without changing any field in the map,
Is data passes from Map to the program
-- Displays the same map, as it checks the MDT field for the map
16 What is Source Contr4ol Language , what are its uses
-- No clue
17 Can u use Renames clause any where in W-S Section or We have to use it as the last entry
-- We can use any where in w-s section, but only one condition we have check that it should follow the record's last data description entry
18 How many bytes are required for the following declaration 05 data1
PIC S9(18) Comp-3 and 05 data2 PIC S9(19) Comp-3. Do u get compilation error for data2
-- no compilation error occurs,since both are of same type n no issues
19 difference between Goback ad Exit Program
-- GOBACK returns control to the main program and EXIT performs nothing and indicate the end of a paragrapgh execution
20 I coded two Symbolic parameters first one is coded correctly and second one is wrong.
After submitting the job, which one is passed the correct one or wrong one
-- I couldn't get u
21 What is Normalization ad How do you do it
-- Normalization is used to eliminate the data redundancy i.e repeatition of data , go thru the normalization in db2 we just follow the five noral forms of RDBMS
22. What % does Project Management takes in a Project Plan
23. How do you specify a list of Loadlibs in a Job
--??? i couldn't get u
in general we specify only load module in our job
24. When you compile a program, where will the program is loaded, Why
-- During Compilation it expands all the system pgms and converts the pgm into a machine readable format and linkedits with pgm and prepares a executable form called Load Module
25. In latest MVS Version(MVS/ESA), what is the storage capacity
26 How do you do the analysis, Coding and testing of the program,
Do u use any methodology/Tools for testing
-- It depends for unit testing we can make use of tools like xpeditor r simply u can check by submiitin the jcls with sample data we can.
27 How many types of LRECL are there in JCL
-- Fixed and Variable
28 Have u used IF in JCL , why do use it
-- For conditional execution
29 How do u Initialize a particular element when I create an array of 1000 elements.
--????, as per my knowledge array is not get affected with INITIALIZE verb
one way is to move zeros or spaces to the particular element
30 I specified access = Dynamic and tried to access a record which is not there,How do you handle this error.
-- trying to access a record which is out of defined boundary/address space throws a SOC4 error-address exception,
-- can handle by specifying the parm = SSRANGE it gives soc4, if parm= NOSSRANGE than no error gives
31 What is the use of String. Ca u use String to concatenate an alphanumeric data item with numeric, / a numeric data item with another numeric data item
as per my knowledge it works only for alphanumeric to alphatic
32 Which configuration management
33 What is Endevor, Have u used it to compile a program
it is version controller .it will compile the program when u add the element in to endevor
34 Have u coded SQL Statements in JCL
35 What is forward scheduling and backward scheduling.
36 Which estimation methods have u used. What are the contents
of Project Management Plan
-- No clue
I'd like to add/correct few things related to your message.
For Question no. 18] PIC S9(19) Comp-3 can't exist as the maximum that the Numeral can withstand on Mainframe is 9(18); even though the storage is less than 18 bytes.
This logic is the same for scientific calculator/Computers also. So, definitely you can expect Compliation errors.
For Qstn. 34] Have u coded SQL Statements in JCL???
Yes... We can write SQL Statements in JCL. We've implemented the same in Production and it's running fine till date.
I saw the same question and an answer in another thread, but it lacked the ending with an Semi-colon (';').