My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
2 5967I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
6 11088Program A calls program B. Will the working storage variables declared in program B be initialized every time it is called by program A or will the values be retained until the end of program A?
7 20972I have a source program compiled with Cobol-2. The output file has a record length of 100 defined in the program but a record of 60 bytes getting written into it. i.e. The rest of 40 bytes I am not Writing anything. But it by default puts some values into the last 40 bytes. However it does not impact anything. But when Compiled the module with Enterprise Cobol the last 40 bytes were spaces as fillers. Can anyone explain?
5 16679In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 7975IN CICS APPLICATION PROGRAM, INSTEAD OF HARDCODING MAP AND MPASET NAMES WHILE SENDING AND REIEVING ...CAN WE DO LIKE THIS ??? MOVE MAP AND MAPSET NAMES TO WORKING STORAGE SECTION VARIABLES AND USE THOSE VARIABLES WHILE SENDING AND RECIEVING MAP.IF YES, HOW CAN WE MOVE MAP INPUT , OUTPUT VARIABLES. IF ANYBODY KNOWS THIS PLEASE POST THE ANSWER
2 8417There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
IBM,
10 17400
what do you mean by a vsam slot?
in order to execute step2 a job after a return code of 8 in step1, what condition you will code in step2?
Explain sorting techniques in cobol program? Provide the sort file definition, the sort statement, its syntax and meaning
What is the difference between cursor stability and repeatable read isolation levels?
What is the advantage of defragmentation?
Explain the difference between and exec cics xctl and an exec cics link command?
Explain the difference between pseudo-conversational and conversational?
What is a set? What pointers are required, what are possible? How may sets be ordered?
What is dclgen in db2?
what is the meaning of dynamic processing in vsam?
How can you quickly find out the # of rows updated after an update statement?
Hello, I have 3 years of exp as a mainframes tester in a leading IT company, now am looking to change my company. Could you please let me know, what are the interview questions/topics i should prepare. Your suggestions are truly valuable for me :) Thanks !!
Define dynamic processing?
Explain how many work file we can code in jcl?
What are the jcl procedures?