Following questions were asked in Capegemini on 8th sep,2012
1.)Condition code for dul recors in VSAM-
2.) Is NULL or =NULL in Select statement
3.)max size of CI
4.)What happens after CI is full
5.)Ques on COND parameter
6.)which among following can not be rolled back a)delete table
b.)droptable c)Update d.)insert
7.)groupby and orderby sql querries
8.)Max extents in VSAM file
9.)quesn on DPRTY=(1,10)
10.)range of condition codes in COBOL
11.)occurs clase can not be used at which level?
12.)delimiter in jcl
13.)sort card for file in PGM=SORT
14.)PIC(6) value 120056 possible?
15)question on BLKSIZE Is (20,20) and (20,10) possible?
16.)number of bytes in RDF
17.)Can we use index in WS-section or LK-section
18.)Verify command in IDCAMS used for?
19.)question on Alternate Index
20.)Return code of file attribute mismatch
21.)In which format COBOL variables stored?
22.)what is Alternate of HANDLE?
23.)can SUM,AVG,MIN,ROUND used in numeric and char variable
24.)What is the datatype of FILE STATUS codes in WS-section?
Answers were Sorted based on User's Feedback
Answer / bejjanki
I'm answering those questions which i'm aware.
2) IS NULL is correct
7) Groupby is used to club rows based on a condition, order
by is used to sort based on a column
8) 123 extents(Non-Contiguous locations)
9) Dprty is used to execute steps based on condition.
Dprty = 1 + (16*10) = 161
11) 01 Level
12) Delimiter(/*) is used to tell where our instream ends
13) sort fields=copy
14) There is a syntx error you have mentioned pic(6) here
you are not mentioning the data type..If it is PIc X(6)
Or PIC 9(6) then we can store 120056 in it.
15) Question is not clear
16) 4 bytes
17) We are not supposed to use index in WS or LK section
21) That depends on how u declare. By default it's is
stored in display format(character)
22) Handle? I haven't heard about this
23) It's used in Numeric or alphanumeric not in alphabetic
24) PIC 9(2) I mean 2 bytes
I have answered 15 out of 24...Let me know if you have any
questions - Mail me @ Mainframe.firstname.lastname@example.org
|Is This Answer Correct ?||2 Yes||1 No|
Answer / vids
20. 39 file attribute mismatch
|Is This Answer Correct ?||0 Yes||0 No|
what is the diff b/w select stsmt and cursor ?
how to create temporary data set in jcl? what is the use?
write a program to eliminate duplicate records in a input file and send them to output file.THIS IS IGATE RECENT QUESTIONN.....JUST 1 WEEK BACKKKK...
What will happen if a variable is declared as below.. Explain with an example? Working storage section:- 01 WS-VARX PIC X(9) VALUE SPACES. 01 WS-VARN REDEFINES WS-VARX PIC 9(9).
IF there 5 to 6 files in a JCL and there is some space abends, how can we identify which file has space abend and what can be done to get off that abend or rectify that abend.
What is ASKTIME, SUSPEND
What is the Linkage section? What is the Use and Why the parm length use alway "PARM-LENGTH PIC S9(4) or PIC S9 (4) COMP." any reason?.Please let me know any one... Cheers,Prasad
i have two file, each file having : file1 is having 2 fields field1 field2 file2 is having 3 fields field1 field2 field3 my req is to make it one file like: field1 field2 field1 field2 field3 if anyone know please send me syntax, i tried this with DFSORT but could not succeed.
what is the difference between COBOL2 AND COBOL390?
hi is there any means of deletin a record from a ps usin cobol not using jcl?eg if i am reading a record and if some condition is matched tat particular record must be deletd fom the ps
what is the advantage of using redefines instead of delaring the variables ?
How to read records which is in sequential file in reverse order ? Exp. 1 2 3 4 5 . i want 5 4 3 2 1?please clear my doubt any one