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

[Paola Groeber <pgroeber@xxxxxxxxxxxxx>]

Al,

You can go to the Pro-Data website and get more information on their most 
current release.  They also have a manual you can get with an upgrade to your 
version.  It's still the cheapest DBU tool on the market and very easy to use.  
Good Luck and sorry my suggestion couldn't be used.
Paola Groeber

aldg wrote:

> 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.