Wildcard characters in MLoad

Tools & Utilities
Teradata Employee

Wildcard characters in MLoad

Can you use Wildcard characters in a MLoad .Import statement?

Say I have several files I am MLOading together, like below. Is there a way of substituting a wildcard so that I would not have to list each file in an import statement?

.IMPORT INFILE "C:\Master_File_A"
FORMAT TEXT
LAYOUT Master_I
APPLY INSERTS Where ID_TYPE IN ('I','E' , 'B' ) ;

.IMPORT INFILE "C:\Master_File_B"
FORMAT TEXT
LAYOUT Master_I
APPLY INSERTS Where ID_TYPE IN ('I','E' , 'B' ) ;

.IMPORT INFILE "C:\Master_File_C"
FORMAT TEXT
LAYOUT Master_I
APPLY INSERTS Where ID_TYPE IN ('I','E' , 'B' ) ;

Is there a way of substituting a wildcard so that I would not have to list each file in an import statement? I tried this substitution, but got an error. Is there a way to do this in MLoad?

.IMPORT INFILE "C:\Master_File_*"
FORMAT TEXT
LAYOUT Master_I
APPLY INSERTS Where ID_TYPE IN ('I','E' , 'B' ) ;

3 REPLIES
Enthusiast

Re: Wildcard characters in MLoad

No!
Easiest way is to concatenate the files in JCL (for mainframe) or with a cat command in Linux/ Unix)
Teradata Employee

Re: Wildcard characters in MLoad

Or use Teradata Parallel Transporter that can load multiple files at the same time in parallel, and accepts the wildcard syntax. :)
-- SteveF
Teradata Employee

Re: Wildcard characters in MLoad

Thanks for the Responses!

Paul