× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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!

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.