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 |
what is the Foreign key? explain?
What is dclgen (declaration generator)?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
What is a SELECT statement?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
Explain about rct.
What is scrollable cursor in db2?
How do you run JCL in cobol program
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
what is cursor stability?
Describe the elements of the SELECT query syntax?