Show TOC

Transport TypeLocate this document in the navigation structure

Use

There are four different ways you can select the objects (user groups, InfoSets, queries) to be transported. They are covered by the following transport types:

  • Transport user groups

  • Transport InfoSets

  • Transport InfoSets and queries

  • Transport queries

You first select no more than one of these transport types. Then, you make further specifications according to the transport type chosen. Each transport type has its own input fields.

For each transport dataset, you define an import option according to the relevant transport type. The import option determines the method used to insert the transport dataset in the table AQLDB of the target client during a later import.

Import option REPLACE

The import option REPLACE is the most frequently used option. If there is already a query component with the same name in the target system, this is overwritten by the corresponding component of the exporting system.

The import option REPLACE is available for all query object types.

Import option MERGE

It can occasionally be useful to use the option MERGE. In this case, the elements of the two query components with the same name are combined in the target system. Elements of query components with the same name are, however, still overwritten with the values of the exporting system.

Example

For example: A user group UG_01 contains the users a, b, c, and d in the exporting system. In the target system, the user group already exists, and contains the users c, d, e, and f. After a transport with the option MERGE, the group contains the users a, b, c, d, e, and f, where elements c and d are those from the exporting system. Only one data record is retained for each element with the same name. You need to take this into account if the data records in the two systems are different despite having the same name.

The import option MERGE is not available for the object type Query, but all other object types can be imported in this way.

Import option GROUP

If you are transporting either InfoSets or Queries separately, you can use the import option GROUP to define the user group of the target system to which the transported objects are to be assigned. To do this, specify the name of the corresponding user group in the target system. You can, of course, also make the same assignment yourself in a subsequent step in the target system.

Import option UNASSIGN

The import option UNASSIGN, which is available only for InfoSets, removes the connections between an InfoSet and all associated user groups. You then need to make an assignment in the target system to the user groups that exist there.

Note

Additional information is also available directly in the system, by choosing the Info button in the query transport tool.

You can use the following abbreviations for the individual import options:

Import Option

Abbreviation

REPLACE

R

MERGE

M

GROUP=ug (ug = User GroupName)

G=ug

UNASSIGN

U

  • With the transport type Transport User Groups, all user groups are transported according to the selection option User Groups and the chosen Import Option. Valid import options are REPLACE and MERGE.

  • With the transport type Transport InfoSets, all InfoSets are transported according to the selection option InfoSets and the chosen Import Option. Valid import options are REPLACE, MERGE, GROUP=ug and UNASSIGN.

  • With the transport type Transport InfoSets and Queries, all InfoSets are transported according to the selection option InfoSets and the chosen Import Option. Valid import options are REPLACE and MERGE. Furthermore, all queries are transported according to the select option Queries, which use the InfoSet, for each of the InfoSets selected in this way. The query user groups are of no relevance here. Only the REPLACE import option is permitted for these queries. This transport type makes it possible to transport a changed InfoSet and all affected queries.

  • With the transport type Transport Queries, all queries are transported according to the selection options User Groups and Queries. Valid import options are REPLACE and GROUP=ug.

You get an export log in the export result. The export log shows which objects (queries, InfoSets, user groups) are exported and which import option is used to import each object during a later import. If you export data to table AQTDB, the export log still contains the name of the generated transport dataset, which matches the name of the generated transport request.