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!!
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.