Issues during Importing pipe delimited vartext file using MLOAD

Tools
Enthusiast

Issues during Importing pipe delimited vartext file using MLOAD

Hi,

I have to load data from Netezza tables to Teradata. I am using the nzsql command to export the data into a unix file (pipe delimited,vartext) and then want to use the MLOAD to load the tables. 

In my MLOAD script, I am facing issues while using the .table command to load the structure  and then using the format vartext '|' . As there are integer columns thereby the MLOAD is failing.Can someone please suggest any workaround for this problem.

I do not want to hardcode the fields as I would like to use the same scripts to load multiple tables with different files in loop using unix. The same script is working for indicdata file but I don't think we can export in indic format from Netezza. 

Please suggest if it can be done using fastload.

Thanks in Advance!!

1 REPLY
Teradata Employee

Re: Issues during Importing pipe delimited vartext file using MLOAD

You are not able to load using ".table" command because there is/are some columns that is/are not "VARCHAR" data type(s). Delimited data that are given as input with VARTEXT format need to be defined as VARCHAR in define/layout clause. 

If you cannot hardcode layout then use a temporary table.