Automation Engine DB Change
Administrators use the utility AE DB Change to modify exported data that has been exported from the database by using the Transport Case. Selected attributes of objects can be changed and strings in their scripts be replaced. Doing so simplifies the process of adjusting data to a different AE system or client.
This topic provides information on the following:
The links below include documentation topics for object-specific attributes. Refer to the section "Access Via" to see whether a particular attribute can be changed by using this utility. If so, you can use a script file to include commands for modifying attributes that are stored in the transport file.
For more details, see Syntax of Scripting Files
- File Transfer
- Notification
- Script
- Job
- Remote Task Manager
- Variable
- Event
- Job Group
- Schedule
- Workflow
You can also change folder names with AE DB Change. The relevant attribute is FOLDER_NAME in this case.
Make sure that the transport file contains all attributes that should be changed. You can ensure this by setting the parameter all_entities= to "1" in the utility AE DB Unload's INI file:
[TRANSPORT]
all_entities=1
Setting this parameter means that attributes that do not contain values are also exported.
- Move all objects that should be adjusted to the Transport Case.
- Unload the Transport Case by using the utility AE.DB Unload.
- Write one or several script files that include the commands for attribute modifications
- Call the utility AE DB Change with the corresponding start parameters
For detailed information, see Transporting Data
You need to start the utility AE DB Change in batch mode. This allows that even huge data amounts are processed in the background. Processing and results are logged in a file whose name you can specify in the utility's INI file.
Start the program from the command line by using the following parameters:
UCYBCHNG[.EXE] [-B] [-IPath and name of the INI file] -1Script File-2Transport file[-3Output file][-LE]
The parameter -B starts the program in batch mode. -I serves to specify the INI file's path and name. Complete path specifications are required for the files. The parameter -L is used to determine the log file's language.
- Script file: Contains the modification commands
- Transport file: Contains the objects that should be modified. UC_DATA.TXT is used by default.
- Output file: Includes the modified data
If you do no define this parameter, the name of the output file is the same as the name of the input file plus the ending "_New". This depends on the language that you specified with the parameter -L. For example, the input file "uc_transport" will be the output file "uc_transport_New".
Example
ucybchng -b -1c:\transport\uc_change.txt -2c:\transport\uc_transport.txt -3c:\transport\uc_transport_new.txt
The utility returns specific return codes when processing has ended, depending on the occurred situation.
Return code |
Description |
---|---|
0 |
The utility has successfully ended processing. |
1 |
The transport file does not exist or cannot be opened. |
2 |
The script file does not exist or cannot be opened. |
3 |
The transport and the script file do not exist or cannot be opened. |
4 |
The output file cannot be opened. |
5 | The script file includes an error (see log file). |
21400 | EXIT_CODE_NOT_A_TRANSPORT_FILE |
21424 | EXIT_CODE_NO_DATA_IN_TRANSPORT_FILE |
21432 | EXIT_CODE_INVALID_VERSION_TRANSPORT_CASE |
21433 | EXIT_CODE_TOO_FEW_PARAMETERS |
See also: