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
 

 

Difference between area and sets

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
rasnc

New User


Joined: 31 Dec 2009
Posts: 10
Location: Bangalore

PostPosted: Thu Dec 31, 2009 5:27 pm    Post subject: Difference between area and sets
Reply with quote

Please can any body explain me the difference between Area and Sets in IDMS with example.
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2422
Location: Netherlands, Amstelveen

PostPosted: Thu Dec 31, 2009 5:40 pm    Post subject:
Reply with quote

http://en.wikipedia.org/wiki/IDMS

The next time do a search yourself, before asking.
Back to top
View user's profile Send private message
rasnc

New User


Joined: 31 Dec 2009
Posts: 10
Location: Bangalore

PostPosted: Fri Jan 01, 2010 9:43 am    Post subject:
Reply with quote

Already I had searched on this but i did not understood so i asked to tell difference between set and Area with example. If anybody can tell me about this topic because just now I have started learning IDMS.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Fri Jan 01, 2010 10:22 am    Post subject:
Reply with quote

The Wikipedia article is pretty clear. An IDMS set is a one-to-many relationship between records. An IDMS area is a preformatted file (or part of a file or parts of multiple files) used to physically store the data. So a set is data while an area is a partitioning of the files.

Perhaps if you explained where you're having trouble with the concepts?
Back to top
View user's profile Send private message
rasnc

New User


Joined: 31 Dec 2009
Posts: 10
Location: Bangalore

PostPosted: Fri Jan 01, 2010 10:28 am    Post subject: Reply to: Difference between area and sets
Reply with quote

I want an example for this, so that I can understand it clerly.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jan 01, 2010 10:40 am    Post subject:
Reply with quote

rasnc,
find another line of work,
you obviously do not have adequate background education.
Back to top
View user's profile Send private message
rasnc

New User


Joined: 31 Dec 2009
Posts: 10
Location: Bangalore

PostPosted: Fri Jan 01, 2010 10:44 am    Post subject:
Reply with quote

Sorry, I did not understood "find another line of work". Anyways if possible can you suggest me any good books in IDMS because i have been allocated in project of IDMS so want to know about this.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jan 01, 2010 10:50 am    Post subject:
Reply with quote

Quote:

Logical Data Model:
...
The most distinctive structuring concept in the Codasyl model is the set. Not to be confused with a mathematical set, a Codasyl set represents a one-to-many relationship between records: one owner, many members. The fact that a record can be a member in many different sets is the key factor that distinguishes the network model from the earlier hierarchical model. As with records, each set belongs to a named set type (different set types model different logical relationships). Sets are in fact ordered, and the sequence of records in a set can be used to convey information. A record can participate as an owner and member of any number of sets.
...
Storage

IDMS organizes its databases as a series of files. These files are mapped and pre-formatted into so-called areas. The areas are subdivided into pages which correspond to physical blocks on the disk. The database records are stored within these blocks.

Now, if you don't know the difference between a 'logical data model'
and storage,
refer to my previous post.
Back to top
View user's profile Send private message
rasnc

New User


Joined: 31 Dec 2009
Posts: 10
Location: Bangalore

PostPosted: Fri Jan 01, 2010 11:07 am    Post subject:
Reply with quote

Thanks got the concept, just a small doubt is the IDMS record will be in same format of the normally record which is being used in the normal Flat file.
Back to top
View user's profile Send private message
rasnc

New User


Joined: 31 Dec 2009
Posts: 10
Location: Bangalore

PostPosted: Mon Jan 04, 2010 11:56 am    Post subject:
Reply with quote

Thanks, I got bit idea about SET, AREA and RECORD. An IDMS area is a preformatted file (or part of a file or parts of multiple files) Each area can contain occurrences of one or more record type. In the IDMS each entity like company, department and Employee along with their attribute are considered as record. IDMS support one too many relationship, this relationship is defined as set. Suppose for example if we consider Department and Employee set , its one too many relation one DEPARTMENT can have many employee. Department have its own record type like DEPT-ID,DEPT-NAME etc its record type. For example Set DEPARTMENT and EMPLOYEE may be found under same area or set DEPARTMENT may be under the area DEMO and EMPLOYEE may be under the area EMPL. Please correct me if my understand is wrong icon_redface.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Jan 04, 2010 3:00 pm    Post subject:
Reply with quote

Rashmi,

You need to do a bit of reading, you've a link given to you and you have google as your friend. To start with, people around here expects, at least, you to have the basic knowledge of the matter you asked for. And if you don't know that and just starting with teh subject, you should at least show how many source of inforation you've already looked in - what manual did you refer and what makes you to raise your eye brows, with that kind of commitment many will be around to help you...fwiw.
Back to top
View user's profile Send private message
rasnc

New User


Joined: 31 Dec 2009
Posts: 10
Location: Bangalore

PostPosted: Mon Jan 04, 2010 3:08 pm    Post subject: Reply to: Difference between area and sets
Reply with quote

Already i said just from 3 days i have started learning IDMS, I am not getting what exactly you are tellling. I told about set, area and record meaning thats all for that i am asking whether my understand is rite or wrong thats all
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Mon Jan 04, 2010 3:21 pm    Post subject: Reply to: Difference between area and sets
Reply with quote

Yes, You are wrong!

idms ( or any dbms ) datasets do not have any relation with those that You call flat files

flat files contain only application data
idms ( or any dbms ) datasets contain application data and control data
tha application data is what You see and use, control data is what is used by the dbms in order to provide its services

what is that You do not understand in the area explanation posted by Dick ??

areas are just containers not related in any way to the logical view of the application data
Back to top
View user's profile Send private message
rasnc

New User


Joined: 31 Dec 2009
Posts: 10
Location: Bangalore

PostPosted: Mon Jan 04, 2010 3:27 pm    Post subject: Reply to: Difference between area and sets
Reply with quote

Thanks a lot got
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 -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts Define Alias for multiple Data sets u... sandy98669 JCL & VSAM 4 Fri May 27, 2016 1:07 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm
No new posts Subschema of area to be unloaded Awanti IDMS/ADSO 0 Wed Mar 16, 2016 3:29 pm
No new posts ALTER of an IDMS AREA with NEW/OLD pa... Awanti IDMS/ADSO 2 Mon Mar 14, 2016 10:01 pm


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