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 6190I 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 11543Program 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 21554I 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 17099In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 8244IN 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 8657There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
IBM,
10 18111
What is a db2 tablespace?
I want my job (careerride) to be executed in 1 minute and 2 seconds. How do I do that?
What will happen if both steplib and joblib are specified?
Please send me the real time scenarios in Mainframe Project... i.e., it may be in banking or insurance sector or any other no problem..... please send your mails to krishnaprasadbvs@gmail.com
explain in brief what are the 3 types of vsam files?
What are the two types of fields available in ims db?
what is a corelated subquerry?
what sorting order does search all have?
Can you explain dfheiblk?
I have a program with an Array of 5000 occurences which is being passed from 5 sub levels to the front end screen. Thess 5 programs using each 5*2 = 10 different arrays with size as 5000. This is causing the transaction to utilize more storage consupmtion. I am looking to reduce the storage consumption. As part of that initially i thought Dynamic array may solve my problem. After viewing the comments given i see its same as normal array. IS there any other way we can resolve this issue?
What is the use of the eibaid field?
kindly specify the pic clause for the following:any bll cell, data type of length option field, hhmmss type of data fields?
Describe the cobol database components?
What is the difference between local and central version operating modes?
Are scope terminators compulsory? If they are, when?