Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us