Re:Re: Record and set changes

[ca.portal.admin]

Hi Bill,

I must admit I know very little to nothing about assembler. The
fields will get initialized with values based on other data values so
I am afraid it must be updated via program. At least my programming
skills will get used again. :-)

Thanks for your help,
Petra

At 01:05 PM 1/10/2007, you wrote:

Hello Petra:

If you know assembler language you don't need a program to initialize the
fields, you can just modify the output of the Schema Compare and change

the

statements to the proper format for your new fields.

I'll look around for an example that I might have.

Bill Allen

In a message dated 1/10/2007 2:27:36 P.M. Eastern Standard Time,
[e-mail] writes:

I thought it might be the case. My program that initializes the data
would then cause the set to be updated and put in the proper order.

Thanks for your help.
Petra



At 12:10 PM 1/10/2007, you wrote:

I think the restructure puts the expanded records in the

new sequence in=0D=

=0Athe set=2E I always thought of restructure handling the

logical=0D=0Aorg=

anization of the database and unload/reload the physical org=2E I

dont=0D=

=0Athink you need to run an unload/reload unless you're also changing

the=

=0D=0Apage size or cleaning up

fragmentation=2E=0D=0A=0D=0ALutz Petzold=0D=

=0A=0D=0A=0D=0A=0D=0A=0D=0A-----------------------------------------=0D=0AT

=

his e-mail may contain confidential or privileged information=2E

If=0D=0Ayo=

u think you have received this e-mail in error, please advise

the=0D=0Asend=

er by reply e-mail and then delete this

e-mail immediately=2E=0D=0AThank yo=

u=2E Aetna=0D=0A

"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Record and set changes
"At 14:10 1/10/2007, you wrote:

I think the restructure puts the expanded records in the new sequence in
the set. I always thought of restructure handling the logical
organization of the database and unload/reload the physical org. I dont
think you need to run an unload/reload unless you're also changing the
page size or cleaning up fragmentation.

Lutz Petzold

no - a restructure will NEVER change a set pointer or a physical
location of a record (except as needed to fragment) - a successful
restructure will NOT replace the need for an unload/reload to resort
the set occurrances.


Chris Hoelscher
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Record and set changes
"Actually, an UNLD/RELD won't change set sort order for you, you'll have
to have a user-written program to do that.
(at least, the last time I did an UNLD/RELD in rels 14, sort order
wasn't changed)

Also, for IDMSRSTR, you can specify a value for a new field but it would
be the same value for each record.