Difference between MAP AND MAPSET

Difference between MAP AND MAPSET

Representation of one screen format is called Map (Screen panel). One or more maps linkedited together makes up a mapset (load module). Mapset must have an entry in the PPT. Mapset name has two parts. Generic name (1-7 chars which is used in app pgm) and suffix (1 char to identify the device type)

EMPMAP DFHMSD TYPE=MAP,
MODE=INOUT,
LANG=COBOL,
STORAGE=AUTO,
TIOAPFX=YES,
CNTL=(FREEKB,FRSET,PRINT)

EMPMAP DFHMDI SIZE=(LL,CC)
LINE=NN,
COLUMN=MM,
JUSTIFY=LEFT/RIHT

DFHMSD TYPE=DSECT ===> mapset
DFHMDI ===> MAP
DFHMDF ===> FIELD

Only one mapset is allowed in one assembly run.

Difference between conversational and pseudo conversational programs in CICS

Conversational (Mode of communication between prog and terminal by sending messages ==> Results in waste of CPU Resources as cpu has to wait till the human responds) & Pseudo conversational (Make it look like conversational but CPU is not tied up). Pseudo conversational mode = RECEIVE ==> SEND ==> RETURN TRANSID('TSK123').

Physical map and symbolic map in CICS Difference

What is the difference between Physical map and symbolic map in CICS?

PHYSICAL MAP AND SYMBOLIC MAP = Physical map is a map used by CICS (CSECT) which ensures device independence in the application program. Symbolic map is a map used by application program (DSECT). It ensures device and format independance in an application program.

Differnce between QMF and Spufi

QMF (Query Management Facility) is a query/reporting environment with the ability to format reports. SPUFI is just a quick and dirty SQL execution engine. If you need to produce nice-looking reports, enable user input to a query, or store your queries and reports for future usage, QMF is a much better technology for doing so.QMF also offers data formatting and translation capabilities that are difficult (sometimes impossible) to accomplish using SPUFI and SQL alone.A typical end-user might have difficulty using SPUFI because it requires using data sets to store your SQL statements and pass them to DB2. The results are also delivered to another data set. Most end users are not comfortable managing and manipulating mainframe data sets. QMF, on the other hand, stores its queries in tables and hides this fact from the user with a nice interface for saving and recalling SQL queries (and results). Keep in mind, though, that SPUFI comes for free with DB2 whereas QMF is an add-on product and costs money. Not every DB2 customer will have QMF, whereas every DB2 (mainframe) customer will have SPUFI.

OK, now, what does SPUFI stand for? The answer: SQL Processor Using File Input.