(Glue-2011) Change Scenarios of Glue Objects
- SNP
- Marian Vidra
Glue Transport Management enables you also to change Glue objects on the target system.
In the table below you can find a more detailed description of particular scenarios.
| Glue object | Scenario | Status | Notes |
|---|---|---|---|
| Table | Append fields to a Glue table |  | Columns are appended (added to the end of the table). If applied, Datavard Glue also adjusts the extractor automatically without any need to transport it. If a field was added only to an external storage table, the source field is empty. If a field was added to a SAP source table, it's mapped to a new field in the Glue table. |
| Recreate a table structure |  | If you deactivate a table or add fields to the middle of the table structure and then activate and transport it to another system, you will receive an error. This error occurs, as adding fields to the middle of the structure isn't valid ALTER TABLE operation. To recreate a table structure, delete the original table from the target system using a deletion transport and then import the modified table using a standard transport mechanism. | |
| Remove fields | | Removing a field from a Glue table requires deactivation of the table. This means that you must follow the same procedure as described above. | |
| Modify File storage options | | Modification of File storage options is possible except for changing the Container name parameter. To modify it, delete the original table from the target system using a deletion transport and then import the table with the modified container name using a standard transport mechanism. | |
Extractor | Add routines | | |
| Add selection fields | | ||
Add source fields | | ||
| Change Skip initial Full load | | The value of Skip initial Full load flag will stay unchanged on the target system | |
Variant | Change package size | | |
| Change the select option values | |