Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How can we add a field through a program in IMSDB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 190
Location: hyderabad

PostPosted: Thu Nov 11, 2004 4:36 pm    Post subject: How can we add a field through a program in IMSDB
Reply with quote

i was asked how can we add a field through a program
in IMSDB in IBM interview

2> How do u enforce referential Integrity constaint(RI) in IMSDB




Thanks
Siva
Back to top
View user's profile Send private message

NILESHK2302

New User


Joined: 13 Feb 2004
Posts: 14
Location: hyd

PostPosted: Fri Mar 04, 2005 6:31 am    Post subject: Question of IBM
Reply with quote

for the first question ...........there is nothing like a field addition in IMS DB.....what ever we add are segments through program in IMS DB.......i am not sure if the interviewer know IMS or you have wrongly took the question........

for secong question .............referential intergrity terms are related to relational database management systems like DB2.........there will not be any such instance in IMS as IMS is a hierarchial database management system........probably the question is wrongly taken by you or the interviewer himself is in confused state when he asked this question.....
Back to top
View user's profile Send private message
harinadh

New User


Joined: 01 Sep 2004
Posts: 18

PostPosted: Tue Apr 05, 2005 2:59 pm    Post subject: Re: add a field
Reply with quote

Hi,

I think referential integrity means the concept of Logical databases in IMS.

I am not sure. Mostly this is the answer.
Back to top
View user's profile Send private message
Great Indian

New User


Joined: 05 Apr 2005
Posts: 9

PostPosted: Tue Apr 05, 2005 6:18 pm    Post subject:
Reply with quote

Nilu is correct.
Here is the of information regarding your questions:

First:
There is no field adding in ims db.
Segment is the smallest unit of information that a DLI transfers between IMS Buffer Pool and application program....filelds are defined in Segment....and there is no question of adding fields in ims database
(Segment type is simply a catagory of data which contains characteristics of segment...this is formed with collection of fields)

Second:
Since referencial integrity is established between two or more tables in Relational database(this relation is made physically)
where as in IMS DB there will not be any physical relation ship between two databases...only logical relation ship exists that is through PSB(Program Specification Block)

I think this is clear....if not let me know.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us