What are ISOLATION LEVELS? Where do we need to specify them
in compiling JCL (Exactly which statement and what is
syntax for it)?
Answers were Sorted based on User's Feedback
Answer / vijay
It is a bind parameter,It determines the duration of the
page lock.
It contains three possible values are there.
1)cs(cursor stability).
2)rr(repeatable read)
3)ur(uncommitted read)
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / chandra
Leena,
The Isolation level can b given in BIND parameter only. not
in JCL, but the member nameshould be given along with ur
DBRMlibrary in DBRMLIB step in JCL.
| Is This Answer Correct ? | 2 Yes | 0 No |
How do define dynamic array in cobol.
can we redefine 77 level item is it possible
What happens when we move a comp-3 field to an edited (say z (9). Zz-)?
how many times PARA-A is performed : PERFORM PARA-A VARYING TIMES-COUNTER FROM 1 BY 1 UNTIL TIMES-COUNTER >0 PARA-A MOVE P TO Q MOVE H TO TIMES COUNTER a.10 b.1 c.11 d.0
how many bytes does s9(15) occupy in comp1 comp2 and comp3 ?
IDENTIFICATION DIVISION. PROGRAM-ID. MOVEPGM. DATA DIVISION. WORKING-STORAGE SECTION. 01 WS-I PIC 9(2). PROCEDURE DIVISION. A1000-MAIN-PARA. PERFORM PARA-X WITH TEST BEFORE UNTIL WS-I= 5 STOP RUN. PARA-X. DISPLAY "BEST2". I m getting error s722,while executing the program, seems getting in loop, can anybody tell me why
What does the IS NUMERIC clause establish ?
Following questions were asked in Capegemini on 8th sep,2012 mainframe test 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 data types? 24.)What is the datatype of FILE STATUS codes in WS-section?
Why we should use cursor ?
Write a cobol program making use of the redefine clause.
consider the following two IF statements: IF X AND NOT Y MOVE A TO B IF Z=1 OR 9 MOVE A TO B select one of the following data divusion entries which gives identical results for both the above IF statements a.01 Z PIC 9 88 X VALUE 1.9 88 Y VALUE 0.2 THRU 8 b.01 Z PIC 9 88 X VALUE 0.2 THRU 8 Y VALUE 1.9 c.01 Z PIC 9 88 X VALUE 1.9 88 NOT-Y VALUE 0.2 THRU 1.9 d.none of yhe above
How to code fscode 10 in cobol program? Where yoy code in your pgm?give ans for the question.