What is the use of COMMAREA ?Minimum how much data we can
pass from it?
Answers were Sorted based on User's Feedback
Answer / lu
Commarea is zone where u pass your data,you informations
from this program to another program in CICS..(CICS-VSAM,
CICS-DB2,CICS-IMS or CICS only...)It contains 32k...
Is This Answer Correct ? | 19 Yes | 1 No |
Answer / g.kalyani
COMMAREA is a communication area between COBOL and DB2. We
can pass maximum of 32k. If it is more than that we can use
the QUEUES
Is This Answer Correct ? | 23 Yes | 9 No |
Answer / rajani mazumder
Using commarea data can be passed to a called program using
LINK & XCTL commands in a calling program.maximum length is
32K.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / prabu
32K is the therotical maximum value. Cics Programming guide
recommends not to exceed more than 24KB. As rest of the
space will be utilised for other control operations.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / yuvaevergreen
An SQLCA is a structure or collection of variables that is
updated after each SQL statement executes. An application
program that contains executable SQL statements must
provide exactly oMaximum size is 136ne SQLCA.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / rajani mazumder
Passing of data from one program to another is
achieved by COMMAREA defined in working-storage section.
The receiving program will receive the data in its linkage
section, under DFHCOMMAREA.
May be used in functions like RETURN/XCTL/LINK.maximum size
is 32k.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / david staudacher
The COMMAREA is used to pass data between programs, and to
the next program in a pseudo-conversational sequence. The
COMMAREA may originate in either Working Storage or Linkage
Sections, but best practice is to avoid having identical
layouts in each. The best technique is to code the
following, just after the PROCEDURE DIVISION statement:
IF EIBCALEN = 0
EXEC CICS GETMAIN SET (ADDRESS OF DFHCOMMAREA)
LENGTH (LENGTH OF DFHCOMMAREA) END-EXEC
END-IF
Now you have just ONE copy of the Commarea - always in
Linkage. You don't to move it or worry over whether the
most current data is in Working Storage or Linkage. It's
ALWAYS in Linkage.
Is This Answer Correct ? | 0 Yes | 0 No |
Define sqlca.
What is the syntax for creating a table in the db2 database?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Explain the benefits you can get from mainframe connect?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How would you print the output of an SQL statement from SPUFI?
How to compare data between two tables in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is REORG? When is it used?
What is the use of reorg in db2?