IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

IMS Database design


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts What database does Jobtrac use CA Products 4
No new posts Capturing COBOL job and program names... All Other Mainframe Topics 2
No new posts Products/Tools to Optimize Adabas Dat... Compuware & Other Tools 2
No new posts AUTHORIZED database error in HALDB IMS DB/DC 2
No new posts linking an ALC program to a Relationa... PL/I & Assembler 1
Search our Forums:

Back to Top