RE: how many item master files is too many?

You'd be better off using the select count(*) as num_part from itemmast




-----Original Message-----
From: Stone, Joel [mailto:StoneJ@xxxxxxxxxxxxxxxx]
Sent: 09 February 2005 18:25
To: Midrange Systems Technical Discussion
Subject: how many item master files is too many?


I would like to find out if my company's database is a bit too complex (as
I'm sure many are).

One simple test I thought of comparing is: How many physical files of one
type are a company's server.

For a simple sampling of other companies, I would like to know how many item
master (product) files your company has on its AS/400.

If you would be able to provide this info (I will keep this anonomous of
course), I would be grateful.

Please do the following steps if you could:

1)      Identify the name of your item master file (to yourself), lets call
it ITEMMAST

2)    Find out the number of fields in the file ITEMMAST, call it #fields

3)    Find out the record length of ITEMMAST, call it reclen

4)      Run the following SQL statement

        runsql 'select * from qsys/qadbxref where dbxnfl=<#fields> and
dbxrdl=<reclen> and dbxatr=''PF'''


5)      jump to the bottom of the list

6)      make sure that the files appear to be actual item-master type files

6)      Email the number of records to me.


Thank you so much for your assistance!
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.