mainframegurukul.com

Sort file I'm given Input & Output are same PDS. During input I was given DISP=(New, ,) & same file I'm give to output DIPS=SHR. Pls tell me this JCL going to successfully running or its going to abend? a) no, u cant use because at first when u r opening the PDS it will be in read lock and u cant op...

I'm sorting one file, that file I'm not given any ASC or DESC order. Which one is default value its going to taking? Tell me.


its by default ascending

I've one INSTREM Proc in step 3 & In step 7 I'm going to call that Proc, its possible to call or not?


ys u can call by specifying proc name

What is -811 SQL error? When U are get this error? How U going to solve?


It will come when u r not using cursors and using select stmt in which the stme gettinhg more than one record .

What is DBRM? What is use for Per-compilation time? its an content which contains executable sql codes in our program.and at the time of pre-compilation the cobol lines and sql codes will divide in to two parts and all sql code will store in dbrm. and after that in BIND phase it will execute and cre...

10). What are the advantages of declaring the VARCHAR in 49 level in a COBOL-DB2 program?
the adv. is optomal utilisation of memory.

7). When do we use null indicator of a field? Does the usage of it have any benefits? this is the concept which is for nullable cols in table while inserting. if u r going to insert a null value inthat col. when the value of corresponding indicator is -1 then automatically null value will store in t...

There are different calls in COBOL, Call by content, Call by value and Call by reference. Is it possible that a single CALL statement have all these varieties? When do you go for each one of these? What is the basis and justification? we can write all combination of these in single call stms and di...