Administration Guide > Utilities > AE DB Change > Modifying Exported Data

AE DB Change

Modifying Exported Data

Most of the objects which have been exported from the databaseA database is an organized collection of data including relevant data structures. using the Transport Case can then be modified with the utility AE DB Change. 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.

The documents about attributes contain the column Accesses. If this column includes "Change Program", the particular attribute can be changed with the utility using a script file which assigned at program call. This file contains the statements which serve to adjust the attributes which are included in the transport file.

Folder names can also be changed with AE DB Change. The relevant attribute is FOLDER_NAME in this case.

Ensure that the transport file contains all attributes which should be changed. This is done by setting the parameter shown below to "1" in the utility AE DB Unload's INI file:

[TRANSPORT]
all_entities=1

The effect is that attributes which do not contain values are also exported.

Procedure

Move all objects which should be adjusted to the Transport Case
Unload the Transport Case using the utility AE.DB Unload
Write one or several script files which contain the statements for attribute modifications
Call the utility AE DB Change with the corresponding start parameters

Calling the Program

Start the utility AE DB Change in batch mode which also provides for the background processing of large data amounts. Processing and results are logged. The logfile name is specified in the program's INI file.

Start the program from the command line 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 to be modified (by default UC_DATA.TXT)
Output file - includes the modified data

If the third parameter remains undefined, the name of the output file is the same as the name of the input file plus the ending "_New" or "_Neu", depending on the language specified with the parameter -L. Example: "uc_transport" (input file) becomes "uc_transport_New" (output file).

Example

ucybchng -b -1c:\transport\uc_change.txt -2c:\transport\uc_transport.txt -3c:\transport\uc_transport_new.txt

Return Codes

When processing has ended, the utility supplies a specific return code 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