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 6103I 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 11340Program 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 21311I 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 16925In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 8139IN 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 8565There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
IBM,
10 17798
How long have you been working on mainframes?
Define free space?
What is bind plan?
how can the same proc be re-used and called by many jobs?
What is maximum displacement and how to cross this limit?
Is automatic restart possible in jcl? If yes, how?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Explain the function of the dd dcb keyword?
What is a set in idms?
How is data retrieved from multiple tables using a single sql statement?
Can you define foreign keys?
If we wish to create bms executable, what are the basic steps that the user has to go through?
Explain dclgen.
Explain the significance of rdo?
What is dbid used in adabas?