Hi JP, Thanks for your Quick response. I am a novice to HP3000 and I am in need of some additional information as well. Can you shed more light on the "Change the field specs from FROM to TO sizes - Adager, DBGeneral etc" that you have mentioned in your mail. I need to know how i could do this in ADAGER. Thanks for your valuable time and help, -Jay >From: NTC John Pitman <[log in to unmask]> >Reply-To: NTC John Pitman <[log in to unmask]> >To: [log in to unmask] >Subject: Re: [HP3000-L] Redefine the fields in TI >Date: Sun, 16 Jun 2002 14:11:13 +0300 > >Jay, > >If you mean that the data content actually maps ccorrectly to the layout in >the 'To' example, but is actually mis-mapped as in the 'FROM' example, I >think it can be done, maybe. First, do the fields GROUP, NAME, NUMBER and >FLAGS get used in other datasets, with incorrect lengths? If so, you are in >trouble if they are in other sequences. If always the same sequence as >below, maybe. > >Back up the database- COPY1 >do a Query FO SETS to hard copy >Change the field specs from FROM to TO sizes - Adager, DBGeneral etc, >whatever method. >Back it up again - COPY2 >Purge it >Restore the root file and all unaffected data sets from COPY2 >Restore the sets with changes from COPY1 >Do a Query FO SETS to hard copy and check BF are the same. > > >I have used this method before to re-map sets where there is no change in >entry length, or any field length changes. Note that if you use HP >DBUNLOAD/DBLOAD utilities, but the base had been modified with Adager in >the >past, the new base may have different blocking factors fromj the old, and >the restored COPY1 files may not work. If so, do Adager changes to make BF >the same, and it should work. > >jp > > >-----Original Message----- >From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On >Behalf Of Jay Chandru >Sent: Sun, June 16, 2002 11:42 AM >To: [log in to unmask] >Subject: [HP3000-L] Redefine the fields in TI > > >Hi All, >I need to Redefine the fields in the TI side. > >For Example, the following is the listing of my dataset. I want to change >it > > FROM > ****** >ITEMS: > KEYVALUE, X8 <<KEY ITEM>> > GROUP, X4 > NAME, X30 > NUMBER, X4 > FLAGS, X10 > > CAPACITY: 200 ENTRIES: 100 > > TO > **** >ITEMS: > KEYVALUE, X8 <<KEY ITEM>> > GROUP, X8 > NAME, X26 > NUMBER, X6 > FLAGS, X8 > > CAPACITY: 200 ENTRIES: 100 > >Pls. let me know how should i proceed about this. Also give me pointers to >documents if any. > >Thanks in advance >-Jay > > > > > >_________________________________________________________________ >Send and receive Hotmail on your mobile device: http://mobile.msn.com > >* To join/leave the list, search archives, change list settings, * >* etc., please visit http://raven.utc.edu/archives/hp3000-l.html * > >* To join/leave the list, search archives, change list settings, * >* etc., please visit http://raven.utc.edu/archives/hp3000-l.html * _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx * To join/leave the list, search archives, change list settings, * * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *