Automic Workload Automation

 View Only

all_entities option in ucybdbun.ini

  • 1.  all_entities option in ucybdbun.ini

    Posted Dec 12, 2018 08:19 AM

    In ucybdbun.ini, there is an option called all_entities that changes how ucybdbun handles object attributes with no value.

    [TRANSPORT]
    all_Entities =

    The setting for the scope of the unloaded data in the Transport Case.

    This setting is important if the unloaded data is subsequently changed by using AE DB Change.

    Activate this setting if data is unloaded from the system client by means of a Transport Case which should subsequently be loaded to other clients.

    Values

    0Only object attributes that contain a value are exported.
    1The utility exports all object attributes regardless of their contents.

    Default: 0

     

    By default, the program omits from the transport case file records for any object attributes that have no value. This means that the transport case file will simply lack the corresponding records for database columns that have no values. If you want all DB columns to be included, even if they are empty, set all_entities=1 in the INI file.

     

    Here’s an example, just the OH table records for the static VARA object UC0.ALL.TEST#1_2.VARA_STATIC:

     

    With all_entitites=0 (abridged output)

    TOH
    F001+00001
    F002CVARA
    F003CUC0.ALL.TEST#1_2.VARA_STATIC
    F004+0002692005
    F006+0001015052
    F00720181212092425
    F008+0001015052
    F00920181212092425
    F010+0000000001
    F01220111115080353
    F019001
    F041M000000072 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
    F049+0000000908
    F063C00000000000000000000000000000000
    F068CSTATIC
    F072C11.2
    R

     

    With all_entitites=1 (full output)

    TOH
    F001+00001
    F002CVARA
    F003CUC0.ALL.TEST#1_2.VARA_STATIC
    F004+0002692005
    F005C
    F006+0001015052
    F00720181212092425
    F008+0001015052
    F00920181212092425
    F010+0000000001
    F011+0000000000
    F01220111115080353
    F013+0000000000
    F014+00000
    F015C
    F016000
    F017000
    F018000
    F019001
    F020+0000000000
    F021+00000
    F022+00000
    F023C
    F024C
    F027+0000000000
    F028+0000000000
    F029+0000000000
    F030C
    F031+00000
    F032C
    F033+0000000000
    F034+0000000000
    F035+00000
    F036+00000
    F037+00000
    F038+00000
    F039+0000000000
    F040+0000000000
    F041M000000072 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
    F042+0000000000
    F043+00000
    F044+0000000000
    F045+00000
    F046C
    F047C
    F048+0000000000
    F049+0000000908
    F050C
    F051+0000000000
    F052000
    F053000
    F054C
    F055C
    F056C
    F057C
    F058C
    F059C
    F060C
    F061000
    F062000
    F063C00000000000000000000000000000000
    F064000
    F065C
    F066000
    F067000
    F068CSTATIC
    F069+0000000000
    F070C
    F071C
    F072C11.2
    R

     

     

    Note that record F005 (OH_Title in the table OH) is missing from the abridged output, but present in the full output. This means the object has no Title set. The upshot of this is that ucybchng is able to change the title of the object in the full transport case file, but not in the abridged transport case file.

     

    For example, the change rule

    REPLACE VARA, UC0.ALL.TEST#1_2.VARA_STATIC, OBJECT_TITLE, '', 'New title'

    changes the F005 line when applied to the second file from

    F005C

    to

    F005CNew title

    However, if the same rule is applied to the first file, the change utility will not find the F005 record, and will therefore make no change. The change utility is unable to add a record if it is not already there. In this case, this means that the change utility cannot set or change the title of the object.

     

    Summary: The AE DB Change program ucybchng is unable to change attributes that are not present in the source file.

     

    If you want to be able to change all attributes, including blank ones,  set all_entities=1 in ucybdbun.ini before unloading the object(s).