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 5082I 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 9311Program 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 19013I 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 14849In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 6989IN 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 7511There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
IBM,
10 15121
Suppose I have a ksds file. I have a records like 1,2,3,4,5,6,...100. I want to read using dynamic mode like from 10 the record onwards like, 10,12,14,16,18,....60. Wat is the command for this?
What is use of IBM framework?
What kind of error is trapped by on size error option?
Define floating maps with illustration?
Explain the advantage of creating the acbs well ahead of time?
What are the rules for db2 programming?
How to run my rexx exec?
Mainframe project required Postby mache123 ยป Thu Jan 29, 2009 9:10 pm hello..... I want to know about some real time projects.If any one have any Mainframes project, please provide me documentation of it Or else give me the link where can I find that Mainframes projects with Documentation...... or suggest me any if......please
What is psbgen process?
what is the differences between getting the system time with eibtime and asktime command?
how to retrieve the instream data in sysin?
Specify the requirements for automatic task initiation?
How to compare data between two tables in db2?
What is check constraint in db2?
In real storage usage. By monitor through rmf iii the usage of real storage keep in increasing everyday. Why this happen?