[Urgent] - Change "tmp_" prefix used while generating alter script

[Former Member]

Hi All,

While generating Alter script, if "Backup Tables" option is selected, then PD renames existing table with "tmp_".

How can we change it to sth. else and also make it uppercase?

Using DBMS is DB2 for z/OS v10.

Using PD v16.5 SP04 PL04.

Thanks in advance.

Regards

Mehmet

[former_member182952]

Hi Memhet,

The script syntax is in the DBMS file which can be found by going to Tools---Resources---DMBS and selecting IBM DB2 Version 10 for z/OS.   From there you would open up to:

DB2MVS10::Script\Objects\Table

You can modify the values, however, make sure to save it as a new DBMS file in case you need to return to the default.

Unfortunately I am not sure what needs to be changed or if it's possible, but this is where you would start.

Adam