Mload error table name ending with date like uv_tablename_<date>

General
Teradata Employee

Mload error table name ending with date like uv_tablename_<date>

Hi,

 

 

In Mload script, How can I give an error tables(et,uv,wt) name as suppose today's date is 02/02/2018. So my errortable name must be like "uv_tablename_02022018". I tried using system variables. But it doesn't work because TableName cannot have special character '/'.

How can I format the date in the script?

 

Any suggestion would be appreciated. Thanks in advance.

1 REPLY
Teradata Employee

Re: Mload error table name ending with date like uv_tablename_<date>

 

date +'%d%m%Y'

Above command withh return date as 02022018. You can the take it forward into MLoad script. Note that Mload supports OS command inside the script too.