Data Access Error

[Pickering, John (NORBORD)]

Jamie

Non HP3000 folks stop reading now :-)

I'll assume that the part number is a key. Now, is any of the datasets
involved a manual master? If yes, then you will be unable to change the key
value of any records in any of the detail sets without first creating an
entry with the new key value in the manual master. And you'll be unable to
delete or change the key value of the record in the manual master if any
records exist for that key in any of the detail sets.

So, first create your new manual master entry as a copy of the old entry but
with the new key value. Then change the keys on all the detail sets. Then
delete the old manual master entries. 

Or you can unload all the sets into subfiles, erase the datasets involved
(assuming you have DBGeneral or Adage) and then reload the data from the
subfiles, changing the key values on the way in. This method might be better
from an Image internals point of view as you can sort the data before you
write it and you'll get a tidier result.

Minor grumble to Cognos: "DATA ACCESS ERROR" is such a helpful error message
:-( One of the casualties of the "all platforms" versions was the meaningful
error messages.

Regards,
JWP

> -----Original Message-----
> From:	Jamie Harwood [SMTP:jamie.harwood@caddock.com]
> Sent:	Friday, February 15, 2002 10:34 AM
> To:	powerh-l@lists.swau.edu
> Subject:	Data Access Error
> 
> Hi all- I need to update a BUNCH of old data to standardize part numbers -
> my problem is that I get DATA ACCESS ERRORS when trying to update
> linkitems
> in data sets. Can I ignore that somehow for this operation? There are 6
> datasets all intermingled with the part number. Any experience with a mess
> like this? Quiz version 8.19.c1, IMAGE database, Omnidex keys...
> 
> __________________________________________________
> Jamie Harwood
>  IS Manager
>  Caddock Electronics, Inc
>  (909) 788-1700 x2244
>  High Performance Film Resistors
>  jamie.harwood@caddock.com
>  http://www.caddock.com
>