Transport Type

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
Transporting InfoSets
Transporting 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 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.

End of the example.

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 Note

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

End of the note.

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 select 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 select 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 select 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. The query user groups are of no relevance here. This transport type facilitates the transport of a modified InfoSet and all associated queries.

With the transport type Transport queries , all queries are transported according to the select option User groups and the select option Queries as well as the chosen Import option . Valid import options are REPLACE and GROUP=ug.

If, for example, you want to export the InfoSet FLBU and all the associated queries, you must make the following entries:

This graphic is explained in the accompanying text.

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 the table AQTDB, the export log still contains the name of the generated transport dataset, which matches the name of the generated transport request.