I want to load files with names like abc18.dat,abc19.dat,.. to my teradata table.
the numeric part of file name is going to be two digits which is not known.
I cannot use abc*.dat because i have other files like abcdef.dat.
abc[0-9][0-9].dat is not working in TPT.
What are the alternatives?
If you can't move those files into an empty directory, you can use the FileList option:
Create a flat file first (e.g. using ls&grep on Linux) with all the file names and then use this in the FileList.