Newbie here. Wondering what the syntax for importing (via Mainframe MLOAD) a comma-separated, .csv, text in quotes file?
What I am currently doing (and don't wish to repeat again as it may affect data integrity) is replacing all of the commas in the source file with a '|' and then changing all the double-quotation marks (") to nothing. After that, I'm using the following lines to import: .IMPORT INFILE DDNAME FORMAT VARTEXT '|'
(where DDNAME is my import file).
This is all because the Alt-File-Import function via the Teradata SQL Assistant for .csv files is so unremarkably dreg ess (slow).
I'm extremely shocked that what MS Access loads in about three seconds over a network, Teradata takes hours via the built-in import function.