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 *