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
 
IMS Database design

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

New User


Joined: 02 Jun 2003
Posts: 1

PostPosted: Sat Aug 16, 2003 9:33 am    Post subject: IMS Database design
Reply with quote

Hello All,
I have the following segments:
1. CUSTOMER MASTER with the fields:
Customer Code CUMCUSCDE Alphanumeric 5 Primary Key
Customer Name CUMCUSNME Alphanumeric 30
Address CUMCUSADD Alphanumeric 30
City CUMCUSCTY Alphanumeric 30
Region CUMCUSREG Alphanumeric 2
Country CUMCUSCNT Alphanumeric 30
Telephone CUMCUSTEL Alphanumeric 15

2. ITEM MASTER :
with the following fields:
Field Description Name Type Size Remarks

Item Code ITMCDE Alphanumeric 5 Primary Key
Item Description ITMDES Alphanumeric 30
Price ITMPRC Numeric 9,2
Stock on Hand ITMSTK Numeric 6,0

3. SALES ORDER HEADER with the following fields
Field Description Name Type Size Remarks

Sales Order Number SOHORDNUM Alphanumeric 6 Primary Key
Sales Order Date SOHDT Date 10 Alternate Key
Customer Code SOHCUSCDE Alphanumeric 5
Order Status SOHORDSTS Alphanumeric 1

4. SALES ORDER TRANSACTION :
Field Description Name Type Size Remarks

Sales Order Number SODORDNUM Alphanumeric 6
Item Code SODITMCDE Alphanumeric 5
Quantity Ordered SODQTY Numeric 6



Can any body guide on how to design the database for this? We thought of going like this
customer master ->sales order header -> sales order transaction -> item master
But we were adviced not to go for this. But for 2 data bases one with customer master as root and another with item master as root.
But from item master we need to retreive item details once we give customer code. If we go for the above design how will we retrieve?
Can you please advice?
Thanks and Regards,
Bindu
Back to top
View user's profile Send private message

maverick

New User


Joined: 13 Nov 2003
Posts: 2

PostPosted: Thu Nov 13, 2003 10:43 am    Post subject:
Reply with quote

The 2nd idea is right . You will need to create 2 databases
1. customer master ->sales order header -> sales order transaction
2. item master

Once you get the customer code . You will have to go to the sales order transaction for that customer to know what that customer has ordered Then for each item code you will have to do a GU on the item master database to get the details .
Back to top
View user's profile Send private message
b_ramu78

New User


Joined: 29 Apr 2005
Posts: 1
Location: hyd

PostPosted: Fri Apr 29, 2005 3:48 pm    Post subject: to eliminate duplicate records thru INTERNAL SORT
Reply with quote

Hi Guys,

Good morning!

I have an quick deliverable to be made and i need your help in it as i do not have time to look in to books. ..


Can some give me the code to eliminate the Duplicate records through Internal sort ( Sort should be done thru cobol program ) or any mechanism using a Cobol program ..


Thanks in Advance!

Regards,
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 Moving UDB database to Db2 on z/OS Keith Hooley DB2 4 Wed Sep 27, 2017 12:38 am
No new posts Design of ISPF panel prino TSO/ISPF 2 Wed Jan 25, 2017 10:31 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts Database access from COBOL amitmahalkar DB2 1 Wed Jan 27, 2016 11:33 am

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