Series: Subject: Topic:

IDMS Interview Questions

Showing Questions 1 - 20 of 43 Questions
First | Prev | | Next | Last Page
Sort by: 

Advantages of idms

Asked By: Sondre Ridderholt | Asked On: Oct 30th, 2013

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

What is idms-restart ?

Asked By: shabnam | Asked On: Nov 22nd, 2006

Answered by: anonymous on: Jan 5th, 2012

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

Answered by: vineet on: 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...

What is the meaning of the return codes 0307 and 0326?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

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

Answered by: prateek on: 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.

How can we debug cobol pgm containig idms using xpeditor

Asked By: rohit | Asked On: Mar 8th, 2007

Answered by: anjibmk on: Aug 26th, 2011

Following link may help you.

Answered by: vasu on: 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

Is it possible to obtain a record from idms database without mentioning the record-name itself?

Asked By: pradeep | Asked On: Oct 23rd, 2007

Answered by: Tom LoCascio on: Aug 10th, 2011

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

Answered by: Mark J Couch on: 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...

How to write a idms code to find whose employee last name is starting with j and first name starts with h.

Asked By: santhi | Asked On: Mar 30th, 2007

Answered by: anjibmk on: Aug 4th, 2011


Answered by: amuseham on: Jan 29th, 2009

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

What is an ook-rec?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

An ook-rec is a one of a kind record set, used to get to another record set

Answered by: nudnik on: 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

Answered by: Algis Kantautas on: Mar 21st, 2007

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

Explain the difference between record occurrence and record type?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

A record occurrence is the instances of a record; it is the smallest addressable unit of data. A type is the description of a record; there need not be any occurrences.

Answered by: katar_s on: May 5th, 2011

Record type is like template of record.Record occurance will contains the data

What is the purpose of a ready?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

The ready prepares a database area for access by dml functions.

Answered by: Geekshiraj on: 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.

What is an area sweep and when is it used?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

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.

Answered by: Geekshiraj on: 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...

What is the difference between local and central version operating modes?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

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.

Answered by: Geekshiraj on: 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...

What is a page?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

A page is the smallest unit of storage in an idms database.

When you are obtaining next within a set and get a end of set return code, on what record are you now current?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

You are current on the owner.

Answered by: pravpappu on: Mar 7th, 2009

The Owner Record Occurrence becomes the Current

Idms set of occurances

Asked By: Shrinath24 | Asked On: Jun 9th, 2008

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

Answered by: ls0012099 on: Oct 15th, 2008

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

Answered by: chrisf on: Jun 13th, 2008

It may have zero owner instances.

Does disconnect and connect creates page lock in idms ?

Asked By: Gayathri | Asked On: Oct 23rd, 2007

Answered by: bikas_sinha on: Jul 6th, 2008

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

What does a commit statement do?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

It writes a checkpoint to the journal file and releases any record locks.

Answered by: prasenjit_in on: 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.

How can you submit a job through cobol program?

Asked By: sandhya | Asked On: Dec 18th, 2006

Answered by: Arnab on: 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...

Answered by: udaya00 on: 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.

How does idms insure data integrity?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

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

Answered by: Algis456 on: 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).

What is a set? What pointers are required, what are possible? How may sets be ordered?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

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...

Answered by: Algis kantautas on: 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.

What is the idd?

Asked By: Interview Candidate | Asked On: Sep 29th, 2004

Idd is the integrated data dictionary. It contains information about the elements, record types, sets, maps and dialogues within the database.

Answered by: Algis Kantautas on: 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.

First | Prev | | Next | Last Page





twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.