RE: DBU Problem: F1-KEY command doesn't work on DB file

Al,

The version number of DBU is displayed in the bottom left hand corner of the
screen; I do not remember how far back they have been doing this. Over the
years, we have tended to install the new versions of DBU into a new library
with the version number at the end; currently we have DBU60 for version 6.0.


Regards,
Jon Le Roi
Director of Information Systems
Tegal Corporation


-----Original Message-----
From: aldg [mailto:aldg@mail.rvi.net]
Sent: Monday, February 11, 2002 4:42 PM
To: mapics-l@midrange.com
Cc: Gershen, Al
Subject: Re: DBU Problem: F1-KEY command doesn't work on DB file


Hi Mapics ML:

I want to thank you all for your assistance in this matter.

I ended up using DFU to edit the file after I located the appropriate
Relative Record Numbers of the records I was correcting by putting the DB
file in Query/400 with no sorting.

Using this information, as Peter Vidal pointed out, I could have used this
information and done the editing with DBU.

I do have some specific comments to my assistors:

To Jim Wiedl:  Our company's version of DBU must be very old because it
doesn't behave as you suggested in your posting.  How do I find out the
verion of DBU that is in our system?  Isn't there a Control Language command
that will bring up this information?

To Peter Vidal:  Thanks for expanding on the DDS specs as mentioned by Jim
Wieldl.  I will pass this information to our Information Systems person and
get some implimentation guidance from him.

To Paola Groeber:  I tried using your suggestion and I'm afraid that the Cmd
6-SCN function is really over my head.  I'll have to study the help screen
more and see if I can get a better understanding of its function.  Thanks
for the suggestion.

Again to everyone, thanks for your timely comments and suggestions.

Regards,
Al Gershen
Grants Pass, OR
aldg@mail.rvi.net

---------- Original Reply Messages ----------

>From: "Jim Wiedl" <WIEDLJ@timesaversinc.com>
>Reply-To: mapics-l@midrange.com
>Date: Mon, 11 Feb 2002 13:25:30 -0600

>When viewing a file with DBU you can use cmd4 to see the keys to that file.
>From the same first screen cmd10 will give you a pop up menu and you can
expand the first option FILE.  Take a 7 for data base relations.  This will
show you all the logicals over your file.  If your file is in record number
order from the same pop up menu from cmd10 you can do a search for a value
in a particular field.  If you created the file via query it most likely
will not be indexed.  You may need to create dds specs with a defined key
and copy your query data into it.
>

From: Peter_Vidal@pall.com
Reply-To: mapics-l@midrange.com
Date: Mon, 11 Feb 2002 14:32:36 -0500

>
>"What is the difference between a "keyed" and "non-keyed" DB file?"
>If you are going to use this file regularly, you should create a DDS for
the
>file and select a field to be your key(s), for example:
>
>A                                      UNIQUE
>A          R BOOKR
>A            BIRPGR         3A         TEXT('REPORTING GROUP')
>A            BISHIP        13S 2       TEXT('SHIPPING AMOUNT')
>A          K BIRPGR
>
>Use UNIQUE to have non-repeated keys in your file; if you do not use
UNIQUE, you
>will still have a keyed file but you could have repeated keys in it.  A
>non-keyed file is simply a sequential file that you will have to roll
down-up if
>you use DBU for example.
>
>However, whenever you use Query/400 to create a file, it will be a
"non-keyed"
>file.
>
>"Is there any way to convert a "non-keyed" DB file into a "keyed" DB file?
"
>I do not know about a command that can do that but you can take the first
>approach that I mentioned or create a keyed file and copy over the data you
have
>created with Query/400.  This could be tricky so try to define your layout
based
>on the results of your query file or at least with the same field names.
You
>can use CPYF command with the *MAP option.
>
>"If there isn't a way to do this, I do I use DBU to go directly to a
specific
>record on a very large DB file?"
>You can still use DBU to access your file by relative record number.
>
>Peter Vidal
>Programmer Analyst
>PALL Aeropower Corp.
>

From: Paola Groeber <pgroeber@bellsouth.net>
Reply-To: mapics-l@midrange.com
Date: Mon, 11 Feb 2002 14:47:22 -0500

>If the inhouse DB file is not keyed, you can check to see if there is a
logical built over it by using F14.  This should bring up a list of the
logicals on the file or the file itself.  It lists the key fields used.
Once
>you have selected a keyed file, you can use the F6 key to position to a
specific record using the key fields that function key provides.
>
>Good luck.
>
>Paola Groeber
>Former MAPICS Business Analyst for CRM applications
>Also DBU Guru for over 12 years  :^)
>pgroeber@bellsouth.net
>
------End of Original Reply Messages------

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.