restoring tables from older TD releases deliver strange messages

Database
Fan

restoring tables from older TD releases deliver strange messages

Hello,

because of business reasons I had to restore some old data. The restore ran fine, but delivered some strange messages, as

"Warning ARC1257:A cross-release data restore requires that a Teradata SQL conversion script be run.  The

following steps must be performed:                

1) Log in as user DBC, and execute the following SQL

statement:                                          

CREATE MACRO DBC.DIPMarkNS120 AS (;);               

2) Execute one of the following conversion scripts:

post_data_restore.                                 

"

Does anyone know the meaning of this ? I could select from the restored table without doing anything else and I could insert the rows from the restored table into the target table without problems.

Why should I create an empty macro?

Where can I find this "post_data_restore" script?

Thank you

1 REPLY
Supporter

Re: restoring tables from older TD releases deliver strange messages

This thread might explain the what and why.

http://www.teradataforum.com/teradata/20101012_151552.htm

I found the script in 

/opt/teradata/tdat/tdbms/13.10.01.04/bin/post_data_restore


so it might be already on the server.

But might be best to discuss it with your support team.