CA IDMS IUA EIUA

Re:Re: Record and set changes

  • 1.  Re:Re: Record and set changes

    Posted 01-10-2007 07:31 AM
    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,
    lafresep@U.ARIZONA.EDU 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
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    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
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    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.