The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program.

jayesh oza

• Jan 25th, 2017

The schema is the physical arrangement of the data as it appears in the DBMS. The sub-schema is the logical view of the data as it appears to the application

Fsha Tsgab

• Dec 27th, 2016

How to prepare sub schema for five data items?

Answer Question  Select Best Answer

anjibmk

 Profile Answers by anjibmk Questions by anjibmk

• Aug 26th, 2011

Following link may help you.
http://www.mainframegurukul.com/srcsinc/XPEDITER.html

vasu

• Sep 3rd, 2007

You need to compile the program by selecting xpeditor option 'Y".Then you need to enter XP-->3 in ISPF menu.Specify the JCL and select the step which you want to debug by placing "I" before that step then give the RUN command

Answer Question  Select Best Answer

An OOK-Rec is a one of a kind record set, used to get to another record set

nudnik

 Profile Answers by nudnik Questions by nudnik

• Jul 4th, 2011

One Of a Kind Record is a usually a CALC record with only one occurrence of the record type in the entire database

Algis Kantautas

• Mar 21st, 2007

OOK-REC - it is IDD metaschema record. IDD metaschema is generating during installiation time

Answer Question  Select Best Answer

0307 is end-of-set and 0326 is record not found.

lester

• Jan 21st, 2016

0307 is end of set. 0326 is record not found

prateek

• Dec 10th, 2011

0307- end of set
0326- rec not found

Error code is 4 Bytes.

MAMI---> MA indicates the major command that was executing like 03 means for OBTAIN.

MI- Minor code associated with the command.

Answer Question  Select Best Answer

anjibmk

 Profile Answers by anjibmk Questions by anjibmk

• Aug 4th, 2011

WORKING-STORAGE SECTION. 01 WS-REC-DATA. 10 VAL1 PIC X(..). 10 ... 10 ... 10 EMP-NAME PIC X(...). 15 EMP-FIRST-NAME PIC X(..). 15 EMP-LAST-NAME PIC X(..). PROCEDURE DIVI. SA. ** AFTER BIND,READY SET F...

amuseham

 Profile Answers by amuseham Questions by amuseham

• Jan 29th, 2009

 01  WS-EMPLOYEE-NAME.        05  FIRST-INITIAL             PIC X.    ...

Answer Question  Select Best Answer

anonymous

• Jan 5th, 2012

This isnt a feature provided with the IDMS product. Wish it were!

vineet

• Jul 12th, 2007

The idms-restart is a record which will keep track of the number of records(& its data) processed before a particular program abends.The restart record has a calc key which is nothing but the...

Answer Question  Select Best Answer

Arnab

• Aug 7th, 2007

Hi,You can submit a job from a cobol pgm. Write JCL cards to a dataset with //xxxxxxx SYSOUT= (A,INTRDR) where 'A' is output class, and dataset should be opened for output in the program. Defi...

udaya00

 Profile Answers by udaya00 Questions by udaya00

• Jun 12th, 2007

you can not submit job (batch or online) thru cobol program.but u can use cobol pgm in either batch or online applications.

Answer Question  Select Best Answer

Tom LoCascio

• Aug 10th, 2011

Sure. Obtain next with AREA. As is an AREA sweep.

Mark J Couch

• Nov 6th, 2007

Yes, by using the OBTAIN FIRST/NEXT within area/set name command. However if you have more than one record type in the area, or a multi-member set you won't know what you have. You should only use thi...

Answer Question  Select Best Answer

In IDMS which of following is true for any set of occurances?1. It may have zero owner instances.2. It must have one and only one owner instance.3. It must have atleast one member instance.4. None

ls0012099

 Profile Answers by ls0012099 Questions by ls0012099

• Oct 15th, 2008

2. It must have one and only one owner instance.

chrisf

 Profile Answers by chrisf Questions by chrisf

• Jun 13th, 2008

It may have zero owner instances.

Answer Question  Select Best Answer

In local there is no IDMS System running above the DBMS. It is the more efficient mode but lacks the recovery and integrity facilities of the central version (CV) control program. In CV many application programs access the database through a single copy of the DBMS.

Geekshiraj

 Profile Answers by Geekshiraj Questions by Geekshiraj

• Jul 14th, 2010

Local Mode A batch program that operates in local mode has its own copy of IDMS DBMS loaded into its partition, region or address space Good for Batch Retrieval programs Local mode operates...

Answer Question  Select Best Answer

Calc is based on a symbolic value which is used to determine the target page. Via mode is for members only. Via records are stored near to their owners. In direct mode the target is specified by the user and is stored as close as possible to that page.

rohit

• Mar 8th, 2007

three modes calc,via,direstcalc: here any fileld value in the record is converted into a combination of page no and line no by means of a hashing algo... to be  staright one can access the record...

Answer Question  Select Best Answer

A set is an owner record and, optionally, its member records. There are three types of pointers: next, prior and owner, but only next is required. There are five possible orders for arrangements of sets; they are: first - insert at beginning, last - insert at end of set, next - insert after current of set, prior - insert prior to current of set and sorted - insert according to sort value.

Algis kantautas

• Mar 21st, 2007

A.By Codasyl conception SET is data chain between Owner and Member record. B.Pointers: NEXT,PRIOR,OWNER(direct adresation to OWNER_RECORD from MEMBER).At least NEXT pointer is requered to navigate via set.C. Number of sets really  is unlimited.

Answer Question  Select Best Answer

The READY prepares a database area for access by DML functions.

Geekshiraj

 Profile Answers by Geekshiraj Questions by Geekshiraj

• Jul 23rd, 2010

The Ready statement performs an equivalent function as an OPEN statement for a conventional file. It makes the required area of the database available to the program. This statement begins a run-unit.

Answer Question  Select Best Answer

It writes a checkpoint to the Journal File and releases any record locks.

prasenjit_in

 Profile Answers by prasenjit_in Questions by prasenjit_in

• May 28th, 2008

It completes a LUW. In case of DB2  changes made to database will not take effect untill a COMMIT statement is encountered.

Answer Question  Select Best Answer

IDD is the Integrated Data Dictionary. It contains information about the elements, record types, sets, maps and dialogues within the database.

Algis Kantautas

• Mar 21st, 2007

Integrated Dictionary Directory. IDD - it is metaschema where are stored other "entities" of IDMS components -  elements, records, maps,dialogs,areas, subschemas, schemas.

Answer Question  Select Best Answer

IDMS uses record locks to prevent another run-unit from updating the same record.

Algis456

 Profile Answers by Algis456 Questions by Algis456

• Mar 22nd, 2007

All objects and relations beween them are 100% "described" in IDMS IDD.  So all tranzactions of any user or programmer are 100% documented. Advanced IDD administrator knows everytning about any user task or development step (about programmers mistakes also).

Answer Question  Select Best Answer

An area sweep accesses records on the basis of the physical location in a database area. It can be total, meaning a record by record search of the area, or it can be of occurrences of records of a specific type.

Geekshiraj

 Profile Answers by Geekshiraj Questions by Geekshiraj

• Jul 23rd, 2010

In performing an area sweep, IDMS/R scans through all the records in an area in physical sequence. The order in which records are retrieved will generally have little relationship to the logical seque...

Answer Question  Select Best Answer

You are current on the owner.

pravpappu

 Profile Answers by pravpappu Questions by pravpappu

• Mar 7th, 2009

The Owner Record Occurrence becomes the Current

Answer Question  Select Best Answer

bikas_sinha

 Profile Answers by bikas_sinha Questions by bikas_sinha

• Jul 6th, 2008

Yes,  All Store , Erase , Connect , Disconnect do page lock.Modify only lock the instance of the record currently modified.

Answer Question  Select Best Answer

What is the advantages of using IDMS compared to other database systems?

anonymous

• Apr 29th, 2015

There are hard pointers stored along with the record. This helps fast retrievals of member records in the set. Also, since related member records are stored along with owner records, there is no need to scan different tables to get member records.

Answer Question  Select Best Answer